How to handle PDO exceptions [duplicate]

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?

Matchu · Accepted Answer · 2010-01-20 20:02:17Z

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, 2010 at 20:02

Matchu

86.2k18 gold badges156 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Alix Axel Over a year ago

@Matchu: This is the default behavior? Since when?!

Matchu Over a year ago

Since I last built a database class a month ago or so. At least in my environment, silent mode was default.

Matchu Over a year ago

Found it - us3.php.net/manual/en/pdo.error-handling.php - "PDO::ERRMODE_SILENT - This is the default mode."

Alix Axel Over a year ago

@Matchu: Yeah you're right, thanks. Still PDO::__construct() throws a PDOException if the attempt to connect to the requested database fails.

AntonSack Over a year ago

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!

TomerM · Accepted Answer · 2016-02-02 14:40:03Z

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 2, 2016 at 14:40

TomerM

3651 silver badge8 bronze badges

3 Comments

Jens Törnell Over a year ago

Nice! What about PDO::ERRMODE_EXCEPTION?

TomerM Over a year ago

Same way PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION

Your Common Sense Over a year ago

Do not catch exceptions to report them. PHP will do it better.

Collectives™ on Stack Overflow

How to handle PDO exceptions [duplicate]

2 Answers 2

5 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Linked

Related