致命錯誤:對非對象上的成員函數FETCH_Assoc()的調用我正在嘗試執行一些查詢,以獲得有關某些圖像的一頁信息。我寫了一個函數function get_recent_highs($view_deleted_images=false){
$lower = $this->database->conn->real_escape_string($this->page_size * ($this->page_number - 1));
$query = "SELECT image_id, date_uploaded FROM `images` ORDER BY ((SELECT SUM( image_id=`images`.image_id ) FROM `image_votes` AS score) / (SELECT DATEDIFF( NOW( ) , date_uploaded ) AS diff)) DESC LIMIT " . $this->page_size . " OFFSET $lower"; //move to database class
$result = $this->database->query($query);
$page = array();
while($row = $result->fetch_assoc())
{
try
{
array_push($page, new Image($row['image_id'], $view_deleted_images));
}
catch(ImageNotFoundException $e)
{
throw $e;
}
}
return $page;}根據它們的受歡迎程度來選擇這些圖像的頁面。我寫了一個Database類處理與數據庫和Image類,該類保存有關圖像的信息。當我試圖運行它時,我會得到一個錯誤。Fatal error: Call to a member function fetch_assoc() on a non-object$result是一個mysqli結果集,所以我很困惑為什么這個結果不起作用。
3 回答

神不在的星期二
TA貢獻1963條經驗 獲得超6個贊
MySQli->query()
$result = $this->database->query($query);if (!$result) { throw new Exception("Database Error [{$this->database->errno}] {$this->database->error}");}

HUH函數
TA貢獻1836條經驗 獲得超4個贊
var_dump($result)

慕容森
TA貢獻1853條經驗 獲得超18個贊
Ex: $sql= "SELECT * FROM";$sql .= "table1";
添加回答
舉報
0/150
提交
取消