PHP Class CI_DB_query_builder, TastyIgniter

This is the platform-independent base Query Builder implementation class.
See link: http://codeigniter.com/user_guide/database/
Author: EllisLab Dev Team
Inheritance: extends CI_DB_driver
Afficher le fichier Open project: tastyigniter/tastyigniter Class Usage Examples

Protected Properties

Свойство Type Description
$qb_aliased_tables array QB aliased tables list
$qb_cache_exists array QB Cache exists list
$qb_cache_from array QB Cache FROM data
$qb_cache_groupby array QB Cache GROUP BY data
$qb_cache_having array QB Cache HAVING data
$qb_cache_join array QB Cache JOIN data
$qb_cache_no_escape array QB Cache No Escape data
$qb_cache_orderby array QB Cache ORDER BY data
$qb_cache_select array QB Cache SELECT data
$qb_cache_set array QB Cache data sets
$qb_cache_where array QB Cache WHERE data
$qb_caching boolean QB Caching flag
$qb_distinct boolean QB DISTINCT flag
$qb_from array QB FROM data
$qb_groupby array QB GROUP BY data
$qb_having array QB HAVING data
$qb_join array QB JOIN data
$qb_keys array QB keys
$qb_limit integer QB LIMIT data
$qb_no_escape array QB No Escape data
$qb_offset integer QB OFFSET data
$qb_orderby array QB ORDER BY data
$qb_select array QB SELECT data
$qb_set array QB data sets
$qb_where array QB WHERE data
$qb_where_group_count integer QB WHERE group count
$qb_where_group_started boolean QB WHERE group started flag
$reset_delete_data boolean Reset DELETE data flag
$return_delete_sql boolean Return DELETE SQL flag

Méthodes publiques

Méthode Description
count_all_results ( $table = '', $reset = TRUE ) : integer "Count All Results" query
dbprefix ( $table = '' ) : string DB Prefix
delete ( $table = '', $where = '', $limit = NULL, $reset_data = TRUE ) : mixed Delete
distinct ( boolean $val = TRUE ) : CI_DB_query_builder DISTINCT
empty_table ( $table = '' ) : boolean Empty Table
flush_cache ( ) : CI_DB_query_builder Flush Cache
from ( mixed $from ) : CI_DB_query_builder From
get ( $table = '', $limit = NULL, $offset = NULL ) : CI_DB_result Get
get_compiled_delete ( $table = '', $reset = TRUE ) : string Get DELETE query string
get_compiled_insert ( $table = '', $reset = TRUE ) : string Get INSERT query string
get_compiled_select ( $table = '', $reset = TRUE ) : string Get SELECT query string
get_compiled_update ( $table = '', $reset = TRUE ) : string Get UPDATE query string
get_where ( string $table = '', string $where = NULL, integer $limit = NULL, integer $offset = NULL ) : CI_DB_result Get_Where
group_by ( string $by, boolean $escape = NULL ) : CI_DB_query_builder GROUP BY
group_end ( ) : CI_DB_query_builder Ends a query group
group_start ( string $not = '', string $type = 'AND ' ) : CI_DB_query_builder Starts a query group.
having ( string $key, string $value = NULL, boolean $escape = NULL ) : CI_DB_query_builder HAVING
insert ( $table = '', $set = NULL, boolean $escape = NULL ) : boolean Insert
insert_batch ( string $table, array $set = NULL, boolean $escape = NULL, $batch_size = 100 ) : integer Insert_Batch
join ( $table, $cond, $type = '', $escape = NULL ) : CI_DB_query_builder JOIN
like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder LIKE
limit ( integer $value, integer $offset ) : CI_DB_query_builder LIMIT
not_group_start ( ) : CI_DB_query_builder Starts a query group, but NOTs the group
not_like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder NOT LIKE
offset ( integer $offset ) : CI_DB_query_builder Sets the OFFSET value
or_group_start ( ) : CI_DB_query_builder Starts a query group, but ORs the group
or_having ( string $key, string $value = NULL, boolean $escape = NULL ) : CI_DB_query_builder OR HAVING
or_like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder OR LIKE
or_not_group_start ( ) : CI_DB_query_builder Starts a query group, but OR NOTs the group
or_not_like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder OR NOT LIKE
or_where ( $key, $value = NULL, $escape = NULL ) : CI_DB_query_builder OR WHERE
or_where_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder OR WHERE IN
or_where_not_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder OR WHERE NOT IN
order_by ( string $orderby, string $direction = '', boolean $escape = NULL ) : CI_DB_query_builder ORDER BY
replace ( $table = '', $set = NULL ) : boolean Replace
reset_query ( ) : CI_DB_query_builder Reset Query Builder values.
select ( $select = '*', $escape = NULL ) : CI_DB_query_builder Select
select_avg ( $select = '', $alias = '' ) : CI_DB_query_builder Select Average
select_max ( $select = '', $alias = '' ) : CI_DB_query_builder Select Max
select_min ( $select = '', $alias = '' ) : CI_DB_query_builder Select Min
select_sum ( $select = '', $alias = '' ) : CI_DB_query_builder Select Sum
set ( $key, $value = '', $escape = NULL ) : CI_DB_query_builder The "set" function.
set_dbprefix ( $prefix = '' ) : string Set DB Prefix
set_insert_batch ( $key, $value = '', $escape = NULL ) : CI_DB_query_builder The "set_insert_batch" function. Allows key/value pairs to be set for batch inserts
set_update_batch ( $key, $index = '', $escape = NULL ) : CI_DB_query_builder The "set_update_batch" function. Allows key/value pairs to be set for batch updating
start_cache ( ) : CI_DB_query_builder Start Cache
stop_cache ( ) : CI_DB_query_builder Stop Cache
truncate ( $table = '' ) : boolean Truncate
update ( string $table = '', array $set = NULL, mixed $where = NULL, integer $limit = NULL ) : boolean UPDATE
update_batch ( $table, $set = NULL, $index = NULL, $batch_size = 100 ) : integer Update_Batch
where ( $key, $value = NULL, $escape = NULL ) : CI_DB_query_builder WHERE
where_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder WHERE IN
where_not_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder WHERE NOT IN

Méthodes protégées

Méthode Description
_compile_group_by ( ) : string Compile GROUP BY
_compile_order_by ( ) : string Compile ORDER BY
_compile_select ( boolean $select_override = FALSE ) : string Compile the SELECT statement
_compile_wh ( string $qb_key ) : string Compile WHERE, HAVING statements
_create_alias_from_table ( string $item ) : string Determines the alias name based on the table
_delete ( $table ) : string Delete statement
_from_tables ( ) : string FROM tables
_group_get_type ( string $type ) : string Group_get_type
_insert_batch ( string $table, array $keys, array $values ) : string Insert batch statement
_is_literal ( string $str ) : boolean Is literal
_like ( mixed $field, string $match = '', string $type = 'AND ', string $side = 'both', string $not = '', boolean $escape = NULL ) : CI_DB_query_builder Internal LIKE
_limit ( string $sql ) : string LIMIT string
_max_min_avg_sum ( string $select = '', string $alias = '', string $type = 'MAX' ) : CI_DB_query_builder SELECT [MAX|MIN|AVG|SUM]()
_merge_cache ( ) : void Merge Cache
_object_to_array ( $object ) : array Object to Array
_object_to_array_batch ( $object ) : array Object to Array
_replace ( $table, $keys, $values ) : string Replace statement
_reset_run ( $qb_reset_items ) : void Resets the query builder values. Called by the get() function
_reset_select ( ) : void Resets the query builder values. Called by the get() function
_reset_write ( ) : void Resets the query builder "write" values.
_track_aliases ( $table ) : string Track Aliases
_truncate ( $table ) : string Truncate statement
_update_batch ( string $table, array $values, string $index ) : string Update_Batch statement
_validate_insert ( $table = '' ) : string Validate Insert
_validate_update ( $table ) : boolean Validate Update
_wh ( string $qb_key, mixed $key, mixed $value = NULL, string $type = 'AND ', boolean $escape = NULL ) : CI_DB_query_builder WHERE, HAVING
_where_in ( string $key = NULL, array $values = NULL, boolean $not = FALSE, string $type = 'AND ', boolean $escape = NULL ) : CI_DB_query_builder Internal WHERE IN

Method Details

_compile_group_by() protected méthode

Escapes identifiers in GROUP BY statements at execution time. Required so that aliases are tracked properly, regardless of wether group_by() is called prior to from(), join() and dbprefix is added only if needed.
protected _compile_group_by ( ) : string
Résultat string SQL statement

_compile_order_by() protected méthode

Escapes identifiers in ORDER BY statements at execution time. Required so that aliases are tracked properly, regardless of wether order_by() is called prior to from(), join() and dbprefix is added only if needed.
protected _compile_order_by ( ) : string
Résultat string SQL statement

_compile_select() protected méthode

Generates a query string based on which functions were used. Should not be called directly.
protected _compile_select ( boolean $select_override = FALSE ) : string
$select_override boolean
Résultat string

_compile_wh() protected méthode

Escapes identifiers in WHERE and HAVING statements at execution time. Required so that aliases are tracked properly, regardless of whether where(), or_where(), having(), or_having are called prior to from(), join() and dbprefix is added only if needed.
protected _compile_wh ( string $qb_key ) : string
$qb_key string 'qb_where' or 'qb_having'
Résultat string SQL statement

_create_alias_from_table() protected méthode

Determines the alias name based on the table
protected _create_alias_from_table ( string $item ) : string
$item string
Résultat string

_delete() protected méthode

Generates a platform-specific delete string from the supplied data
protected _delete ( $table ) : string
Résultat string

_from_tables() protected méthode

Groups tables in FROM clauses if needed, so there is no confusion about operator precedence. Note: This is only used (and overridden) by MySQL and CUBRID.
protected _from_tables ( ) : string
Résultat string

_group_get_type() protected méthode

Group_get_type
protected _group_get_type ( string $type ) : string
$type string
Résultat string

_insert_batch() protected méthode

Generates a platform-specific insert string from the supplied data.
protected _insert_batch ( string $table, array $keys, array $values ) : string
$table string Table name
$keys array INSERT keys
$values array INSERT values
Résultat string

_is_literal() protected méthode

Determines if a string represents a literal value or a field name
protected _is_literal ( string $str ) : boolean
$str string
Résultat boolean

_like() protected méthode

Internal LIKE
protected _like ( mixed $field, string $match = '', string $type = 'AND ', string $side = 'both', string $not = '', boolean $escape = NULL ) : CI_DB_query_builder
$field mixed
$match string
$type string
$side string
$not string
$escape boolean
Résultat CI_DB_query_builder

_limit() protected méthode

Generates a platform-specific LIMIT clause.
protected _limit ( string $sql ) : string
$sql string SQL Query
Résultat string

_max_min_avg_sum() protected méthode

SELECT [MAX|MIN|AVG|SUM]()
protected _max_min_avg_sum ( string $select = '', string $alias = '', string $type = 'MAX' ) : CI_DB_query_builder
$select string Field name
$alias string
$type string
Résultat CI_DB_query_builder

_merge_cache() protected méthode

When called, this function merges any cached QB arrays with locally called ones.
protected _merge_cache ( ) : void
Résultat void

_object_to_array() protected méthode

Takes an object as input and converts the class variables to array key/vals
protected _object_to_array ( $object ) : array
Résultat array

_object_to_array_batch() protected méthode

Takes an object as input and converts the class variables to array key/vals
protected _object_to_array_batch ( $object ) : array
Résultat array

_replace() protected méthode

Generates a platform-specific replace string from the supplied data
protected _replace ( $table, $keys, $values ) : string
Résultat string

_reset_run() protected méthode

Resets the query builder values. Called by the get() function
protected _reset_run ( $qb_reset_items ) : void
Résultat void

_reset_select() protected méthode

Resets the query builder values. Called by the get() function
protected _reset_select ( ) : void
Résultat void

_reset_write() protected méthode

Called by the insert() update() insert_batch() update_batch() and delete() functions
protected _reset_write ( ) : void
Résultat void

_track_aliases() protected méthode

Used to track SQL statements written with aliased tables.
protected _track_aliases ( $table ) : string
Résultat string

_truncate() protected méthode

Generates a platform-specific truncate string from the supplied data If the database does not support the truncate() command, then this method maps to 'DELETE FROM table'
protected _truncate ( $table ) : string
Résultat string

_update_batch() protected méthode

Generates a platform-specific batch update string from the supplied data
protected _update_batch ( string $table, array $values, string $index ) : string
$table string Table name
$values array Update data
$index string WHERE key
Résultat string

_validate_insert() protected méthode

This method is used by both insert() and get_compiled_insert() to validate that the there data is actually being set and that table has been chosen to be inserted into.
protected _validate_insert ( $table = '' ) : string
Résultat string

_validate_update() protected méthode

This method is used by both update() and get_compiled_update() to validate that data is actually being set and that a table has been chosen to be update.
protected _validate_update ( $table ) : boolean
Résultat boolean

_wh() protected méthode

WHERE, HAVING
protected _wh ( string $qb_key, mixed $key, mixed $value = NULL, string $type = 'AND ', boolean $escape = NULL ) : CI_DB_query_builder
$qb_key string 'qb_where' or 'qb_having'
$key mixed
$value mixed
$type string
$escape boolean
Résultat CI_DB_query_builder

_where_in() protected méthode

Internal WHERE IN
protected _where_in ( string $key = NULL, array $values = NULL, boolean $not = FALSE, string $type = 'AND ', boolean $escape = NULL ) : CI_DB_query_builder
$key string The field to search
$values array The values searched on
$not boolean If the statement would be IN or NOT IN
$type string
$escape boolean
Résultat CI_DB_query_builder

count_all_results() public méthode

Generates a platform-specific query string that counts all records returned by an Query Builder query.
public count_all_results ( $table = '', $reset = TRUE ) : integer
Résultat integer

dbprefix() public méthode

Prepends a database prefix if one exists in configuration
public dbprefix ( $table = '' ) : string
Résultat string

delete() public méthode

Compiles a delete string and runs the query
public delete ( $table = '', $where = '', $limit = NULL, $reset_data = TRUE ) : mixed
Résultat mixed

distinct() public méthode

Sets a flag which tells the query string compiler to add DISTINCT
public distinct ( boolean $val = TRUE ) : CI_DB_query_builder
$val boolean
Résultat CI_DB_query_builder

empty_table() public méthode

Compiles a delete string and runs "DELETE FROM table"
public empty_table ( $table = '' ) : boolean
Résultat boolean TRUE on success, FALSE on failure

flush_cache() public méthode

Empties the QB cache
public flush_cache ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

from() public méthode

Generates the FROM portion of the query
public from ( mixed $from ) : CI_DB_query_builder
$from mixed can be a string or array
Résultat CI_DB_query_builder

get() public méthode

Compiles the select statement based on the other functions called and runs the query
public get ( $table = '', $limit = NULL, $offset = NULL ) : CI_DB_result
Résultat CI_DB_result

get_compiled_delete() public méthode

Compiles a delete query string and returns the sql
public get_compiled_delete ( $table = '', $reset = TRUE ) : string
Résultat string

get_compiled_insert() public méthode

Compiles an insert query and returns the sql
public get_compiled_insert ( $table = '', $reset = TRUE ) : string
Résultat string

get_compiled_select() public méthode

Compiles a SELECT query string and returns the sql.
public get_compiled_select ( $table = '', $reset = TRUE ) : string
Résultat string

get_compiled_update() public méthode

Compiles an update query and returns the sql
public get_compiled_update ( $table = '', $reset = TRUE ) : string
Résultat string

get_where() public méthode

Allows the where clause, limit and offset to be added directly
public get_where ( string $table = '', string $where = NULL, integer $limit = NULL, integer $offset = NULL ) : CI_DB_result
$table string
$where string
$limit integer
$offset integer
Résultat CI_DB_result

group_by() public méthode

GROUP BY
public group_by ( string $by, boolean $escape = NULL ) : CI_DB_query_builder
$by string
$escape boolean
Résultat CI_DB_query_builder

group_end() public méthode

Ends a query group
public group_end ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

group_start() public méthode

Starts a query group.
public group_start ( string $not = '', string $type = 'AND ' ) : CI_DB_query_builder
$not string (Internal use only)
$type string (Internal use only)
Résultat CI_DB_query_builder

having() public méthode

Separates multiple calls with 'AND'.
public having ( string $key, string $value = NULL, boolean $escape = NULL ) : CI_DB_query_builder
$key string
$value string
$escape boolean
Résultat CI_DB_query_builder

insert() public méthode

Compiles an insert string and runs the query
public insert ( $table = '', $set = NULL, boolean $escape = NULL ) : boolean
$escape boolean Whether to escape values and identifiers
Résultat boolean TRUE on success, FALSE on failure

insert_batch() public méthode

Compiles batch insert strings and runs the queries
public insert_batch ( string $table, array $set = NULL, boolean $escape = NULL, $batch_size = 100 ) : integer
$table string Table to insert into
$set array An associative array of insert values
$escape boolean Whether to escape values and identifiers
Résultat integer Number of rows inserted or FALSE on failure

join() public méthode

Generates the JOIN portion of the query
public join ( $table, $cond, $type = '', $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

like() public méthode

Generates a %LIKE% portion of the query. Separates multiple calls with 'AND'.
public like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder
$field mixed
$match string
$side string
$escape boolean
Résultat CI_DB_query_builder

limit() public méthode

LIMIT
public limit ( integer $value, integer $offset ) : CI_DB_query_builder
$value integer LIMIT value
$offset integer OFFSET value
Résultat CI_DB_query_builder

not_group_start() public méthode

Starts a query group, but NOTs the group
public not_group_start ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

not_like() public méthode

Generates a NOT LIKE portion of the query. Separates multiple calls with 'AND'.
public not_like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder
$field mixed
$match string
$side string
$escape boolean
Résultat CI_DB_query_builder

offset() public méthode

Sets the OFFSET value
public offset ( integer $offset ) : CI_DB_query_builder
$offset integer OFFSET value
Résultat CI_DB_query_builder

or_group_start() public méthode

Starts a query group, but ORs the group
public or_group_start ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

or_having() public méthode

Separates multiple calls with 'OR'.
public or_having ( string $key, string $value = NULL, boolean $escape = NULL ) : CI_DB_query_builder
$key string
$value string
$escape boolean
Résultat CI_DB_query_builder

or_like() public méthode

Generates a %LIKE% portion of the query. Separates multiple calls with 'OR'.
public or_like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder
$field mixed
$match string
$side string
$escape boolean
Résultat CI_DB_query_builder

or_not_group_start() public méthode

Starts a query group, but OR NOTs the group
public or_not_group_start ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

or_not_like() public méthode

Generates a NOT LIKE portion of the query. Separates multiple calls with 'OR'.
public or_not_like ( mixed $field, string $match = '', string $side = 'both', boolean $escape = NULL ) : CI_DB_query_builder
$field mixed
$match string
$side string
$escape boolean
Résultat CI_DB_query_builder

or_where() public méthode

Generates the WHERE portion of the query. Separates multiple calls with 'OR'.
public or_where ( $key, $value = NULL, $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

or_where_in() public méthode

Generates a WHERE field IN('item', 'item') SQL query, joined with 'OR' if appropriate.
public or_where_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder
$key string The field to search
$values array The values searched on
$escape boolean
Résultat CI_DB_query_builder

or_where_not_in() public méthode

Generates a WHERE field NOT IN('item', 'item') SQL query, joined with 'OR' if appropriate.
public or_where_not_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder
$key string The field to search
$values array The values searched on
$escape boolean
Résultat CI_DB_query_builder

order_by() public méthode

ORDER BY
public order_by ( string $orderby, string $direction = '', boolean $escape = NULL ) : CI_DB_query_builder
$orderby string
$direction string ASC, DESC or RANDOM
$escape boolean
Résultat CI_DB_query_builder

replace() public méthode

Compiles an replace into string and runs the query
public replace ( $table = '', $set = NULL ) : boolean
Résultat boolean TRUE on success, FALSE on failure

reset_query() public méthode

Publicly-visible method to reset the QB values.
public reset_query ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

select() public méthode

Generates the SELECT portion of the query
public select ( $select = '*', $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

select_avg() public méthode

Generates a SELECT AVG(field) portion of a query
public select_avg ( $select = '', $alias = '' ) : CI_DB_query_builder
Résultat CI_DB_query_builder

select_max() public méthode

Generates a SELECT MAX(field) portion of a query
public select_max ( $select = '', $alias = '' ) : CI_DB_query_builder
Résultat CI_DB_query_builder

select_min() public méthode

Generates a SELECT MIN(field) portion of a query
public select_min ( $select = '', $alias = '' ) : CI_DB_query_builder
Résultat CI_DB_query_builder

select_sum() public méthode

Generates a SELECT SUM(field) portion of a query
public select_sum ( $select = '', $alias = '' ) : CI_DB_query_builder
Résultat CI_DB_query_builder

set() public méthode

Allows key/value pairs to be set for inserting or updating
public set ( $key, $value = '', $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

set_dbprefix() public méthode

Set's the DB Prefix to something new without needing to reconnect
public set_dbprefix ( $prefix = '' ) : string
Résultat string

set_insert_batch() public méthode

The "set_insert_batch" function. Allows key/value pairs to be set for batch inserts
public set_insert_batch ( $key, $value = '', $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

set_update_batch() public méthode

The "set_update_batch" function. Allows key/value pairs to be set for batch updating
public set_update_batch ( $key, $index = '', $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

start_cache() public méthode

Starts QB caching
public start_cache ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

stop_cache() public méthode

Stops QB caching
public stop_cache ( ) : CI_DB_query_builder
Résultat CI_DB_query_builder

truncate() public méthode

Compiles a truncate string and runs the query If the database does not support the truncate() command This function maps to "DELETE FROM table"
public truncate ( $table = '' ) : boolean
Résultat boolean TRUE on success, FALSE on failure

update() public méthode

Compiles an update string and runs the query.
public update ( string $table = '', array $set = NULL, mixed $where = NULL, integer $limit = NULL ) : boolean
$table string
$set array An associative array of update values
$where mixed
$limit integer
Résultat boolean TRUE on success, FALSE on failure

update_batch() public méthode

Compiles an update string and runs the query
public update_batch ( $table, $set = NULL, $index = NULL, $batch_size = 100 ) : integer
Résultat integer number of rows affected or FALSE on failure

where() public méthode

Generates the WHERE portion of the query. Separates multiple calls with 'AND'.
public where ( $key, $value = NULL, $escape = NULL ) : CI_DB_query_builder
Résultat CI_DB_query_builder

where_in() public méthode

Generates a WHERE field IN('item', 'item') SQL query, joined with 'AND' if appropriate.
public where_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder
$key string The field to search
$values array The values searched on
$escape boolean
Résultat CI_DB_query_builder

where_not_in() public méthode

Generates a WHERE field NOT IN('item', 'item') SQL query, joined with 'AND' if appropriate.
public where_not_in ( string $key = NULL, array $values = NULL, boolean $escape = NULL ) : CI_DB_query_builder
$key string The field to search
$values array The values searched on
$escape boolean
Résultat CI_DB_query_builder

Property Details

$qb_aliased_tables protected_oe property

QB aliased tables list
protected array $qb_aliased_tables
Résultat array

$qb_cache_exists protected_oe property

QB Cache exists list
protected array $qb_cache_exists
Résultat array

$qb_cache_from protected_oe property

QB Cache FROM data
protected array $qb_cache_from
Résultat array

$qb_cache_groupby protected_oe property

QB Cache GROUP BY data
protected array $qb_cache_groupby
Résultat array

$qb_cache_having protected_oe property

QB Cache HAVING data
protected array $qb_cache_having
Résultat array

$qb_cache_join protected_oe property

QB Cache JOIN data
protected array $qb_cache_join
Résultat array

$qb_cache_no_escape protected_oe property

QB Cache No Escape data
protected array $qb_cache_no_escape
Résultat array

$qb_cache_orderby protected_oe property

QB Cache ORDER BY data
protected array $qb_cache_orderby
Résultat array

$qb_cache_select protected_oe property

QB Cache SELECT data
protected array $qb_cache_select
Résultat array

$qb_cache_set protected_oe property

QB Cache data sets
protected array $qb_cache_set
Résultat array

$qb_cache_where protected_oe property

QB Cache WHERE data
protected array $qb_cache_where
Résultat array

$qb_caching protected_oe property

QB Caching flag
protected bool $qb_caching
Résultat boolean

$qb_distinct protected_oe property

QB DISTINCT flag
protected bool $qb_distinct
Résultat boolean

$qb_from protected_oe property

QB FROM data
protected array $qb_from
Résultat array

$qb_groupby protected_oe property

QB GROUP BY data
protected array $qb_groupby
Résultat array

$qb_having protected_oe property

QB HAVING data
protected array $qb_having
Résultat array

$qb_join protected_oe property

QB JOIN data
protected array $qb_join
Résultat array

$qb_keys protected_oe property

QB keys
protected array $qb_keys
Résultat array

$qb_limit protected_oe property

QB LIMIT data
protected int $qb_limit
Résultat integer

$qb_no_escape protected_oe property

QB No Escape data
protected array $qb_no_escape
Résultat array

$qb_offset protected_oe property

QB OFFSET data
protected int $qb_offset
Résultat integer

$qb_orderby protected_oe property

QB ORDER BY data
protected array $qb_orderby
Résultat array

$qb_select protected_oe property

QB SELECT data
protected array $qb_select
Résultat array

$qb_set protected_oe property

QB data sets
protected array $qb_set
Résultat array

$qb_where protected_oe property

QB WHERE data
protected array $qb_where
Résultat array

$qb_where_group_count protected_oe property

QB WHERE group count
protected int $qb_where_group_count
Résultat integer

$qb_where_group_started protected_oe property

QB WHERE group started flag
protected bool $qb_where_group_started
Résultat boolean

$reset_delete_data protected_oe property

Reset DELETE data flag
protected bool $reset_delete_data
Résultat boolean

$return_delete_sql protected_oe property

Return DELETE SQL flag
protected bool $return_delete_sql
Résultat boolean