/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

14 votes351 views5 answers
Laravel debugbar
PHP Laravel
1 vote396 views1 answer
Publishing laravel module package
PHP Laravel
37 votes421 views6 answers
Laravel create or update
PHP Laravel
1 vote342 views1 answer
Laravel unique title except id on edit
PHP Laravel
0 vote369 views1 answer
No captcha laravel
PHP Laravel
1 vote365 views1 answer
Laravel blade form old value
PHP Laravel
0 vote363 views1 answer
Laravel collection get
PHP Laravel
0 vote431 views1 answer
Extensions for laravel command ubuntu 20.04
PHP Laravel
1 vote393 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
2 votes383 views2 answers
Laravel get file in public folder
PHP Laravel