Login Register

CI_DB_driver::query()

query($sql[, $binds = FALSE[, $return_object = NULL]])

Parameters:	$sql (string) – The SQL statement to execute $binds (array) – An array of binding data $return_object (bool) – Whether to return a result object or not
Returns:	TRUE for successful “write-type” queries, CI_DB_result instance (method chaining) on “query” success, FALSE on failure
Return type:	mixed

Execute an SQL query.

Accepts an SQL string as input and returns a result object upon successful execution of a “read” type query.

Returns:

Boolean TRUE upon successful execution of a “write type” queries
Boolean FALSE upon failure
CI_DB_result object for “read type” queries

Links:

http://www.codeigniter.com/user_guide/database/db_driver_reference.html#CI_DB_driver::query

doc_CodeIgniter

2016-10-15 16:31:07

Comments

Leave a Comment

Please login to continue.

Popular Articles

CI_DB_driver class CI_DB_driver initialize() Returns: TRUE on success, FALSE on failure Return type: bool Initialize database settings, establish a connecti

CI_DB_driver::simple_query() simple_query($sql) Parameters: $sql (string) – The SQL statement to execute Returns: Whatever the underlying driver’s “query” function returns

CI_DB_driver::last_query() last_query() Returns: The last query executed Return type: string Returns the last query that was executed.

CI_DB_driver::total_queries() total_queries() Returns: The total number of queries executed Return type: int Returns the total number of queries that have been executed so fa

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