Global php PDO handling errors

Question

I use try/catch block in my classes methods, If a get an exception, I log the error. But I would like to tell the "User" that a database query/etc failed - and the problem should be fixed soon. I could use a die() on the Exception in my methods, but that wouldn't be DRY, as I would have to retype it a lot, so any suggestions on how I can do this.

Example method:

public function login($username, $password) {
    try {
        $this->STH = $this->DBH->prepare("SELECT id, baned, activated FROM users WHERE username = ? AND password = ?");
        $this->STH->setFetchMode(PDO::FETCH_OBJ); 
        $this->STH->execute(array($username, $password));

        if (($row = $this->STH->fetch()) !== false)
            return $row;
    } catch (PDOException $e) {
        //Log $e->getMessage();
        die('A database error occoured, we are working on the problem, and it should work in a few...');
    }
}

rabusmar · Accepted Answer · 2011-12-01 17:57:51Z

4

If you need a quick fix, you can set a global exception handler, like this:

function pdo_exception_handler($exception) {
    if ($exception instanceof PDOException) {
        // do something specific for PDO exceptions
    } else {
        // since the normal exception handler won't be called anymore, you 
        // should handle normal exceptions yourself too
    }
}
set_exception_handler('pdo_exception_handler');

answered Dec 1, 2011 at 17:57

rabusmar

4,1571 gold badge27 silver badges31 bronze badges

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

3 Comments

John Over a year ago

I can't get it to work, with the method above, no result is output, I did an error intentionally..

rabusmar Over a year ago

That handler will be called for uncatched exceptions only, so if you already catch your exceptions somewhere in your code, you should throw them again so the global handler can catch it.

rabusmar Over a year ago

At the end of your catch blocks call throw $e;, where $e is the variable you declared in the catch block. That would still mean to add that line to most of your handlers tho.

jakx · Accepted Answer · 2011-12-01 17:56:34Z

1

It's OK to repeat yourself in this case because as each instance of die() passes a unique message.

answered Dec 1, 2011 at 17:56

jakx

7685 silver badges8 bronze badges

Collectives™ on Stack Overflow

Global php PDO handling errors

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related