/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

6 votes234 views2 answers
Generate application key laravel
PHP Laravel
4 votes200 views2 answers
Cascade in laravel migration
PHP Laravel
0 vote245 views1 answer
Laravel select custom column
PHP Laravel
8 votes242 views3 answers
Laravel log query for model
PHP Laravel
0 vote212 views1 answer
Install pusher package in laravel
PHP Laravel
47 votes240 views6 answers
How to add new column in laravel migration
PHP Laravel
0 vote229 views1 answer
Spatie/laravel-activitylog display only changed data
PHP Laravel
6 votes198 views1 answer
Laravel scaffolding
PHP Laravel
1 vote201 views1 answer
Laravel uppercase first letter
PHP Laravel
0 vote201 views1 answer
Laravel query with optional filter
PHP Laravel