Laravel orWhere Condition using Eloquent Query

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


Today's topic is how to use or where condition in laravel eloquent. How works laravel orWhere() query. i will give you simple example of or where condition in laravel query builder. you can use laravel eloquent or where easily.

you can simple use orWhere eloquent method in laravel 6, laravel 7 and laravel 8.

If you need to use sql or where query in laravel then you can use it. Laravel provide orWhere() to use sql or query query. in or where() we just need to pass two argument one is column name and will be value.

You can see bellow syntax on orWhere query in laravel:

orWhere(Coulumn_name, Value);

Now i will give you three example of how to use orWhere query in laravel application. So let's see those example how it works.

Example 1:

SQL Query:

SELECT *

FROM users

WHERE id = '23' OR email = '[email protected]'

Laravel Query:

public function index()

{

$users = DB::table('users')

->where('id', 23)

->orWhere('email', '[email protected]')

->get();

dd($users);

}

Example 2:

Here is another example of how it works with model. you can work as like bellow:

public function index()

{

$users = User::select("*")

->where('id', 23)

->orWhere('email', '[email protected]')

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