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

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();

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();

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

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

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');

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

SELECT

UPDATE

INSERT

DELETE

SQL文でANDやORを使う