tal error: Call to a member function fetch_array() on boolean

Question

while($row = $dbresult->fetch_array(MYSQLI_ASSOC))
  {
    $markers[] = array(
      'id' => $row['id'],
      'name' => $row['name'],
      'lat' => $row['lat'],
      'lng' => $row['lng']
    );
  }

Getting fatal erroron this line while($row = $dbresult->fetch_array(MYSQLI_ASSOC))

Your query probably has a syntax error and returns false. Then you try and use it like a valid response... you need to check your query didn't return false before attempting to loop the results — naththedeveloper, Oct 06 '17 at 09:57

score 0 · Answer 1 · answered Oct 06 '17 at 09:57

Call to a member function fetch_array() on boolean

Your $dbresult is not mysqli_result object, so you got above error,

if($dbresult){

    while($row = $dbresult->fetch_array(MYSQLI_ASSOC))
    {

    }
 }else{
         // something went wrong
}

Ref : http://php.net/manual/en/mysqli.query.php

Returns FALSE on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return TRUE.

tal error: Call to a member function fetch_array() on boolean

1 Answers1