drop_column($table, $column_name) Parameters: $table (string) – Table name $column_name (array) – The column name to drop Returns: TRUE on success, FALSE on failure Return type: bool Drops a column from a table. Usage: See Dropping a Column From a Table.

group_by($by[, $escape = NULL]) Parameters: $by (mixed) – Field(s) to group by; string or array Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a GROUP BY clause to a query.

order_by($orderby[, $direction = ''[, $escape = NULL]]) Parameters: $orderby (string) – Field to order by $direction (string) – The order requested - ASC, DESC or random $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds an ORDER BY clause to a query.

make_columns([$array = array()[, $col_limit = 0]]) Parameters: $array (array) – An array containing multiple rows’ data $col_limit (int) – Count of columns in the table Returns: An array of HTML table columns Return type: array This method takes a one-dimensional array as input and creates a multi-dimensional array with a depth equal to the number of columns desired. This allows a single array with many elements to be displayed in a table that has a fixed column count. Consider thi

table_exists($table_name) Parameters: $table_name (string) – The table name Returns: TRUE if that table exists, FALSE if not Return type: bool Determine if a particular table exists.

report([$result = array()]) Parameters: $result (array) – Array containing tests results Returns: Test report Return type: string Generates a report about already complete tests.

class CI_Security xss_clean($str[, $is_image = FALSE]) Parameters: $str (mixed) – Input string or an array of strings Returns: XSS-clean data Return type: mixed Tries to remove XSS exploits from the input data and returns the cleaned string. If the optional second parameter is set to true, it will return boolean TRUE if the image is safe to use and FALSE if malicious data was detected in it. sanitize_filename($str[, $relative_path = FALSE]) Parameters: $str (string) – File

class CI_Form_validation set_rules($field[, $label = ''[, $rules = '']]) Parameters: $field (string) – Field name $label (string) – Field label $rules (mixed) – Validation rules, as a string list separated by a pipe “|”, or as an array or rules Returns: CI_Form_validation instance (method chaining) Return type: CI_Form_validation Permits you to set validation rules, as described in the tutorial sections above: Setting Validation Rules Saving Sets of Validation Rules to a Config F

data_seek([$n = 0]) Parameters: $n (int) – Index of the results row to be returned next Returns: TRUE on success, FALSE on failure Return type: bool Moves the internal results row pointer to the desired offset. Usage: see Result Helper Methods.

set_insert_batch($key[, $value = ''[, $escape = NULL]]) Parameters: $key (mixed) – Field name or an array of field/value pairs $value (string) – Field value, if $key is a single field $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds field/value pairs to be inserted in a table later via insert_batch().