The CDatabase class is used to work with the database.
When a page is created, an object $DB of the class CDatabase is automatically created. You must use this object to perform any operation on the database.
Methods
| Method |
Description |
| ForSql |
Prepares the string for insertion into an SQL query. |
| Query |
Performs a query to the database and returns the query result. |
| QueryBind |
Executes SQL queries like "UPDATE" or "INSERT" that require variable binding. |
| QueryBindSelect |
Executes a "SELECT" SQL query that require variable binding. |
| Update |
Updates records in the table with the values passed. |
| NextID |
Returns the next value from the sequence. |
| Insert |
Inserts a record with fields to the table. |
| LastID |
Returns the ID of the last added record. |
| PrepareFields |
Prepares global variables for insertion in an SQL query. |
| PrepareInsert |
Prepares an array of the two strings for issuing an SQL query used to insert a record in the database. |
| PrepareUpdate |
Prepares an string for issuing an SQL query used to update a record in the database. |
| InitTableVarsForEdit |
Creates global variables used for the display. |
| ParseSqlBatch |
Parses the string containing a bundle of queries. |
| RunSqlBatch |
Executes a set of queries contained in the file. |
| StartTransaction |
Open a transaction. |
| Commit |
Commits the commenced transaction. |
| Rollback |
Rolls back all changes made by the incomplete open transaction. |
| Connect |
Opens a connection to the database. |
| Disconnect |
Closes the previously opened connection to the database. |
Date and time handling methods
See Also