Using multiple Where clause Query in Laravel.
2024-04-27 10:35:37
Sujeet
Laravel
How to Create Multiple Where Clause Query Using Laravel Eloquent?
Simply add an array of condition in where function of laravel Eloquent to create multiple where clause.
Here is an example of multiple where conditions in Laravel.
<?php
$conditions=['condtion1'=>'condition','condtion2'=>'condition','condtion3'=>'condition',......... 'condtionn'=>'condition'];
$results=YourModel::where($conditions)->get();
?>
You can also add conditions like this
$query->where([
['column_1', '=', 'value_1'],
['column_2', '<>', 'value_2'],
[COLUMN, OPERATOR, VALUE],
...
])
This post is submitted by one of our members. You may submit a new post here.
- How to get all records in Laravel?
- Adding Multiple Order By clause in Laravel
- Disabling timestamps in Laravel Eloquent
- IN query in Laravel Eloquent
- Getting Random rows in Laravel Eloquent.
- Where not in Laravel
- How to use custom table in Laravel Model?
- What is the purpose of the Eloquent cursor() method in Laravel
- Paginating records in Laravel
- How to get records between two date in Laravel using eloquent
- Call to a member function connection() on null Laravel Lumen
Laravel interview Questions © 2019 - Designed by PSD to HTML