Laravel Eloquent Query with AND inside orWhere()

Question

$query->orWhere(['member_id'=> $participant['id'], "event_id"=>$event_id, 'member_status'=>'1'])

on Debugging the Above query using toSql() , i Found this

select * from group_members where group_members.`event_id` = 5 and group_members.`event_id` is not null and (member_id = ? and event_id = ? and member_status = ?) or (member_id = ? or event_id = ? or member_status = ?)

However I want it to be like,

select * from group_members where group_members.`event_id` = 5 and group_members.`event_id` is not null and (member_id = ? and event_id = ? and member_status = ?) or (member_id = ? and event_id = ? and member_status = ?)

How do I achieve this?

Thanks in advance

Rutvij Kothari · Accepted Answer · 2017-12-17 21:26:18Z

4

Try this:

$query->where(function($query) {
    $query->where(['member_id'=> $participant['id'], "event_id"=>$event_id, 'member_status'=>'1']);
})->orWhere(function($query) {
    $query->where(['member_id'=> $participant['id'], "event_id"=>$event_id, 'member_status'=>'1']);
});

answered Dec 17, 2017 at 21:26

Rutvij Kothari

1,28511 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Laravel Eloquent Query with AND inside orWhere()

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related