False statement in PDO

Question

I'm trying to run this simple query:

try {
    $dsn = "mysql:host=localhost;dbname:mydb";
    $PDO = new PDO($dsn, 'root', '');
    $statement = $PDO->query("SELECT * FROM posts");
    var_dump($statement);  
} catch (PDOException $e) { exit($e->getMessage()); }

and this output:

bool(false)

I'm really getting mad about this error. I tried to run the query on my database. $PDO is a PDO Object so technically it is connected to the database. It also seem that nothing gets wrong in all the pro functions. Running the copied and pasted query from $PDO->query() on phpmyadmin return a list of 2 record. I don't know what to do seriously. I'm starting to pull my hair and hit the wall with the head (it's not a metaphor). What am I doing wrong?

possible duplicate of [How to squeeze error message out of PDO?](http://stackoverflow.com/questions/3726505/how-to-squeeze-error-message-out-of-pdo) — Pekka, Dec 18 '11 at 18:15
Well, getting an error message would help you find out what the problem is, no? — Pekka, Dec 18 '11 at 18:19
Have you var_dump()'d `$PDO` as well? What does `$PDO->errorInfo()` show? — Álvaro González, Dec 18 '11 at 18:23

Madara's Ghost · Accepted Answer · 2011-12-18T18:40:49.587

5

You have a DSN problem.

dbname:mydb

should be

dbname=mydb

Don't you just love programming?

In addition to the above statement, you should nevertheless enable Exceptions in your PDO attributes. It's done by adding the following statement right after the connection:

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

Further Points

Naming Convention - It's an accepted naming convention that variable names begin with a lower case letter, and every consecutive word is in Camel Case, or using underscores.
Examples: $pdo, $databaseConnection $awesomeMultipleWordedVariable, $another_awesome_multiple_worded_variable.

edited Dec 18 '11 at 18:40

answered Dec 18 '11 at 18:18

Madara's Ghost

172,118
50
264
308

OMG, thanks very much. You saved my life. I was going to kill myself. – Shoe Dec 18 '11 at 18:22
2

+1 for a good catch! However, the OP should enable exceptions anyway ;). – middus Dec 18 '11 at 18:26
Well spotted. But it's worth noting that `$PDO->errorInfo()` says `No database selected`. That's why I suggested it. – Álvaro González Dec 18 '11 at 18:28
1

@middus: Added, plus I've added the naming convention point for further reference. – Madara's Ghost Dec 18 '11 at 18:31
Regarding the naming conventions: in the php world many people use `$hello_i_am_a_var`. – middus Dec 18 '11 at 18:36
Noted, however the point is to get rid of the `$PDO` Added nevertheless. – Madara's Ghost Dec 18 '11 at 18:40

score 1 · Answer 2 · answered Dec 18 '11 at 18:18

1

You should enable PDO Exceptions:

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

answered Dec 18 '11 at 18:18

middus

9,103
1
31
33

False statement in PDO

2 Answers2

Further Points