/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

4 votes381 views1 answer
How to check query execution time in laravel
PHP Laravel
-1 vote452 views1 answer
When to create a service in laravel
PHP Laravel
1 vote355 views1 answer
Laravel fixed character limit
PHP Laravel
0 vote356 views1 answer
Singular from table laravel
PHP Laravel
3 votes372 views3 answers
Laravel notification
PHP Laravel
8 votes435 views3 answers
Laravel log query for model
PHP Laravel
0 vote393 views1 answer
Laravel DB facade relations
PHP Laravel
6 votes390 views3 answers
Laravel passport login with username
PHP Laravel
9 votes392 views6 answers
Laravel validation custom message
PHP Laravel
0 vote361 views1 answer
How to share count of things to sidebar in laravel
PHP Laravel