laravel multiple where statements code example
Example 1: laravel where multiple conditions
$query->where([
['column_1', '=', 'value_1'],
['column_2', '<>', 'value_2'],
[COLUMN, OPERATOR, VALUE],
...
])
Example 2: multiple logical condition in laravel query
$q->where(function ($query) {
$query->where('gender', 'Male')
->where('age', '>=', 18);
})->orWhere(function($query) {
$query->where('gender', 'Female')
->where('age', '>=', 65);
})
Example 3: laravel where multiple conditions on single colmn
$data = Users::where('type',1)
->where(function($query) {
return $query->whereDate('updated_at','!=', Carbon::today())
->orWhere('updated_at',null);
})
->get();