laravel where multiple conditions

Solutions on MaxInterview for laravel where multiple conditions by the best coders in the world

showing results for - "laravel where multiple conditions"

1  public function index()
2    {
3        $search = "Har";
4  
5        $users = User::select("*")->where('status', 1)
6                  ->where(function($query) use ($search){
7                   $query->where('first_name', 'LIKE', '%'.$search.'%')
8                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')
9                   ->orWhere('email', 'LIKE', '%'.$search.'%');
10                    })->get();
11  
12        dd($users);
13    }
14
15# With Join
16  public function index()
17    {
18        $search = "Har";
19  
20        $users = User::select("*")->where('status', 1)
21                  ->where(function($query) use ($search){
22                   $query->where('first_name', 'LIKE', '%'.$search.'%')
23                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')
24                   ->orWhere('email', 'LIKE', '%'.$search.'%');
25                    })
26          ->join('users_roles', 'users.id', '=', 'users_roles.user_id')
27          ->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)->get();
28  
29        dd($users);
30    }

1// ...
2$q->where(function ($query) {
3    $query->where('gender', 'Male')
4        ->where('age', '>=', 18);
5})->orWhere(function($query) {
6    $query->where('gender', 'Female')
7        ->where('age', '>=', 65);	
8})

1//laravel
2// here, i have used two different where condition on a single column
3$today = Carbon::today();
4$data = Users::where('type',1)
5        ->where(function($query) use ($today) {
6            return $query->whereDate('updated_at','!=', $today)
7            ->orWhere('updated_at',null);
8         })
9         ->get();

queries leading to this page

laravel search query with multiple conditions multi where in model in laravel laravel multiple orwhere and and not working laravel update multiple where clauses multiple conditions sql statement laravel laravel select record with several conditions how to put where condition with laravel laravel 7 orwhere with multiple conditions multiple where in sql query laravel multiple where laravel laravel where multiple values multiple if condition in laravel query eloquent where with multiple conditions multiple and or condition in laravel blade multiple where condition using if in laravel check multiple where condition in laravel where 2 condition laravel laravel eloquent multiple where and orwhere laravel orm with multiple condition eloquent where two or condition laravel query builder multiple where conditions multiwhere in laravel query where 2 conditions in laravel controller laravel multiple where condition multiple where exists laravel eloquent multiples where and orwhere laravel where clause with multiple conditions not equal laravel eloquent where two conditions select query based on a column in laravel multiple condition how to set two where condition in laravel laravel eloquent where andwhere laravel more than one where condition laravel model mulit eloquent multiple where is not how to have multiple conditions in eloquent laravel where condition on created by in laravel query multi condition laravel laravel multiple statements multiple where conditions elequent orwhere multiple laravel how to use orwhere in laravel with multiple where condition laravel where 2 condition multiple where query in laravel laravel model two where query for multiple where clauses laravel multiple query in laravel multiple where condition laravel laravel find one with multiple where conditions how to multiple where condition in laravel laravel how to work multy where two where clause in laravel how to select multiple where conditions in laravel sql query laravel multiple where statements laravel multiple or condition inside where eloquent multiple where multiple and wherein laravel 2 value in one column where conditions laravel multiple condition where laravel 7 multiple condition in where laravel multiple logic in laravel 8 eloquent where conditionn on two column in laravel multiple where clause in select laravel laravel find multiple where multiple where inside where or laravel laravel model where multiple conditions laravel where and condition multiple logical condition in laravel query 2 value in where conditions laravel 2 where clauses in laravel add more than 1 where condition in laravel lumen eloquent where clause laravel where statement condition laravel create and where multiple where in laravel eloquent laravel mutliple condition in where clause 2 or more with laravel relationship condition laravel where multiple conditions on single colmn laravel where with multiple conditions multiple where condition in laravel eloquent multiple where to array multiple where laravel andwhere how to specify multiple values in 3ewherein 28 29 clause in laravel eloquet query laravel where and clause with multiple conditions how to use two where condition in laravel query for multiple condition coumns laravel multiple where and andwherein laravel eloquent database query to apply two where clause how check two condition in where in laravel multi where laravel elequent how to write 2 where condition in laravel eloquent in operator with where condition in laravel laravel firstwhere multiple and conditions laravel 3a eloquent multiple where multiple conditions laravel query laravel where 28 29 to check multiple conditions laravel multiple where laravel using multiple statement in where clause all 28 29 3b with two condition in laravel orwhere laravel two conditions how to give 2 conditions in where in laravel laravel when for two where clause multiple where clause eloquent laravel multiple tables where in laravel laravel multiple and where query laravel where one column multiple condition laravel do tow where with and where two conditions in laravel in one where select with multiple conditions in laravel multiple where on single column laravel laravel eloquent where two conditions array where condition in laravel set two whare condition in laravel using model laravel multiple where check laravel where two conditions laravel eloquent multiple where laravel check multi where laravel multiple or where multiple where condition in laravel eloquent laravel where more than one and condition multiple wheres laravel where many parameter eloquent wherenot for multiple values laravel using multiple where in laravel query where with two and conditions laravel laravel where with 2 conditions true two condition in where mysql laravel where condition in eloquent laravel multiple where eloquent laravel wherein multiple columns eloquent query with multiple condition 2 with in laravel where condition eloquent multiple multiple where condition in laravel as array laravel querries multiple wheres multiple where clause in laravel 8 how to use multiple where condition in laravel eloquent laravel db query with two conditions laravel where multiple laravel where multiple conditions multiple where and orwhere in laravel add two condition in where in eloquent orm orwhere multiple where laravel multiple orwhere condition in laravel laravel wherein two conditions laravel where more than one option multiple condition in orm laravel how to use 2 where clause in laravel laravel eloquent multiple where condition eloquent multiple orwhere laravel query builder have multiple conditions in where caluse where multi condition laravel query multiple condition laravel laravel firstwhere multiple conditions laravel multiple with use to where has query un laravel eloquent where multiple conditions user where condition laravel inside where using 2 condition i laravel laravel eloquent query with condition multiple where condition in sql in laravel multiple orwhere in laravel laravel hasone multiple columns laravel query double where and where not where with multiple conditions and or laravel how to use where multiple condition in laravel6 multiple where condition in laravel query laravel find where multiples filter by multiple conditions laravel laravel query with multiple where eloquent where multiple or conditions laravel where with or condition find with multiple conditions laravel laravel eloquent where multiple value laravel eloquent multiple value where where condition with matching multiple elements query laravel laravel where multiple conditions or 2 where condition in laravel eloquent two where clauses sql laravel db laravel query on two conditions where mutiple condition in laravel multiple when in laravel query with laravel where condition orm multiple where condition in laravel query builder how condition for multiple row by orwhere laravel laravel multiple column where condition how to set query multipal where in laravel eleqount laravel multiple orwhere check multiple conditions in where clause laravel orm multiple orwheres laravel multiple with clause in laravel 5 how can use find in set multiple times in where clause in laravel how to apply multiple where condition in sql in laravel laravel php 8 multiple where condition multiple where statement laravel laravel db query multiple where or eloquent orm multiple where laravel two where conditions eloquent database query to apply two where clause with and where with multiple conditions laravel laravel where multiple conditions on single column laravel laravel or where condition two where but or condition in laravel laravel multi condition select multiple where clause eloquent two conditional where with and in laravel eloquent with and where condition in laravel how to make and in where clause laravel two condition in where in laravel multiple condition in laravel where where multiple conditions equivalent laravel laravel where two or plus and multiple where in laravel db 3a 3atable 28 24table 29 3ewhere multiple conditions laravel query with two condition laravel model where clause use multiple where clause and not in condition in laravel where with two conditions laravel laravel 2 where conditions in one multiple where conditions in laravel eloquent multi orwhere laravel multiple where clause in laravel multiple query laravel eloquent two where condition with and in laravel laravel where has two condition laravel check 2 conditions multiple conditions in where laravel laravel multiple where clauses multiple where eloquent laravel multiple conditions in where close in laravel multiple conditions in laravel where how to use multiple condition in laravel laravel with comment where condition laravel eloquent several where multiple where not in clause in eloquent query laravel model multiple where and orwhere laravel select column with 2 conditions orwhere with more conditions laravel eloquent get with complex condition multiple conditions in where clause sql laravel laravel multiple wherein columns multi where laravel multiple where clause laravell multiple where clause in laravel model laravel first or create with two conditions using multiple values in a where clause laravel eloquent laravel multi where laravel 2 condition in a where to check multiple condition in where condition in laravel database how to add 2 variables in eloquent query laravel eloquent orm where condition multiple where condition on same column in laravel query where with two conditions laravel multiple where clauses laravel with or laravel use orm on where cluse laravel query with multiple orwhere laravel where clause with multiple conditions laravel db query multiple where doble where en eloquent laravel multiple query laravel eloquent two where laravel multiple with use to where has query run select two where condition query builder multiple condition where laravel condition where laravel multiple with with laravel query builder mcreate two where larevel multiple when clause laravel find with multiple query in laravel eloquent where with multiple conditions in laravel laravel eloquen t query with condition multiple condition in where clause in laravel multiple where clause laravel in one where how to write multiple conditions in where clause laravel two where condition in laravel laravel multiple where conditions multiple when condition laravel laravel multiple and or where conditions multiple where condition in eloquent multiple and or where clause laravel eloquent multiple where clause in laravel eloquent db select with two where laravel multiple where laravel 8 laravel multiple where and orwhere where multiple conditions sql laravel laravel where condition multiple match multiple where condition in where clause in laravel how to to apply multiple where condition in laravel multicondiaion with like in laravel with array check where multiple laravel multiple where condition in laravel 8 laravel chek 2 where conditions laravel have two where conditions multiple statement in where laravel more than 2 where conditions in laravel multiple where statements in laravel eloquent where multiple conditions with same column multiple where conditions laravel laravel where several conditions laravel multiple condition on join two where condition in laravel query non eaual multi column where cluse in laravel inside where using 2 condition in laravel laravel multiple with function two conditions in query builder laravel multiple query laravel eloquent with if 2 conditions in laravel query builder uswer 3a 3awith where conditon eloqvant laravel query multiple conditions laravel eloquent multiple orwhere eloquent get with complex condition multiple multi where condition in laravel how to apply multiple where condition in laravel multiple orwhere laravel wherein multiple array clause in laravel laravel eloquent multiple wheres laravel where multiple where on one column 2 like conditions in same laravel multiple relationship laravel where condition laravel multiple where and laravel eloquent where with two condition laravel where condidion in model laravel 6 multiple where eloquent chaining where eloquent where multiple columns laravel find multiple conditions and in where clause laravel orm laravel where multiple or multiple orwhere laravel codeigniter laravel scope multiple where condition laravel multiple where and or multiple andwhereins laravel two where laravel 2 where condition in laravel query laravel eloquent multiple where or and one and condition laravel query multiple where laravel select where with two condition combined where condition laravel laravel where with many conditions laravel where nultiple laravel multiple of laravel controller where equals two values multiple where condition in sql laravel laravel db select multiple where two conditions in where clause laravel db 3a 3a laravel where with two condition get two type of data in where laravel multi where condition sql laravel eloquent get where more than two results orwhere multiple conditions laravel select with multiple where clause in laravel eloquent where two conditions laravel orwhere with multiple where laravel more than two where condition laravel 2beloquent 2badd two where close laravel query with multiple or condition laravel multiwhere laravel multiple where clause laravel multiple can laravel sql query 2 where clauses more than one condition in where laravel multiple conditions in where laravel eloquent multiple where in query laravel multiple where statements laravel eloquent multiple where condition eloquent query multiple where condition in laravel using loop laravel where many condition eloquent and where eloquent where condition laravel orwhere condition laravel multiple relationships with condition laravel query with 2 conditions two conditions laravel multiple condition laravel when laravel multiple where conditions same column where clause for multiple value in laravel how to use multiple where condition in laravel laravel where and or condition laravel 8 where or multiple condition how to set multiwhere condition in laravel controller eloquent laravel multiple where clause 3a laravel multiple name in where condition how to check for two conditions in laravel using where query where condition in laravel multiple condtions eloquent andwhere model where 2 condition laravel laravel multiple row query and table with multiple conditions laravel database query when method multiple conditions check multiple condition in sql laravel 8 how to check multiple conditions in where with or clause in laravel laravel multiple where when multiple with in laravel query builder how to apply multiple select with or condition in laravel use where in condition eloquent 2 conditions in where laravel multiple where statements laravel laravel orwhere multiple two condition in laravel model laravel with multiple models laravel 8 2 where conditions eloquent two or where multiple where condition in laravel query builder for multiple table laravel where or multiple how to check multiple conditions in where clause in laravel select 2 where conditions db 3a 3a where 28 29 laravel laravel 2 where multiple andwhere condition in laravel eloquent where multiple conditions laravel queries multiple wheres elqquent multiple where multiple where clause laravel laravel query multiple rows laravel where multiple if condition laravel two where conditions 23 multiple 26 26 in laravel eloquent laravel multiple clause with or condition where 2 condition laravel or laravel multiple where statements sql laravel where 2 conditions or multiple conditional orm laravel query laravel eloquent multiple where and or multiple where and wherein laravel where condition in laravel eloquent and where condition in laravel laravel eloquent where and sselect specific field using multi condition in laravel multiple where with and condition in orm laravel check two conditions in where clause laravel multiple where condition in laravel orm where multiple value eloquent how to use two where condition in one statement in laravel get doble laravel laravel multiple where clause 3a laravel multiple condition in relationship laravel mysql orwhere multiple or where laravel laravel where 2 conditions laravel multiple wherein multiple where conditionals laravel eloquent multipke where cluses in laravel controllers more condition in laravel multiple where condition in laravel 7 fetch from database using many conditions laravel laravel model with where clause laravel eloquent double where laravel query many where orwhere condition in laravel multiple where in one where laravel how to write two where clause in laravel laravel query builder multiple orwhere where on multiple columns and condition laravel orwhere multiple value laravel laravel query builder multiple conditions larav multiple where laravel multiple wherein condition where or with multiple where laravel eloquent laravel equivalent model where multiple conditions laravel eloquent where condition laravel one field multiple condition laravel where with two conditions 2 where condition in laravel 1 orwhere how to add multiple conditions in where clause in php laravel query builder how to give where clause in laravel two condition in one laravel query laravel where with 2 conditions where multiple conditions laravel laravel when condition multiple laravel eloquent check two condition laravel where or where multiple use multiple conditions in one where clause laravel eloquent where laravel multiple eloquent where multiple conditions with same column laravel do two where with and laravel model multiple where db 3a 3aselect multiple where laravel query with wherer condition larvel usng two ehere connditions in eloquent multiple condition in laravel eloquent how to add multiple where condition in laravel add two or conditions in one laravel where multiple value in where clause laravel or on clause laravel laravel eloquent two orwhere clauses laravel two where conditions on same column where condition laravel eloquent multiple where and condition in laravel eloquent laravel mysql how to use clause where for multiple check how to write two where condition in laravel laravel where multiple conditions