PDO不连接到远程mysql数据库

Question

I try to connect to remote mysql database.

$DBH = new PDO(
    'mysql:host='.$DB->DBHost.';dbname='.$DB->DBName,
    $DB->DBLogin, 
    $DB->DBPassword
);

In $DB object everything is OK. The properties DBHost, DBName, DBLogin, DBPassword exist and are correct. But, $DBH object is empty and I don't know why. Thanks.

Answer 1

Assuming your database contains tables, try running the following:

$statement = $DBH->query('SHOW TABLES');

var_dump($statement->fetchAll(PDO::FETCH_COLUMN);

If the connection was successfully established, the example above should give you a list of available tables in the database you connected to.

As you noted in the comments, the PDO object was created without any exceptions thrown. It just appears to you to be empty, that is probably all.