update_batch($table[, $set = NULL[, $value = NULL[, $batch_size = 100]]]) Parameters: $table (string) – Table name $set (array) – Field name, or an associative array of field/value pairs $value (string) – Field value, if $set is a single field $batch_size (int) – Count of conditions to group in a single query Returns: Number of rows updated or FALSE on failure Return type: mixed Compiles and executes batch UPDATE statements. Note When more than $batch_size field/value pairs are

Any software application requires some effort to learn. We’ve done our best to minimize the learning curve while making the process as enjoyable as possible. The first step is to install CodeIgniter, then read all the topics in the Introduction section of the Table of Contents. Next, read each of the General Topics pages in order. Each topic builds on the previous one, and includes code examples that you are encouraged to try. Once you understand the basics you’ll be ready to explore the Class

form_open_multipart([$action = ''[, $attributes = array()[, $hidden = array()]]]) Parameters: $action (string) – Form action/target URI string $attributes (array) – HTML attributes $hidden (array) – An array of hidden fields’ definitions Returns: An HTML multipart form opening tag Return type: string This function is absolutely identical to form_open() above, except that it adds a multipart attribute, which is necessary if you would like to use the form to upload files with.

or_like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) Parameters: $field (string) – Field name $match (string) – Text portion to match $side (string) – Which side of the expression to put the ‘%’ wildcard on $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a LIKE clause to a query, separating multiple class with OR.

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.