/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 vote165 views2 answers
Timestamp in model laravel
PHP Laravel
1 vote171 views1 answer
How get the latest data in database in laravel
PHP Laravel
3 votes153 views1 answer
Php extensions for laravel
PHP Laravel
0 vote163 views2 answers
Laravel composite unique key
PHP Laravel
0 vote173 views1 answer
Laravel blade php variable concatenate javascript variable
PHP Laravel
0 vote153 views1 answer
Editing items in collection in laravel
PHP Laravel
0 vote144 views1 answer
Use app http models in laravel 8
PHP Laravel
0 vote118 views1 answer
Php artisan queue start
PHP Laravel
0 vote171 views1 answer
Add like and equal in same query in laravel
PHP Laravel
13 votes175 views6 answers
Laravel route optional parameter
PHP Laravel