PDO: Error Handling

PHP Data Objects (PDO) Step By Step Tutorial - Part 6: When everything is okey, we didn't need error checking. But, we never know (especially at real world) what will happen, error handling is needed. We should check for errors when opening the connection to database, select database, and run query.

We can implement error handling at PDO like this:

<?php
// configuration
$dbtype		= "sqlite";
$dbhost 	= "localhost";
$dbname		= "test";
$dbuser		= "root";
$dbpass		= "admin";

try{
  // database connection
  $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
}
catch(PDOException $pe)
{
  die('Connection error, because: ' .$pe->getMessage());
}


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

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

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

// fetch
while($r = $q->fetch()){
  print_r($r);
}


?>

Previous: PDO: Posibble Fetch Mode
Next: PDO: Prepared Statement