database

This object is the connector to the database called db.

Internal Values

Internally, it uses two variables: db_this and db_result to store the connection to the database and the result obtained, respectively.

Functions/Methods

Function and procedure names are preceded by the prefix db, which is the same name as the returned connector object.

dbError

Returns the error code and type if one occurs.

dbType

Returns the type of database used (is it necessary?)

dbLogin

Connects to the database, sets the use of UTF8 for data storage, and creates the corresponding connector. It uses four internal values, which are set during system installation.

DBHOST

Database server. Usually localhost.

DBUSER

Database user. All permissions for administrator, restricted permissions for user.

DBPWD

Password

DBNAME

Database name

Although the structure of the function is the same, it is important to remember that the system handles two types of database users. One has full permissions and is used by system administrators. The remaining accounts use restricted permissions.

dbPrefix

Returns the table prefix; it is also configured when the system is installed.

DBPREFIX

Prefix of tables belonging to siteup

dbQuery

Executes a SQL operation

dbClearQuotes

Receives an array of data, prefixed with a backslash (\) before quotation marks and double quotes. While there are instructions that replace HTML entities with their equivalent, this is restricted to those two cases only.
Returns the same array with the corresponding modifications.

dbFilter2Sql

Receives a JSON containing the filters to be applied to a query, returning the corresponding SQL.

dbResult

Obtains the result of the query execution. By default, all results are stored in the corresponding variable, although using rows as a parameter indicates the number of results; If free is used, it frees the results obtained.

dbFetch

Returns each of the records, which is why this statement must be in a loop. By default, the result is returned as an array, although if the word hash is specified as a parameter, it returns the record as an array indexed by the word, the word being the column name.

dbLogout

Closes the connection to the database