การใช้งาน CRUD

// เริ่มต้นใช้งานฐานข้อมูล (Model)
$model = new \Kotchasan\Model;

// SELECT * FROM world LIMIT 1
$result = $model->db()->customQuery('SELECT * FROM world LIMIT 1');
// แสดงผลลัพท์
var_dump($result);

// SELECT * FROM world ORDER BY id DESC LIMIT 5
foreach ($model->db()->customQuery('SELECT * FROM world ORDER BY id DESC LIMIT 5') as $item) {
  echo $item->id.'<br>';
}

// SELECT * FROM world ORDER BY id DESC LIMIT 5
foreach ($model->db()->customQuery('SELECT * FROM world ORDER BY id DESC LIMIT 5', true) as $item) {
  echo $item['id'].'<br>';
}

// DELETE FROM world WHERE id=1000
$model->db()->query('DELETE FROM world WHERE id=:id', array(':id' => 1000));

// SELECT * FROM world WHERE id=1000
$result = $model->db()->customQuery('SELECT * FROM world WHERE id=:id', false, array(':id' => 1000));
var_dump($result);

// SELECT * FROM world WHERE `id` = 1000 ORDER BY `id` DESC, `created_at` ASC
$result = $model->db()->find('world', array('id', 1000), array('id DESC', 'created_at ASC'));
print_r($result);

// SELECT * FROM world WHERE id=1000 LIMIT 1
$result = $model->db()->first('world', array('id', 1000));
print_r($result);

// INSERT INTO world (`id`,`created_at`) VALUES (1000, '2016-09-14 20:41:36')
$newId = $model->db()->insert('world', array('id' => 1000, 'created_at' => date('Y-m-d H:i:s')));

// UPDATE world SET `name` = 'ทดสอบ', `user_id` = 1 WHERE `id` = 1000
$model->db()->update('world', 1000, array('name' => 'ทดสอบ', 'user_id' => 1));

// UPDATE world SET `name` = 'ทดสอบ', `user_id` = 1
$model->db()->updateAll('world', array('name' => 'ทดสอบ', 'user_id' => 1));

// DELETE FROM world WHERE id=1000
$model->db()->delete('world', 1000);

// TRUNCATE TABLE world
$model->db()->emptyTable('world');

namespace Index\Mysql;

class Model extends \Kotchasan\Model
{

  public function get($id)
  {
    // SELECT * FROM world WHERE id=$id LIMIT 1
    $result = $this->db()->customQuery('SELECT * FROM world WHERE id=:id LIMIT 1', false, array(':id' => $id));
    // คืนค่าข้อมูลที่พบรายการเดียว ไม่พบข้อมูลคืนค่า false
    return empty($result) ? false : $result[0];
  }
}