How to use advanced where clause while using OR operators

Question

How would I produce a query that displays user_id 1 whos a member of the club and subjects that are either football or tennis or cricket.

id|user_id|member|football|tennis|cricket
1 | 1     |Yes   | 1      | NULL | NULL
2 | 1     |Yes   | NULL   | NULL | NULL
3 | 2     |Yes   | NULL   | 1    | NULL
4 | 3     |Yes   | 1      | 1    | NULL
5 | 1     |No    | NULL   | 1    | NULL
6 | 1     |Yes   | NULL   | 1    | 1

So basically I would like the resulting rows to be:

id|user_id|member|football|tennis|cricket
1 | 1     |Yes   | 1      | NULL | NULL
6 | 1     |Yes   | NULL   | 1    | 1

So far I have this:

$user = Model::where(function ($query) {
    $query->where('cricket', 1)
          ->orWhere('tennis', 1);
          ->orWhere('football', 1);
        })->where(function ($query) {
    $query->where('user_id', '=', 1)
          ->Where('member', '=', 'Yes');
     });

Answer 1

Ah, you've joined the ranks of Advanced Where users -- welcome!

$user = Model::
    ->where('user_id', 1)
    ->where('member', 'Yes')
    ->where(function($query) {
        $query
            ->where('cricket', 1)
            ->orWhere('tennis', 1);
            ->orWhere('football', 1);
    })
    ->select(['id', 'user_id', 'member', 'football', 'tennis', 'cricket'])
    ->get()
;