laravel ORM 学习笔记 （持续更新）

Feed::whereIn('id', $commentableIds)
    ->update([
        'feed_comment_count' => \Illuminate\Support\Facades\DB::raw('`feed_comment_count` + 1'),
        'hot' => \Illuminate\Support\Facades\DB::raw('`feed_comment_count` * 5 + `like_count`')
    ]);

    UserExtra::whereIn('user_id', $userIds)
        ->increment('comments_count', 1);

Table::where('a', 1)
      ->where('b', 2)
      ->where(function($q) {
          $q->where('c', 3)
            ->orWhere('d', 3);
      })
      ->get();

Table::where('a', 1)
      ->where('b', 2)
      ->where(function($q) use ($key) {
          $q->where('c', $key)
            ->orWhere('d', $key);
      })
      ->get();

$school= School::where([
    'name' => $name,
    'email' => $email
])->get();

$school= School::where([
    ['id', '<', 96],
    ['province', '=', '黑龙江']
])->get();