### Kết nối database
```
// Kết nối database
$dbhost = "localhost";
$dbname = "dbname";
$dbuser = "root";
$dbpass = "pass";

$options = array(
	PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
	PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
);

try {
	$db = new PDO("mysql:host=$dbhost; dbname=$dbname", $dbuser, $dbpass, $options);
}
catch(PDOException $e)
{
	die("Kết nối thất bại: " . $e->getMessage());
}
```
### Inseft
```
$stmt = $db->prepare('INSERT INTO users (name, age, email) values (:name, :age, :email)');
$stmt->execute(array(':name' => 'Nam', ':age' => '26', ':email' => 'snooub@github.com'));
```
### Update
```
$stmt = $db->prepare('UPDATE users SET name = :name, age = :age, email = :email WHERE id = :id');
$stmt->execute(array(':id' => 1, ':name' => 'Mr Nam', ':age' => '69', ':email' => 'snooub@gmail.com'));
```
### Select

- **Single**

```
$stmt = $db->prepare('SELECT * FROM users WHERE id = :id');
$stmt->execute(array(':id' => 1));
$row = $stmt->fetch(PDO::FETCH_ASSOC);

print_r($row);
```

- **Multi**
```
$stmt = $db->prepare('SELECT * FROM users');
$stmt->execute();
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);

print_r($row);
```