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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 怎么实现不管输入多少字符或者数组或者空格 输出的时候先显示输入的字符数组或者空格再提示输出。输出的结果每个字符后面都带上一个空格
  • ¥15 ros小车启动launch文件报错
  • ¥15 vs2015到期想登陆但是登陆不上
  • ¥15 求解四个变换矩阵中的未知数θ
  • ¥20 Intellij实现web登录界面
  • ¥15 IPQ5018制作烧录固件,boot运行失败(操作系统-linux)(相关搜索:操作系统)(相关搜索:操作系统)
  • ¥20 icefall在librispeech基础上加入个人数据集
  • ¥30 keepalive高可用故障运维配置询问
  • ¥15 求帮助!国家电网内网u盘突然识别不出来了。
  • ¥15 matlab语音变速变调同时实现