How to get num rows in Codeigniter?

@haylee.mertz 

In Codeigniter, you can use the num_rows() method of the database class to get the number of rows returned by a SELECT statement. Here's an example:

1
2
3
4
5

$this->db->select('*');
$this->db->from('mytable');
$query = $this->db->get();

$num_rows = $query->num_rows();

This will execute a SELECT statement that retrieves all rows from the mytable table, and then it will store the number of rows returned in the $num_rows variable.

Alternatively, you can use the count_all_results() method to get the number of rows that would be returned by a SELECT statement without actually executing the query:

1

$num_rows = $this->db->count_all_results('mytable');

This can be more efficient than executing the query and then calling num_rows(), because it avoids the overhead of returning and processing the result set. However, it only works for SELECT statements that do not have a WHERE clause, GROUP BY clause, or HAVING clause.