Multi where query using foreach loop

Question

I have a list of ids I want to use to get items out of my database table.

    $permittedClientIds = UsersClientsBridge::where('users_id', auth()->user()->id)->pluck('clients_id')->all();
    $firstPermittedClientIds = UsersClientsBridge::where('users_id', auth()->user()->id)->pluck('clients_id')->first();

    $clientsQuery = Clients::where('id', $firstPermittedClientIds);

    foreach($permittedClientIds as $clientId) {
       $clientsQuery->orWhere('id',$clientId);
    }

    $clientsQuery->get();

    return view('client.clients', [
        'clients' => $clientsQuery
    ]);

this $permittedClientIds contains 10 and 48. When I manually write the orWhere query it returns the expected output but this is retuning 0 results.

I'm not sure if I need $firstPermittedClientIds I only use it so I can initialize my query.

Can you explain the problem you're trying to solve not the solution you think you want. I suspect stackoverflow.com/questions/22758819/laravel-wherein-or-wherein might be useful. — 9bO3av5fw5
– 9bO3av5fw5, Commented May 21, 2020 at 15:30

user13588235 · Accepted Answer · 2020-05-21 13:32:46Z

1

Solved using whereIn

$permittedClientIds = UsersClientsBridge::where('users_id', auth()->user()->id)->pluck('clients_id')->all();
$clientsQuery = Clients::whereIn('id', $permittedClientIds)->get();
return view('client.clients', [
    'clients' => $clientsQuery
]);

answered May 21, 2020 at 13:32

user13588235

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multi where query using foreach loop

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related