douchen4534
2017-07-31 06:30
浏览 126
已采纳

PDO不连接到远程mysql数据库

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.

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongwei4444 2017-07-31 06:44
    已采纳

    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.

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题