douchen4534
douchen4534
2017-07-31 06:30

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 dongwei4444 4年前

    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.

    点赞 评论 复制链接分享