trans_off() Return type: void Disables transactions at run-time.

total_queries() Returns: The total number of queries executed Return type: int Returns the total number of queries that have been executed so far.

query($sql[, $binds = FALSE[, $return_object = NULL]]) Parameters: $sql (string) – The SQL statement to execute $binds (array) – An array of binding data $return_object (bool) – Whether to return a result object or not Returns: TRUE for successful “write-type” queries, CI_DB_result instance (method chaining) on “query” success, FALSE on failure Return type: mixed Execute an SQL query. Accepts an SQL string as input and returns a result object upon successful execution of a “read”

list_tables([$constrain_by_prefix = FALSE]) Parameters: $constrain_by_prefix (bool) – TRUE to match table names by the configured dbprefix Returns: Array of table names or FALSE on failure Return type: array Gets a list of the tables in the current database.

reconnect() Returns: TRUE on success, FALSE on failure Return type: bool Keep / reestablish the database connection if no queries have been sent for a length of time exceeding the server’s idle timeout.

protect_identifiers($item[, $prefix_single = FALSE[, $protect_identifiers = NULL[, $field_exists = TRUE]]]) Parameters: $item (string) – The item to work with $prefix_single (bool) – Whether to apply the dbprefix even if the input item is a single identifier $protect_identifiers (bool) – Whether to quote identifiers $field_exists (bool) – Whether the supplied item contains a field name or not Returns: The modified item Return type: string Takes a column or table name (optionally

platform() Returns: Platform name Return type: string The name of the platform in use (mysql, mssql, etc...).

primary($table) Parameters: $table (string) – Table name Returns: The primary key name, FALSE if none Return type: string Retrieves the primary key of a table. Note If the database platform does not support primary key detection, the first column name may be assumed as the primary key.

list_fields($table) Parameters: $table (string) – The table name Returns: Array of field names or FALSE on failure Return type: array Gets a list of the field names in a table.

last_query() Returns: The last query executed Return type: string Returns the last query that was executed.