dongzhuang6247 2019-08-16 19:20
浏览 194
已采纳

PHP致命错误:未捕获错误:调用布尔值[duplicate]上的成员函数setFetchMode()

This question already has an answer here:

I understand that this error occurs when you try to call a method on something that is not an object. In this case, the variable that should hold an object is actually a boolean.

I just don't know how to fix it.

If you look at MySQL::query(), the function returns either false (on error) or an object of the type mysql_result. A bad SQL query will make the query fail and the function to return false.

Because the error occurs when I try to call setFetchMode, it probably means my PDO query failed, but I honestly have no idea.

<?php

$host = 'localhost';
$dbname = 'DBNAME';
$username = 'USERNAME';
$password = 'PASSWORD';

try {

   $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);

   $sql = 'SELECT id, topic, category, type, doi, author, year
   FROM literature
   ORDER BY id';

   $q = $pdo->query($sql);

   $q->setFetchMode(PDO::FETCH_ASSOC);

} catch (PDOException $e) {

   die("Could not connect to the database $dbname :" . $e->getMessage());

}

?>

It returns the error: "PHP Fatal error: Uncaught Error: Call to a member function setFetchMode() on boolean in /root/somewhere/somefile/anotherfile/FILENAME.php:12" because $q is false. I just don't know how to have it return the object.

The weird part is that it works perfectly fine on my stand-alone server.

</div>
  • 写回答

2条回答 默认 最新

  • duanban4769 2019-08-16 19:59
    关注

    if your $q is false its mean you have error in sql query or a connection, you can use this connection to see more info about your error:

    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
    

    then it will throw exception before you try to access (bool)->{someMethod}

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图问题
  • ¥15 有段代码不知道怎么理解,const isToken = (config.headers || {}).isToken === false
  • ¥100 采用栈和深度优先算法对我的代码进行修改显示路径
  • ¥15 pointnet2包安装
  • ¥20 射频功率问题,解答者有酬谢!
  • ¥80 构建降雨和积水的预测模型
  • ¥15 #Qt Transform setTransform()在鼠标拖动移动视角是一致在原地不动,无法变换视角(细微观察似乎视图有在原地抖动),无法变换视角(细微观察似乎视图有在原地抖动)
  • ¥50 如何利用无人机拍摄的数码照片测量鸟卵的长短径
  • ¥100 github贡献者给与奖励
  • ¥15 使用DS18B20+ESP8266获取温度数据返回-127.00