使用 Eloquent (Laravel 5.4) 更新多条记录

Updating Multiple Records using Eloquent (Laravel 5.4)

提问by Alex

I have the following query that is working but I'm wondering what the Eloquent ORM equivalent would be?

我有以下正在运行的查询，但我想知道 Eloquent ORM 的等价物是什么？

       DB::table('exercises')->whereIn('id', $ids)->update($request->all());

Thanks

谢谢

回答by Alexey Mezenin

Eloquent equivalent is almost the same:

Eloquent 等价物几乎相同：

Exercise::whereIn('id', $ids)->update($request->all());

回答by Chandan Sharma

Here, $ids = [1,2,3];

这里，$ids = [1,2,3];

DB::table('users')
   ->whereIn('id', $ids)
   ->update(array('active' => true));

By using the above query we can update multiple rows same time.

通过使用上面的查询，我们可以同时更新多行。