Laravel如何更新同一列多个记录

Question

|id | first_section_thumbnail |
|-----------------------------|
| 1 | 1                       |
| 2 | NULL                    |
| 3 | 1                       |
| 4 | 1                       |
| 5 | NULL                    |
| 6 | NULL                    |

我想更新first_section_thumbnail值。如何在查询生成器中执行此操作？

<input type="checkbox" class="form-check-input" id="first_section_thumbnail" name="first_section_thumbnail[]" value="1" <?php if ($row->first_section_thumbnail == 1) { echo "checked"; } ?>>
  Added to Slider <i class="input-helper"></i>
</label>

$id = $request->id;
$first_section_thumbnail=$request->first_section_thumbnail;
$array = [
  'id'=>$id,
  'first_section_thumbnail'=>$first_section_thumbnail
];

DB::table('posts')
->whereIn('id', $array['id'])
->update(array('first_section_thumbnail' => false));

Answer 1

您的wheren是错误的,因为您是在int而不是数组上执行wheren,

您应该执行以下操作：

DB::table('posts')
->where('id', $id)
->update(array('first_section_thumbnail' => false));