Cakephp：利用我的appcontroller对具有特定角色ID的注册人进行计数

Question

I am currently trying to display a user count on my website that only counts users with a certain role ID in my user database. So far I have tried several variations, but in continuously outputs the master count as opposed to the specific role count.

$this->set('fillme',$fillme);
        $coptions = array('conditions' => array('User.role_id' => 3));
        $students=      $this->User->find('count');
        $this->set('students',$students);

I'm not sure exactly what I'm doing wrong, I'll admit that I'm fairly new to Cakephp and all, but I've tried a few variations such as replacing '=>' with '==' or segregating ''User.role_id'' into ''User','role_id'' but none of it seems to work. Any and all help/suggestions would be greatly appreciated.

Answer 1

Try the following:

$this->set('fillme',$fillme);
$students = $this->User->find('count', array('conditions' => array('User.role_id' => 3));
$this->set('students',$students);

Note that I'm passing an array with the 'conditions' key in the find() function. Also see, http://book.cakephp.org/2.0/en/models/retrieving-your-data.html for more on how to retrieve your data and all the available options.