PHP database error handling in try-catch block using PDO connection

Question

I am working on an exercise that involves using a try-catch block to throw Exceptions if database rows don't exist. Here's an example of a read() function:

class Manager {
    private $desc;
    private $id;
    private $newDesc;
    public function read($id) {
        $db = new PDO('mysql:host=localhost; dbname=database', 'root', '');
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        try {
            $sql = "SELECT * FROM table where `id` = :id_val";
            $query = $db->prepare($sql);
            $query->bindParam(":id_val", $id);
            $query->execute();
            $results = $query->fetchAll(PDO::FETCH_ASSOC);
        } catch (Exception $e) {
            echo "Could not return specified row! <br />";
            echo $e->getMessage();
        }
        echo "<pre>";
        print_r($results);
        echo "</pre>";
   }
}

Outside the class I run:

$manager = new Manager();
$manager->read(44); // this is an id that IS NOT an existing record

My browser shows Array()
Am I placing the wrong statements into the try-catch, or is it something else altogether?

having an empty result set will not be catched, just handle it separately — Kevin
– Kevin, Commented Mar 30, 2016 at 1:38
"Exceptions if database rows don't exist" -- You would have to throw your own exception because that doesn't throw one by default. — Mike
– Mike, Commented Mar 30, 2016 at 1:38

tanaydin · Accepted Answer · 2016-03-30 01:39:04Z

1

It's normal behaviour, "try catch" statements catches errors, exceptions... No record given id is not an error. If you want to check there is record or not you can count your result set with

count($results);

If this count is bigger than 0, it exists.

answered Mar 30, 2016 at 1:39

tanaydin

5,32632 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

PHP database error handling in try-catch block using PDO connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related