Count number of rows for Cakephp querybuilder

Question

I am writing a custom function in a Member controller. The purpose of the function is this:-

First it checks if an id exists in the members table.
If it doesn't exist then it returns 0;
if it exists, then it checks whether the isActive status is 0 or 1;
if it's 0, then it returns 0, else 1;

Now, I am writing the function as these:-

public function memberExist($id)
{
    $query = "SELECT Member.id FROM members AS Member WHERE Member.id = $id AND Member.isActive = 1";
    // Here I want to write something like:
    // if($this->query($query)->num_rows()>0) return 1; else return 0;
}

However, the problem is, I don't now how to get number of rows from query builder(sorry if the name is not exact, I am new to cakephp).

$this->query($query) returns array.

In controller, we can use following method to get number of rows,

$userdata = $this->Member->find('count',array('conditions'=>array('Member.id'=>$id, 'Member.isActive'=>1)));

But how to apply count procedure in the Model?

$this->Member is a model object, think about that.

ndm
– ndm

2016-07-07 17:28:58 +00:00
Commented Jul 7, 2016 at 17:28 — ndm
– ndm, Commented Jul 7, 2016 at 17:28

Yosi Azwan · Accepted Answer · 2016-07-08 01:56:56Z

1

if $this->query($query) return arrays, you can count row by :

$records = $this->query($query);
$n = count($records); //count of rows

read this for details http://www.w3schools.com/Php/func_array_count.asp

answered Jul 8, 2016 at 1:56

Yosi Azwan

4974 silver badges15 bronze badges

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

Comments

Christof · Accepted Answer · 2016-07-07 11:47:59Z

0

This should work for multiple member ids (where 1, 2, 3 ... is your member ids):

$query = "SELECT COUNT(Member.id) as count FROM members AS Member WHERE Member.id in (1, 2, 3, 4) AND Member.isActive = 1;";

for single member id:

$query = "SELECT COUNT(Member.id) as count FROM members AS Member WHERE Member.id = ".$id." AND Member.isActive = 1;";

Number of rows will represented by $your_result_var['count'];

edited Jul 7, 2016 at 11:47

answered Jul 7, 2016 at 11:42

Christof

2,7462 gold badges22 silver badges34 bronze badges

Collectives™ on Stack Overflow

Count number of rows for Cakephp querybuilder

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related