how to multiple where with array?

Question

I have a $data variable, its contents are in the form of an array like this

array:2 [▼
  0 => 1
  3 => 4
]

and I want to find data like this

Model::where('id', $array)->get();

in such a way does not work, then how? maybe you guys have a solution. thanks

use whereIn laravel.com/docs/9.x/queries#additional-where-clauses — Coola
– Coola, Commented Jul 27, 2022 at 11:59
data still does not appear, because there is an index. if the data array is like this it works ` [1,4] ` — Bayustypryg
– Bayustypryg, Commented Jul 27, 2022 at 12:05

Coola · Accepted Answer · 2022-07-27 12:10:34Z

1

You need to transform your array first:

$arr = [
  0 => 1,
  3 => 4,
];

$indexes = array_values($arr);

Model::whereIn('id', $indexes)->get();

answered Jul 27, 2022 at 12:10

Coola

3,2532 gold badges25 silver badges53 bronze badges

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

Comments

Anoop Babu · Accepted Answer · 2022-07-27 12:43:18Z

1

Model::whereIn('id', $array)->get();

answered Jul 27, 2022 at 12:43

Anoop Babu

18813 bronze badges

Dinesh Parmar · Accepted Answer · 2022-07-27 12:11:47Z

0

You can use find() method it accepts single id or array of ids. so you can do like this :

Model::find($array);

may it helps you...

answered Jul 27, 2022 at 12:11

Dinesh Parmar

1057 bronze badges