Laravel where and orWhere Condition Example

Websolutionstuff | Jan-11-2021 | Categories : Laravel PHP

In this article, we will see laravel where and orWhere condition example. we will give you a very simple example of the laravel where() and orWhere() condition and also we will give you an example of where() and orWhere in a single query in laravel 6/7/8. You can use the where and orwhere method in laravel 6, laravel 7, and laravel 8.

For the where() and orWhere() methods the first argument is the name of the column. The second argument is an operator, which can be any of the database's supported operators. The third argument is the value to compare against the column's value.

So, let's see laravel 7/8 where query and laravel 7/8 orwhere query.

Syntax of where() query in laravel 6/7/8

where(Column Name, Operator, Value);

 

Example of where() condition in laravel 6/7/8

$users = DB::table('users')
                ->where('id', '=', 10)
                ->where('department', '=', 'web development')
                ->where('age', '>', 35)
                ->get();

 

Now I will show you an example of orWhere() query in laravel 6/7/8 and how to write orWhere() condition in laravel. So first we will see SQL query for better understanding.

SQL OR Example

SELECT * FROM users WHERE id='10' OR salary='20000';

 

Example of orWhere() condition in laravel 6/7/8

$users = DB::table('users')
                    ->where('salary', '>', 20000)
                    ->orWhere('name', 'Maria')
                    ->get();

 

Recommended Post
Featured Post
How to Build a Blog CMS with React JS?
How to Build a Blog CMS with R...

Are you a blogger who expresses his thoughts with the help of words? If yes, then you might have once thought to create...

Read More

Nov-13-2023

How to Multiple Image Upload in Laravel 10 API
How to Multiple Image Upload i...

Hello everyone! I'm excited to share with you how I'm enhancing my Laravel 10 API by enabling the capability to...

Read More

Dec-01-2023

How To Check Array Is Empty Or Null In Javascript
How To Check Array Is Empty Or...

In this example, I will show you how to check if an array is empty or null in javascript or jquery. When we are wor...

Read More

Aug-18-2020

How to Send E-mail Using Queue in Laravel 7/8
How to Send E-mail Using Queue...

Today I will show you how to send e-mail using queue in laravel 7/8, many times we can see some processes take...

Read More

Oct-30-2020