CODEWITHSUNDEEP
phpmysqlpdo
wobsoriano
wobsoriano

Reputation: 13462

PDO::setAttribute() doesn't seems to affect new PDO()?

I have this code

try {
    $dbh = new PDO('mysql:host=localhost;dbname=db_informations', 'root', '');
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo $e->getMessage();
}

And it gives me the exception message:

SQLSTATE[HY000] [1049] Unknown database 'db_informations'

Because the correct name of my database is db_information only.

My question is, even if I don't include the line:

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

I still get the same exception and I think it's not necessary to use it? Is it?

Upvotes: 1

Views: 743

Answers (1)

Rizier123
Rizier123

Reputation: 59701

This is simply because that's the behaviour of PDO::__construct() as you can read in the manual:

PDO::__construct() throws a PDOException if the attempt to connect to the requested database fails.

But if you don't set the error mode to Exception and you do:

try {
    $dbh = new PDO('mysql:host=localhost;dbname=db_informations', 'root', '');
    $dbh->query("SELECT * FROM aTableWhichDoesNotExists");
} catch(PDOException $e) {
    echo $e->getMessage();
}

You won't get any excpetion message or error, because you didn't set the error mode. So you need to do this:

try {
    $dbh = new PDO('mysql:host=localhost;dbname=db_informations', 'root', '');
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $dbh->query("SELECT * FROM aTableWhichDoesNotExists");
} catch(PDOException $e) {
    echo $e->getMessage();
}

To receive an exception, which you then can catch:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test.atablewhichdoesnotexists' doesn't exist

Also if you just think logically:

setAttribute() needs to be used with ->, which means you need an instance of the class to call that method. So how would you be able to call that method, if the instance couldn't be created correctly?

(So that would mean setAttribute() would have to bee static, so that you can set something/call it before you take the instance of the class)

Upvotes: 2

Related Questions