laravelモデル操作

全てをセレクト

$users = \App\User::all();

idでセレクト

$user = \App\User::find(1);

抽出（単数）

$user = \App\User::where('field', 'value')
    ->first();

抽出（複数）

$users = \App\User::where('field', 'value')
    ->orderBy('field', 'desc')
    ->get();

AND条件追加

// 全部イコールの場合
$conditions = [
    'status' => 1,
    'author_id' => 1,
    'tag_id' => 1
];
$users = \App\User::where($conditions)->get();

// イコール以外を含む場合
$conditions = [
    ['status', '<>', 1],
    ['author_id', '=', 1],
    ['tag_id', '>', 1]
    ['name', 'LIKE', '%taro%']
];
$users = \App\User::where($conditions)->get();

OR条件追加

$users = \App\User::where('field', 'value')
    ->orWhere('field', 'value')
    ->get();

配列化(firstで取得する場合)

$user = \App\User::where('field', 'value')
    ->first();
return $user->attributesToArray();

配列化(all, getで取得する場合)

$users = \App\User::where('field', 'value')
    ->get();
return $users->toArray();

更新

$user = \App\User::find(1);
$user->[column] = [value];
...
$user->save();

登録（フォームパラメータをぶっこむ）

  $sample = new Smaple;
  $form = $request->all();
  unset($form['_token']);

  $sample->fill($form)->save();

---