/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

33 votes195 views6 answers
How to run a specific migration in laravel
PHP
0 vote178 views1 answer
Laravel return redirect by stuckOverFlow
PHP Laravel
0 vote160 views1 answer
Parse json nested array form url in php
PHP
1 vote165 views1 answer
Append single qoute arounf variable in php string
PHP
0 vote117 views1 answer
Laravel foreign id
PHP
0 vote187 views3 answers
Laravel pagination with search filter
PHP Laravel
2 votes130 views1 answer
Varchar max length define laravel migration
PHP Laravel
10 votes220 views6 answers
Php redirect to another page
PHP
1 vote175 views1 answer
Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))
PHP
32 votes181 views6 answers
For loop in php
PHP