ItSolutionStuff.com

Today, i teach you how to write multiple where clause in laravel query builder. i will give you example of laravel eloquent multiple where conditions. you can easily execute multiple where condition in query with laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11.

Almost, we need to write multiple where condition with laravel. as we know we can use where clause using where() in laravel. but if you want to write multiple where clause in laravel then i will give you two example of how to write multiple where clause in laravel.

You can see both syntax of writing multiple where condition:

->where('COLUMN_NAME', 'OPERATOR', 'VALUE')
->where('COLUMN_NAME', 'OPERATOR', 'VALUE')

OR

->where([
        ['COLUMN_NAME', 'OPERATOR', 'VALUE'],
        ['COLUMN_NAME', 'OPERATOR', 'VALUE']
    ]);

Now i will give you example of how to write multiple where condition with laravel.

If you have sql query like as bellow with multiple where condition:

SQL Query:

SELECT * FROM `users` 
WHERE active = 1 AND is_ban = 0

Then you can write your sql qurey like as bellow both way:

Example 1:

public function index()
{
    $users = User::select('*')
                ->where('active', '=', 1)
                ->where('is_ban', '=', 0)
                ->get();
   
    dd($users);
}

Example 2:

public function index()
{
    $users = User::select('*')
                ->where([
                    ['active', '=', 1],
                    ['is_ban', '=', 0]
                ])
                ->get();
   
    dd($users);
}

I hope it can help you...