Call to undefined method mysqli_stmt::get_result()

Question

I am new to the php development and may be this would be the simple answer but I am having this Fatal error

Fatal error: Call to undefined method mysqli_stmt::get_result() in

well on my local machine, this works fine and Current PHP version is 5.6.11, and on my web server it giving this error. I have tried to chang PHP version to 5.6.30 from 5.4.45

here is my code

 $stmt = $this->conn->prepare("SELECT * FROM profile WHERE email_id = ?");
 $stmt->bind_param("s", $email);
 if ($stmt->execute()) {
     $user = $stmt->get_result()->fetch_assoc();//on this line I am having problem
     $stmt->close();
     return $user;
}

FYI: mysqlnd is enabled on my server

Why is it not working on my web server?

Please put me in right direction

Possible duplicate https://stackoverflow.com/questions/8321096/call-to-undefined-method-mysqli-stmtget-result — Dev. Joel, Jun 03 '17 at 04:42

score 1 · Answer 1 · answered Jun 03 '17 at 04:47

Try the below code. I tailored it in relation with your problem

  $stmt = $this->conn->prepare("SELECT * FROM profile WHERE email_id = ?");
    $stmt->bind_param('s', $email);
    $result = $stmt->execute();
   $stmt->store_result();//after this line we can output the number of rows if you need to check that as well
   $number_of_rows = $stmt->num_rows;
   $meta = $stmt->result_metadata();
   $parameters = array();
  $results = array();
  while ($field = $meta->fetch_field()) {
         $parameters[] = &$row[$field->name];
  }
  call_user_func_array(array($stmt, 'bind_result'), $parameters);
       while ($stmt->fetch()) {
             foreach ($row as $key => $val) {
                  $x[$key] = $val; //here we get the key => value (Column => Value)
                      }
                      $results[] = $x; //lets grab everything here
                  }
print_r($results);

Thankyou for your answer. I ll check that... but is there any way that my code works on server?? bcoz it ll talk lifetime to change all code at once — parish, Jun 03 '17 at 05:00
I really do not know why. I encountered an issue in doing a `select *` using mysqli prepapred statements and the above solution helped — Rotimi, Jun 03 '17 at 05:01

Call to undefined method mysqli_stmt::get_result()

1 Answers1