Count number of query results in a CodeIgniter application [duplicate]

Question

I have my query:

$query = $this->db
    ->get_where('users', array('group_id' => 7, 'active' => 1));

It works if I use:

print_r ($query->result());

All I want to do, is get the total number of rows that match my query. I've tried num_rows and count(), but I can't get either of them to work!

At the moment, I am just testing this in my view, but will move it over to my model when I figure it out.

try sizeof($query->result())

Torrezzzz
– Torrezzzz

2014-07-22 11:43:32 +00:00
Commented Jul 22, 2014 at 11:43 — Torrezzzz
– Torrezzzz, Commented Jul 22, 2014 at 11:43
Try count($query->result())

Sadikhasan
– Sadikhasan

2014-07-22 11:45:30 +00:00
Commented Jul 22, 2014 at 11:45 — Sadikhasan
– Sadikhasan, Commented Jul 22, 2014 at 11:45
$query->num_rows() as stated in the documentation

ka_lin
– ka_lin

2014-07-22 11:46:06 +00:00
Commented Jul 22, 2014 at 11:46 — ka_lin
– ka_lin, Commented Jul 22, 2014 at 11:46

Harshal · Accepted Answer · 2014-07-22 11:45:56Z

5

You need to use $query->num_rows(). It will return total number of rows returned using your query.

for example :

$query = $this->db->query("YOUR QUERY");

    if ($query->num_rows() > 0)
    {
       //DO your stuff
    }

For more reference see Documentation.

answered Jul 22, 2014 at 11:45

Harshal

3,6329 gold badges40 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alishad · Accepted Answer · 2014-07-22 11:58:21Z

0

Try count_all_results

Example:

echo $this->db->count_all_results('my_table');
// Produces an integer, like 25

$this->db->like('title', 'match');
$this->db->from('my_table');
echo $this->db->count_all_results();
// Produces an integer, like 17

OR

echo $this->db->where('group_id',1)->count_all_results('users');

answered Jul 22, 2014 at 11:58

alishad

1491 gold badge2 silver badges12 bronze badges

Collectives™ on Stack Overflow

Count number of query results in a CodeIgniter application [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related