PHP code snippet – How condition for multiple row by orwhere laravel?

Subash Chandran 20th November 2021 Leave a Comment

  public function index()
    {
        $search = "Har";
  
        $users = User::select("*")->where('status', 1)
                  ->where(function($query) use ($search){
                   $query->where('first_name', 'LIKE', '%'.$search.'%')
                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')
                   ->orWhere('email', 'LIKE', '%'.$search.'%');
                    })->get();
  
        dd($users);
    }

# With Join
  public function index()
    {
        $search = "Har";
  
        $users = User::select("*")->where('status', 1)
                  ->where(function($query) use ($search){
                   $query->where('first_name', 'LIKE', '%'.$search.'%')
                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')
                   ->orWhere('email', 'LIKE', '%'.$search.'%');
                    })
          ->join('users_roles', 'users.id', '=', 'users_roles.user_id')
          ->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)->get();
  
        dd($users);
    }

Related

See also How to create multiple dictionaries in Python?

Snippets

2 conditions in where laravel, 2 where condition in laravel 1 orwhere, check multiple conditions in where clause laravel orm, eloquent multiple orwhere, eloquent multiples where and orwhere, eloquent where multiple or conditions, eloquent where with multiple conditions, how check two condition in where in laravel, how condition for multiple row by orwhere laravel, how to get rows of multiple condition laravel mysql, how to retrieve multiple row with multiple conditions in a single query in laravel, how to select multiple where conditions in laravel sql query, how to to apply multiple where condition in laravel, how to use orwhere in laravel with multiple where condition, how to use two where condition in one statement in laravel, how to write multiple conditions in where clause laravel, how to write two where condition in laravel, inside where using 2 condition i laravel, laravel 2 condition in a where, laravel 7 orwhere with multiple conditions, laravel 8 where or multiple condition, laravel eloquent multiple orwhere, laravel eloquent multiple where and orWhere, laravel eloquent multiple where condition, laravel eloquent two orWhere clauses, laravel eloquent where with two condition, laravel firstwhere multiple and conditions, laravel firstwhere multiple conditions, laravel have two where conditions, laravel model multiple where and orWhere, laravel more than one where condition, laravel more than two where condition, laravel multiple can, laravel multiple condition on join, laravel multiple or condition inside where, laravel multiple or where, laravel multiple orwhere, laravel multiple orwhere and and not working, laravel multiple relationships with condition, laravel multiple statements, laravel multiple where, laravel multiple where and, laravel multiple where and or, laravel multiple where and orwhere, laravel multiple where clause, laravel multiple where condition, laravel multiple where when, laravel multiple whereIn, laravel multiple whereIn columns, laravel multiple with function, laravel multiple with use to where has query un, laravel mysql how to use clause where for multiple check, laravel mysql orwhere, laravel orwhere condition, laravel orwhere multiple, laravel orwhere with multiple where, laravel query builder multiple orwhere, laravel query builder select multiple rows where conditions, laravel query multiple conditions, laravel query multiple rows, laravel query with multiple orWhere, laravel sql where row 2 conditions on same column, laravel two where conditions#, laravel when condition multiple, laravel when for two where clause, laravel where and clause with multiple conditions, laravel where and or condition, laravel where multiple conditions, laravel where multiple conditions or, laravel where multiple values, laravel where or multiple, laravel where or where multiple, laravel where with multiple conditions, laravel where with or condition, laravel where with two conditions, laravel wherein multiple columns, more than 2 where conditions in laravel, more than one condition in where laravel, multi orwhere laravel, multiple && in laravel eloquent, multiple and wherein laravel, multiple andwhereins laravel, multiple condition in laravel where, multiple condition where laravel 7, multiple conditions in laravel where, multiple conditions in where laravel, multiple conditions laravel query, multiple or where laravel, multiple orwhere condition in laravel, multiple orwhere in laravel, multiple orwhere laravel, multiple orwhere laravel codeigniter, multiple orwheres laravel, multiple tables where in laravel, multiple value in where clause laravel, multiple when condition laravel, multiple where and andwherein laravel, multiple where and orwhere in laravel, multiple where and wherein laravel, multiple where clause in laravel, multiple where clause in laravel 8, multiple where clause in laravel eloquent, multiple where clause in laravel model, multiple where clause in select laravel, multiple where clause laravel, multiple where clause laravel in one where, multiple where condition eloquent query, multiple where condition in eloquent, multiple where condition in laravel, multiple where condition in laravel 8, multiple where condition in laravel as array, multiple where condition in laravel eloquent, multiple where condition in laravel orwhere, multiple where condition in laravel query builder, multiple where condition in laravel using loop, multiple where condition in where clause in laravel, multiple where condition laravel, multiple where condition using if in laravel, multiple where conditions elequent, multiple where in laravel, multiple where inside where or laravel, multiple where laravel 8, multiple where laravel andwhere, multiple where statements in laravel, multiple wheres laravel, orwhere condition in laravel, orWhere laravel two conditions, orwhere multiple conditions laravel, orwhere multiple laravel, orwhere multiple value laravel, orwhere multiple where laravel, orwhere with more conditions laravel, query where with two conditions laravel, select with multiple where clause in laravel, two condition in one laravel query, two where but or condition in laravel, two where condition in laravel, two where condition with and in laravel, use multiple conditions in one where clause laravel eloquent, use multiple where clause and not in condition in laravel, using multiple where in laravel, where 2 condition laravel, where clause for multiple value in laravel, where condition eloquent multiple, where multiple conditions sql laravel, where with two conditions laravel

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.