Home > Software engineering >  WhereIn Inside ->where() array - Laravel Query Builder
WhereIn Inside ->where() array - Laravel Query Builder

Time:09-09

I'm trying use a whereIn inside a where array I am passing to Laravel query Builder:


$where = [['Participants.Client_Id','IN', $clientId]];

DB::table('Participants')->where($where)->get()

Something like is what I want to achieve, and I know there are works around such as using whereIn, but I'm sharing here a small piece of code to give you an idea, so I need to change the array to make it works as a whereIn, not changing the ->where to ->whereIn or ->whereRaw

CodePudding user response:

  DB::table('participants)->whereIn('Participants.Client_Id',$clientId)->get();

You must collect the IDs in the $clientId variables.

CodePudding user response:

If I understand, you could do something like that :

$wheres = [['Participants.Client_Id','IN', [$clientId]]];

$query = DB::table('Participants');
foreach($wheres as $where) {
    $query->where($where[0], $where[1], $where[2]);
}
$participants = $query->get();

CodePudding user response:

As laravel document , you can use array in where and each element of this array must be a array with three value . So your $where variable is correct.

But as I searched in operator is not supported by query builder of where.

  • Related