/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

7 votes352 views2 answers
Laravel having between
PHP Laravel
0 vote394 views1 answer
Convert time to 24 hour format laravel
PHP Laravel
1 vote379 views1 answer
Laravel child relation order by desc
PHP Laravel
0 vote388 views1 answer
Return single row from eloquent all collection laravel
PHP Laravel
0 vote387 views2 answers
Access paginator object attribute in laravel
PHP Laravel
1 vote369 views2 answers
How to delete a file in laravel
PHP Laravel
4 votes363 views3 answers
Ubuntu where are laravel logs stored
PHP Laravel
4 votes335 views5 answers
Laravel db inserr
PHP Laravel
10 votes342 views2 answers
Laravel route list
PHP Laravel
8 votes380 views2 answers
Laravel drop multiple columns
PHP Laravel