/PHP/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

53 votes286 views6 answers
Laravel where in
PHP Laravel
5 votes215 views4 answers
Create database from migration laravel for all
PHP
1 vote199 views1 answer
Laravel descending order paginate eloquent
PHP
0 vote204 views1 answer
Export PATH=/Applications/MAMP/bin/php/php5.4.10/bin:$PATH
PHP
1 vote209 views2 answers
Belongs to many laravel
PHP
6 votes271 views1 answer
Get domain from url cakephp
PHP CakePHP
14 votes223 views4 answers
Laravel transactions eloquent
PHP
0 vote247 views1 answer
Validate audio file in laravel
PHP Laravel
1 vote237 views5 answers
Check if value change laravel
PHP Laravel
8 votes193 views4 answers
Laravel set date format
PHP