repair_table($table_name) Parameters: $table_name (string) – Name of the table to repair Returns: Array of repair messages or FALSE on failure Return type: array Repairs a database table.

num_fields() Returns: Number of fields in the result set Return type: int Returns the number of fields in the result set. Usage: see Result Helper Methods.

flush_cache() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Empties the Query Builder cache.

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

clean() Returns: TRUE on success, FALSE on failure Return type: bool This method will ‘clean’ the entire cache. If the deletion of the cache files fails, the method will return FALSE. $this->cache->clean();

class CI_URI segment($n[, $no_result = NULL]) Parameters: $n (int) – Segment index number $no_result (mixed) – What to return if the searched segment is not found Returns: Segment value or $no_result value if not found Return type: mixed Permits you to retrieve a specific segment. Where n is the segment number you wish to retrieve. Segments are numbered from left to right. For example, if your full URL is this: http://example.com/index.php/news/local/metro/crime_is_up The segment

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.

class CI_DB_driver initialize() Returns: TRUE on success, FALSE on failure Return type: bool Initialize database settings, establish a connection to the database. db_connect($persistent = TRUE) Parameters: $persistent (bool) – Whether to establish a persistent connection or a regular one Returns: Database connection resource/object or FALSE on failure Return type: mixed Establish a connection with the database. Note The returned value depends on the underlying driver in use.

initialize() Returns: TRUE on success, FALSE on failure Return type: bool Initialize database settings, establish a connection to the database.

class CI_Table $function = NULL Allows you to specify a native PHP function or a valid function array object to be applied to all cell data. $this->load->library('table'); $this->table->set_heading('Name', 'Color', 'Size'); $this->table->add_row('Fred', '<strong>Blue</strong>', 'Small'); $this->table->function = 'htmlspecialchars'; echo $this->table->generate(); In the above example, all cell data would be ran through PHP’s htmlspecialchars() f