add_column($table[, $field = array()[, $_after = NULL]]) Parameters: $table (string) – Table name to add the column to $field (array) – Column definition(s) $_after (string) – Column for AFTER clause (deprecated) Returns: TRUE on success, FALSE on failure Return type: bool Adds a column to a table. Usage: See Adding a Column to a Table.

class CI_DB_forge add_column($table[, $field = array()[, $_after = NULL]]) Parameters: $table (string) – Table name to add the column to $field (array) – Column definition(s) $_after (string) – Column for AFTER clause (deprecated) Returns: TRUE on success, FALSE on failure Return type: bool Adds a column to a table. Usage: See Adding a Column to a Table. add_field($field) Parameters: $field (array) – Field definition to add Returns: CI_DB_forge instance (method chaining

version() Returns: The version of the database being used Return type: string Database version number.

update_string($table, $data, $where) Parameters: $table (string) – The target table $data (array) – An associative array of key/value pairs $where (mixed) – The WHERE statement conditions Returns: The SQL UPDATE statement, as a string Return type: string Generate an UPDATE statement string.

trans_strict([$mode = TRUE]) Parameters: $mode (bool) – Strict mode flag Return type: void Enable/disable transaction “strict” mode. When strict mode is enabled, if you are running multiple groups of transactions and one group fails, all subsequent groups will be rolled back. If strict mode is disabled, each group is treated autonomously, meaning a failure of one group will not affect any others.

trans_status() Returns: TRUE if the transaction succeeded, FALSE if it failed Return type: bool Lets you retrieve the transaction status flag to determine if it has failed.

trans_start([$test_mode = FALSE]) Parameters: $test_mode (bool) – Test mode flag Returns: TRUE on success, FALSE on failure Return type: bool Start a transaction.

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

trans_complete() Returns: TRUE on success, FALSE on failure Return type: bool Complete Transaction.

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