PDO:在非对象上调用成员函数 fetch()?

时间:2023-04-07
本文介绍了PDO:在非对象上调用成员函数 fetch()?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我只是在尝试 PDO 并且收到此错误,致命错误:在非对象上调用成员函数 fetch(),但它不是已经在 $this->db 对象上了吗?

I am just trying out PDO and I get this error, Fatal error: Call to a member function fetch() on a non-object, but isn't it already on the $this->db object?

class shoutbox {

    private $db;

    function __construct($dbname, $username, $password, $host = "localhost" ) 
    { # db conections
        try {
            $this->db = new PDO("mysql:host=".$hostname.";dbname=".$dbname, $username, $password);
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }
    }

    function getShouts()
    {
        $sql_shouts = $this->db->query('SELECT shoutid, message, pmuserid, ipadress, time FROM shouts WHERE pmuserid == 0');

        return $sql_shouts->fetch(PDO::FETCH_OBJ);

    }

}

推荐答案

仔细查看 PDO::query,特别是返回值"部分:

Look carefully at the documentation for PDO::query, particularly the "Return Values" section:

PDO::query() 返回一个 PDOStatement对象,或失败时为 FALSE.

PDO::query() returns a PDOStatement object, or FALSE on failure.

重要的一点是失败时为 FALSE".FALSE 不是一个对象,所以调用 ->fetch() 是个坏消息.

The important bit is "FALSE on failure". FALSE is not an object, so calling ->fetch() is bad news.

该错误可能是由于您使用了=="比较运算符.在 SQL 中,它只是=".

The error is probably due to your use of "==" comparison operator. In SQL, it's just "=".

你应该测试 $sql_shouts 是不是假的,然后对错误做一些聪明的事情,如果有的话:

You should test that the $sql_shouts is not false, and then do something smart with the error, if there was one:

<?PHP
$sql_shouts = $this->db->query('...');
if ($sql_shouts === false){
    $errorInfo = $this->db->errorInfo();
    //log the error or take some other smart action
}
return $sql_shouts->fetch(PDO::FETCH_OBJ);

这篇关于PDO:在非对象上调用成员函数 fetch()?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:表名作为参数使用 PDO/MySQL 准备好的语句 下一篇:Php PDO 功能有多安全:lastInsertId?

相关文章