Laravel eloquent multiple WHERE with multiple OR AND

this snippet will provide you code examples of how to use multiple where conditions with multiple or conditions or and conditions

If you need to use multiple AND do like this:

->where($condition)

->where($anotherCondition)

If you want to use OR do this:

->where($condition)

->orWhere($anotherCondition)

To combine multiple AND and OR do parameter grouping:

->where('name', '=', 'John')

->where(function ($query) {

        $query->where('sender_id', 1)

        ->orWhere('receiver_id', 2);

})

->orWhere(function ($query) {

    $query->where('numbers', '>', 100)

          ->where('title', '<>', 'Admin');

})

Mahmoud Anwar

Back End Developer with a passion for developing innovative web applications that expedite the efficiency and effectiveness of organizational success. Well-versed in technology and writing code to create systems that are reliable and user-friendly. Also has the proven ability to motivate, educate, and collaborate effectively to build web applications and effectively track changes. Confident communicator, strategic thinker, and innovative creator to develop software that is customized to meet a company’s organizational needs, highlight their core competencies, and further their success.