Laravel Query Multiple Conditions

Question

 public function queryCountUsers($query) {
        $query->where(['confirmed' => true])->count();
    }

I want to query all the users who are already confirmed and those all users who have role_id of 2 or 3 but How can i do it ?

Daniel · Accepted Answer · 2017-01-01 00:18:25Z

1

You could add ->where('role_id',2)->orWhere('role_id',3) to your function, but it's probably a better idea to use Laravel's whereIn function:

$query->where(['confirmed' => true])->whereIn('role_id', [2,3])->count();

This is supported in every version of Laravel.

answered Jan 1, 2017 at 0:18

Daniel

11.3k12 gold badges56 silver badges94 bronze badges

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

1 Answer 1