No error when there should be error

PHP
1

My code:

$sql = “SELECT * FROM bus170 limit 100”;
try {
$db->query($sql);
} catch (PDOException $e) {
echo $e->getMessage();
}

Why is there no error when I purposely use a nonexistent table name, using this code?

2

Have you enabled PDO exceptions? As I recall they are not enabled by default.

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
3 Likes
3

That’s it! Thank-you!

2 Likes
4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.