/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

5 votes214 views3 answers
Enum table in laravel
PHP Laravel
0 vote215 views2 answers
Collection get first element laravel
PHP Laravel
0 vote207 views1 answer
Subquery in laravel
PHP Laravel
0 vote251 views1 answer
Adding another return message from Laravel Livewire
PHP Laravel
5 votes227 views2 answers
Set unique value validation for laravel form request
PHP Laravel
0 vote205 views1 answer
Handling deadlocks laravel
PHP Laravel
63 votes568 views6 answers
Clear all cache in laravel
PHP Laravel
1 vote204 views1 answer
Laravel eloquent where id not equal to
PHP Laravel
1 vote225 views1 answer
Php laravel string substring
PHP Laravel
0 vote172 views1 answer
Laravel middleware in controller
PHP Laravel