Fatal error: Call to a member function execute() on boolean in /home/*****/public_html/lnews.php on line 22

Question

code:

$results = $mysqli->prepare("SELECT news_title FROM news ORDER BY posted_time DESC");
$results->execute();
$results->bind_result($news_title);

When I execute the code then it will return Fatal error: Call to a member function execute() on boolean in /home/*****/public_html/lnews.php on line 22. So, How can I fix this issue ?please help

Thank You

execute method `Returns TRUE on success or FALSE on failure.` — kRicha, Jun 09 '17 at 09:13
Your SQl query is not working, try to execute it yourself and see what you get. — Tobias F., Jun 09 '17 at 09:19

score 0 · Accepted Answer · answered Jun 09 '17 at 09:31

There is some error from database due to this the prepare method returns FALSE, on success this method returns prepared statement.

You can see the logs to determine the database error. Also, you should change your code in the following way and throw some exception in else.

$results = $mysqli->prepare("SELECT news_title FROM news ORDER BY posted_time DESC");
if($results !== false) {
    $results->execute();
    $results->bind_result($news_title);
}

In this case if false return (if there is database error) the execute method would not be invoked.

Fatal error: Call to a member function execute() on boolean in /home/*****/public_html/lnews.php on line 22

1 Answers1