SELECT
1 2 3 4 5 6 |
$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
1 2 3 4 5 |
$query = \DB::update('tableName'); //$query->value('name', '田中太郎'); //更新する値のセット(1つだけ) $query->set(array('name' => '田中太郎', 'age' => 10 )); $query->where('id', '1'); $update = $query->execute(); |
INSERT
1 |
\DB::insert('tableName')->set(array('name' => '田中太郎'))->execute(); |
DELETE
1 |
\DB::delete('tableName')->where('id', '=', '7')->execute(); |
SQL文でANDやORを使う
1 2 3 4 5 6 7 8 9 10 11 12 13 |
$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'); |