問題描述

我只是在嘗試 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()?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！