PDO: Обработка ошибок

1
<?php
2
// configuration
3
$dbtype    = "sqlite";
4
$dbhost   = "localhost";
5
$dbname    = "test";
6
$dbuser    = "root";
7
$dbpass    = "admin";
8

9
try{
10
  // database connection
11
  $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
12
}
13
catch(PDOException $pe)
14
{
15
  die('Connection error, because: ' .$pe->getMessage());
16
}
17

18
// query
19
$sql = "SELECT title FROM books ORDER BY title";
20
$q   = $conn->query($sql);
21

22
if(!$q)
23
{
24
  die("Execute query error, because: ". $conn->errorInfo());
25
}
26

27
$q->setFetchMode(PDO::FETCH_BOTH);
28

29
// fetch
30
while($r = $q->fetch()){
31
  print_r($r);
32
}
33

34
?>