CODEWITHSUNDEEP
phpmysqlpdo
Sizuji
Sizuji

Reputation: 898

PDO doesn't connect to remote mysql database

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.

Upvotes: 1

Views: 490

Answers (1)

localheinz
localheinz

Reputation: 9592

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.

Upvotes: 2

Related Questions