Laravel Multiple Where Condition Example

By Hardik Savani | January 10, 2020 | Category : Laravel


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

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...




Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: