无法通过PHP PDO类连接到数据库

Question

I'm trying to connect to my mySQL database using the PDO class in PHP.

Here is my Code :

// Connects to Our Database via PDO.
if($local) {
    try {
        $db = new PDO("mysql:=localhost;dbname=bbc_archive;port=3306", "root", "");
        $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
        $db->exec("SET NAMES 'utf8'");
        } catch(Exception $e) {
            echo "Connection to the DataBase was not possible. ";
            die();
        }
    } else {
    try {
        $db = new PDO("mysql:=bbcarchive.db.11505263.hostedresource.com;dbname=bbcarchive", "bbcarchive", "myPassword");
        $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
        $db->exec("SET NAMES 'utf8'");
    } catch(Exception $e) {
        echo "Connection to the live DataBase was not possible. ";
        die();
    }
}

The $local variable is defined before and determines whether or not the script is running on a the live server or a test server.

When running in my local environment everthing works fine but on my live server it echo's out "Connection to the live DataBase was not possible." from the catch block.

I've contacted my host provider (godaddy) and they think it's a coding error. I've also, obviously, checked the hostname, dbname, username and password a 100 times and it's all correct. I just can't see the problem!

How can i do this ?

Answer 1

Your DSN seems to be incorrect. The documentation on MySQL DSNs indicates that it should look somewhat like this:

$db = new PDO("mysql:host=localhost;dbname=bbc_archive;port=3306", "root", "");