PDO - 3D000 No database selected

Question

I wanted to create a PDO mysql connection. But the execute() function returns false and the errorInfo() returns "No database selected!". But I selected a database.

This is my code:

    $array = array("db" => "blogscript", "host" => "localhost", "user" => "root", "pass" => "");

    $db = new PDO('mysql:dbname=' . $array['db'] . ';host=' . $array['host'] . '', $array['user'], $array['pass']);

    $statement = $db->prepare('
        SELECT *
          FROM pages
    ');

    $r = $statement->execute();
    if ($r === false) {
        return $statement->errorInfo();
    }

The database "blogscript" existst.

Bit of a stab in the dark, but have you tried the connection string with the host first, then the dbname? EDIT: Ignore that, works OK on my db with your code. — Toddish, Jan 11 '13 at 10:49
@Coder anonymous Uncaught exception 'PDOException' with message 'could not find driver' — bw2801, Jan 11 '13 at 10:54
The error tells you what the issue is. You don't appear to have the pdo_mysql module enabled / installed. — Jonnix, Jan 11 '13 at 10:59
Here is the solution: http://stackoverflow.com/q/2852748/1687983 — Coder anonymous, Jan 11 '13 at 10:59
@JonStirling nope. The drivers are installed. I used phpinfo() to check it. — bw2801, Jan 11 '13 at 11:38

david strachan · Accepted Answer · 2013-01-11T22:34:30.963

6

Hard coding the connection with database & host in this order

$db = new PDO('dbname=blogscrip;mysql:host=localhost', root, pass);

Throws exception could not find driver

in the order in documentation

$dbh = new PDO('mysql:host=localhost;dbname=blogscript', root, pass);

Works

Change the order to host & database

edited Jan 11 '13 at 22:34

answered Jan 11 '13 at 14:40

david strachan

7,174
2
23
33

I made it like you said but there is the same error: `3D000 - 1046 - No database selected!`. – bw2801 Jan 11 '13 at 14:48
1

Glad to help.I find if you try to do things by the manual first before you try to experimentand and then add things incrementally.This way you know where the errors are occuring – david strachan Jan 11 '13 at 15:28

PDO - 3D000 No database selected

1 Answers1