How to handle PDO exceptions

Question

I'm trying to work with PDO class on php but I have some trouble to find the right way to handle errors, I've wrote this code:

<?php
// $connection alreay created on a class which works with similar UPDATE statements
// I've simply added here trim() and PDO::PARAM... data type


$id = 33;
$name = "Mario Bros.";
$url = "http://nintendo.com";
$country = "jp";


try {

$sql = "UPDATE table_users SET name = :name, url = :url, country = :country WHERE user_id = :user_id";

$statement = $connection->prepare ($sql);

$statement->bindParam (':user_id', trim($id), PDO::PARAM_INT);
$statement->bindParam (':name', trim($name), PDO::PARAM_STR);
$statement->bindParam (':url', trim($url), PDO::PARAM_STR);
$statement->bindParam (':country', trim($country), PDO::PARAM_STR, 2);

$status = $statement->execute ();

} catch (PDOException $e) {
    print $e->getMessage ();
}

print $status; // it returns a null value, and no errors are reported

?>

this portion of code doesn't report errors, but it simply doesn't work, the var $status at the bottom, return a null value.

can someone help me to find where I'm wrong?

score 48 · Accepted Answer · answered Jan 20 '10 at 20:02

48

PDO won't throw exceptions unless you tell it to. Have you run:

$connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

on the PDO object?

answered Jan 20 '10 at 20:02

Matchu

83,922
18
153
160

@Matchu: This is the default behavior? Since when?! – Alix Axel Jan 20 '10 at 20:09
Since I last built a database class a month ago or so. At least in my environment, silent mode was default. – Matchu Jan 20 '10 at 20:13
3

Found it - http://us3.php.net/manual/en/pdo.error-handling.php - "PDO::ERRMODE_SILENT - This is the default mode." – Matchu Jan 20 '10 at 20:14
2

@Matchu: Yeah you're right, thanks. Still **`PDO::__construct()` throws a PDOException if the attempt to connect to the requested database fails**. – Alix Axel Jan 20 '10 at 21:05
Ooh, that's worth knowing. Thanks! – Matchu Jan 20 '10 at 21:28
Matchu, thanks a ton, I was already ripping off my hair because I could not get the try / catch to run. You made my day! – AntonSack Feb 21 '15 at 12:05

score 1 · Answer 2 · answered Feb 02 '16 at 14:40

1

You can add the attribute one time while you connect you mysql.

function connect($dsn, $user, $password){
    try {
        $dbh = new PDO($dsn, $user, $password, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
    } catch (PDOException $e) {
        echo 'Connection failed: ' . $e->getMessage();
        exit;
    }
    }

Thanks

answered Feb 02 '16 at 14:40

TomerM

335
1
7

Nice! What about PDO::ERRMODE_EXCEPTION? – Jens Törnell Feb 02 '16 at 14:43
Same way PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION – TomerM Feb 02 '16 at 15:00
[Do not catch exceptions to report them](http://phpdelusions.net/pdo#errors). PHP will do it better. – Your Common Sense Feb 02 '16 at 15:33

How to handle PDO exceptions

2 Answers2

Linked