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

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_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.

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.

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

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_complete() Returns: TRUE on success, FALSE on failure Return type: bool Complete Transaction.

simple_query($sql) Parameters: $sql (string) – The SQL statement to execute Returns: Whatever the underlying driver’s “query” function returns Return type: mixed A simplified version of the query() method, appropriate for use when you don’t need to get a result object or to just send a query to the database and not care for the result.

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