Level 104
You want a collection comprising Products and Users????
May 5, 2021
3
Level 4
Search for products or username with vendor role
How do i search for products or users with username, slug or email that have the vendor role?
$product = Product::where ( 'p_name', 'LIKE', '%' . $q . '%' )->with('user')->get()
OR User::whereHas(
'roles', function($q){
$q->where('name', 'Vendor');
}
)->get();
Level 4
yes, products or users that have the role Vendor for a search query
Level 4
something like this
$product = Product::where ( 'p_name', 'LIKE', '%' . $q . '%' )->with('user')->get()
OR User::whereHas(
'roles', function($q){
$q->where('name', 'Vendor');
} ->Where('username','LIKE', '%' . $q . '%')->orWhere('slug','LIKE', '%' . $q . '%')->orWhere('email','LIKE', '%' . $q . '%');
)->get();
Please or to participate in this conversation.