/CodeIgniter 4

Query Helper Methods

Information From Executing a Query


The insert ID number when performing database inserts.


If using the PDO driver with PostgreSQL, or using the Interbase driver, this function requires a $name parameter, which specifies the appropriate sequence to check for the insert id.


Displays the number of affected rows, when doing “write” type queries (insert, update, etc.).


In MySQL “DELETE FROM TABLE” returns 0 affected rows. The database class has a small hack that allows it to return the correct number of affected rows. By default this hack is enabled but it can be turned off in the database driver file.


Returns a Query object that represents the last query that was run (the query string, not the result).

Information About Your Database


Permits you to determine the number of rows in a particular table. Submit the table name in the first parameter. This is part of Query Builder. Example:

echo $db->table('my_table')->countAll();

// Produces an integer, like 25


Outputs the database platform you are running (MySQL, MS SQL, Postgres, etc…):

echo $db->getPlatform();


Outputs the database version you are running:

echo $db->getVersion();

© 2014–2020 British Columbia Institute of Technology
Licensed under the MIT License.