[Fuelphp] データベース操作メモ

SELECT

$query = \DB::select('id', 'name')->from('tableName');
$query->where('age', '18');
$query->order_by('age', 'asc');
$query->limit(3);
$query->offset(1);
$results = $query->execute()->as_array();

UPDATE

$query = \DB::update('tableName');
//$query->value('name', '田中太郎'); //更新する値のセット（1つだけ）
$query->set(array('name' => '田中太郎', 'age' => 10 ));
$query->where('id', '1');
$update = $query->execute();

INSERT

\DB::insert('tableName')->set(array('name' => '田中太郎'))->execute();

DELETE

\DB::delete('tableName')->where('id', '=', '7')->execute();

SQL文でANDやORを使う

$query = \DB::select()->from('tableName');
 
$query->where_open();
    $query->where('age', '=', '30');
    $query->and_where('id', '2');
$query->where_close();
 
$query->or_where_open();
    $query->where('age', '=', '10');
    $query->and_where('id', '1');
$query->or_where_close();
 
$result = $query->execute()->as_array('id');