Multiple where condition in Laravel 7 code example
Example 1: laravel where multiple conditions
$query->where([
['column_1', '=', 'value_1'],
['column_2', '<>', 'value_2'],
[COLUMN, OPERATOR, VALUE],
...
])
Example 2: 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();
Example 3: laravel select record with several conditions
public function index(){ $users = User::select('*') ->where('active', '=', 1) ->where('is_ban', '=', 0) ->get(); dd($users);}
Example 4: laravel select record with several conditions
public function index(){ $users = User::select('*') ->where([ ['active', '=', 1], ['is_ban', '=', 0] ]) ->get(); dd($users);}