/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

0 vote360 views1 answer
Laravel get old url
PHP Laravel
3 votes215 views2 answers
Get details of user using token in laravel passport
PHP Laravel
0 vote230 views1 answer
Set default value for column in laravel model
PHP Laravel
0 vote206 views1 answer
Laravel collection zip
PHP Laravel
0 vote262 views2 answers
Wherebetween in laravel
PHP Laravel
0 vote217 views1 answer
Action after model is created laravel
PHP Laravel
1 vote215 views3 answers
Required_if laravel
PHP Laravel
48 votes334 views6 answers
Laravel joins
PHP Laravel
0 vote219 views1 answer
Php laravel rount price to 99
PHP Laravel
1 vote220 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel