Laravel orWhere Condition using Eloquent Query

Admin   Laravel   71  2020-08-13 04:06:47

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.

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