Use an array in Laravel update query

Question

I would like to push an array in Where Clause of Laravel Update Query.

Here is the update query.

DB::table('users')->where('id', 1)->update(array('votes' => 1));

Is it possible to use the query like below ??

$array_of_ids;
DB::table('users')->where($array_of_ids)->update(array('votes' => 1));

Thanks

Answer 1

Simply use whereIn:

$array_of_ids;
DB::table('users')->whereIn('id', $array_of_ids)->update(array('votes' => 1));

Please read the documentation carefully. In this case, all kinds of where statements are documented here: Query Builder - Selects

Answer 2

Try this query:

DB::table('users')->whereIn('id', $array_of_ids)->update(['votes' => 1]);

Using Model:

User::whereIn('id', $array_of_ids)->update(['votes' => 1]);