The Database API functions similarly to the Data Access Layer (DAL) but is more convenient to use and works with multiple connections. As DAL is deprecated, we recommend using the Database API.
Methods
Method |
Description |
Sets the current database link when working with multiple database connections. |
|
Executes an SQL query using the current active connection. |
|
Executes an SQL Query that returns data. |
|
Returns the last inserted autoincrement field value under the current connection. |
|
Returns the last error message under the current connection. |
|
Adds records to the database. |
|
Updates records in the database. |
|
Deletes records from the database. |
|
Retrieves data from the database. |
|
Prepares an SQL query to use with SQL variables. |
|
Executes a SQL query passed as a parameter. Returns the first value of the first entry or null if nothing is found. |
Error handling
Database API functions will not stop execution after encountering a SQL error. To properly handle errors use LastError() function.
If you need your code to break in case of a SQL error you can use old-style functions like CustomQuery().
See also:
•QueryResult object: fetchNumeric()
•QueryResult object: fetchAssoc()
