Laravel orWhere Condition using Eloquent Query

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 = 'onlinecode@gmail.com'

Laravel Query:

public function index()
{
    $users = DB::table('users')
                    ->where('id', 23)
                    ->orWhere('email', 'onlinecode@gmail.com')
                    ->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', 'onlinecode@gmail.com')
                    ->get();
    dd($users);                    
}

I hope it can help you…