致命错误：未捕获错误：在布尔值[duplicate]上调用成员函数fetch_object（）

Question

This question already has an answer here:

• PHP Fatal error: Call to a member function fetch_object() on boolean 2 answers

I'm trying to figure out how to fix this error... I've seen other questions that have been closed but none of them have fixed my problem, I get that there's an issue with fetch_object() being boolean but I can't figure out why.

here's the my function:

function getNews($objCon, $page = null) {
    $sql = "SELECT id, headline, description FROM cms_news";
    if ($page) {
        $sql .= "WHERE cms_category_id = $page";
    }

    $objectResult = $objCon->query($sql);
    $news = [];
    while ($row = $objectResult->fetch_object()) {
        $news[$row->id] = $row;
    }
    return $news;
}

Thank you!!!

</div>

Answer 1

You need to add a space when you append your SQL:

$sql = "SELECT id, headline, description FROM cms_news ";

if ($page) {
    $sql .= "WHERE cms_category_id = $page";
}

Your previous SQL string would be:

SELECT id, headline, description FROM cms_newsWHERE cms_category_id = #