CI_DB_query_builder::or_like()

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.

CI_DB_query_builder::or_group_start()

or_group_start() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Starts a group expression, using ORs for the conditions inside it.

CI_DB_query_builder::or_not_like()

or_not_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 NOT LIKE clause to a query, separating multiple calls with OR.

CI_DB_query_builder::or_not_group_start()

or_not_group_start() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Starts a group expression, using OR NOTs for the conditions inside it.

CI_DB_query_builder::limit()

limit($value[, $offset = 0]) Parameters: $value (int) – Number of rows to limit the results to $offset (int) – Number of rows to skip Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds LIMIT and OFFSET clauses to a query.

CI_DB_query_builder::offset()

offset($offset) Parameters: $offset (int) – Number of rows to skip Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds an OFFSET clause to a query.

CI_DB_query_builder::not_group_start()

not_group_start() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Starts a group expression, using AND NOTs for the conditions inside it.

CI_DB_query_builder::not_like()

not_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 NOT LIKE clause to a query, separating multiple calls with AND.

CI_DB_query_builder::order_by()

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.

CI_DB_query_builder::insert_batch()

insert_batch($table[, $set = NULL[, $escape = NULL[, $batch_size = 100]]]) Parameters: $table (string) – Table name $set (array) – Data to insert $escape (bool) – Whether to escape values and identifiers $batch_size (int) – Count of rows to insert at once Returns: Number of rows inserted or FALSE on failure Return type: mixed Compiles and executes batch INSERT statements. Note When more than $batch_size rows are provided, multiple INSERT queries will be executed, each trying to