Codeigniter 4 – Query Helper Methods with Example

Query Helper Methods

- The Query Helper provides a set of methods to assist with building and executing database queries.

Minimum Query

- Use the min() method to retrieve the minimum value of a column.

Example:

$db->min('age', 'my_table');

Maximum Query

- Use the max() method to retrieve the maximum value of a column.

Example:

$db->max('age', 'my_table');

Average Query

- Use the avg() method to retrieve the average value of a column.

Example:

$db->avg('age', 'my_table');

Sum Query

- Use the sum() method to retrieve the sum of a column.

Example:

$db->sum('age', 'my_table');

Count Query

- Use the count() method to retrieve the number of rows in a table.

Example:

$db->count('my_table');

Count All Query

- Use the count_all() method to retrieve the total number of rows in a table.

Example:

$db->count_all('my_table');

Count All Results Query

- Use the count_all_results() method to retrieve the total number of rows in a query.

Example:

$db->count_all_results('my_table', 'name', 'John Doe');

I hope this helps! Let me know if you have any further questions or need more information.

Note: The Query Helper methods in CodeIgniter 4 provide a simple and intuitive way to execute common database queries. They can be used to retrieve specific data from a database table.