Sometimes, we want to use WHERE with OR AND OR with PHP Laravel Eloquent Query.
In this article, we’ll look at how to use WHERE with OR AND OR with PHP Laravel Eloquent Query.
How to use WHERE with OR AND OR with PHP Laravel Eloquent Query?
To use WHERE with OR AND OR with PHP Laravel Eloquent Query, we call Model::where with a callback that has the query we want to run.
For instance, we write
Model::where(function ($query) {
$query->where('a', '=', 1)->orWhere('b', '=', 1);
})->where(function ($query) {
$query->where('c', '=', 1)->orWhere('d', '=', 1);
});
to call where with a function that has
$query->where('a', '=', 1)->orWhere('b', '=', 1);
to return values with a equals 1 or b equals 1.
And we call where again with another function that return results that has c equals 1 or d equals 1.
Conclusion
To use WHERE with OR AND OR with PHP Laravel Eloquent Query, we call Model::where with a callback that has the query we want to run.
