Laravel Multiple Where Condition Example

https://www.itsolutionstuff.com/post/laravel-multiple-where-condition-exampleexample.html

Laravel Multiple Where Condition Example

By Hardik Savani January 10, 2020 Category : LaravelPauseUnmuteLoaded: 1.98%FullscreenCancel

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 and laravel 9.

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:

Read Also: Laravel WhereNotIn Query Example

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

I hope it can help you...

Tags :

• Example