/PHP/Laravel/Laravel search user details by specific role

Laravel search user details by specific role

$search_query = $request->search_query;
$role = 'Member';
$results = User::with('roles')->whereHas("roles", function($q) use($role){ 
            $q->where('title', '=', $role);
        })->where('name', 'LIKE', "%{$search_query}%")->paginate(4);

Similar codes

5 votes141 views6 answers
Laravel sort collection
PHP Laravel
1 vote144 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel
2 votes175 views1 answer
Laravel test dbms connection
PHP Laravel
10 votes133 views3 answers
Session flush laravel
PHP Laravel
0 vote144 views1 answer
Multiplication des variables sur laravel
PHP Laravel
9 votes134 views3 answers
Laravel where closure
PHP Laravel
0 vote157 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel
0 vote136 views1 answer
Laravel enable mysql logging
PHP Laravel
2 votes147 views2 answers
How get the first item in foreach in laravel
PHP Laravel
1 vote140 views1 answer
Laravel order by raw
PHP Laravel