Call to undefined method mysqli_stmt::get_result
mysqli, php
Solution
Please read the user notes for this method:
http://php.net/manual/en/mysqli-stmt.get-result.php
It requires the mysqlnd driver... If it isn't installed on your webspace you will have to work with `bind_result()` & `fetch()`!
Problem
Here's my code: ``` include 'conn.php'; $conn = new Connection(); $query = 'SELECT EmailVerified, Blocked FROM users WHERE Email = ? AND SLA = ? AND `Password` = ?'; $stmt = $conn->mysqli->prepare($query); $stmt->bind_param('sss', $_POST['EmailID'], $_POST['SLA'], $_POST['Password']); $stmt->execute(); $result = $stmt->get_result(); ``` I get the error on last line as: Call to undefined method mysqli_stmt::get_result() Here is the code for conn.php: ``` define('SERVER', 'localhost'); define('USER', 'root'); define('PASS', 'xxxx'); define('DB', 'xxxx'); class Connection{ /** * @var Resource */ var $mysqli = null; function __construct(){ try{ if(!$this->mysqli){ $this->mysqli = new MySQLi(SERVER, USER, PASS, DB); if(!$this->mysqli) throw new Exception('Could not create connection using MySQLi', 'NO_CONNECTION'); } } catch(Exception $ex){ echo "ERROR: ".$e->getMessage(); } } } ``` If I write this line: ``` if(!stmt) echo 'Statement prepared'; else echo 'Statement NOT prepared'; ``` It prints 'Statement NOT prepared'. If I run the query directly in the IDE replacing ? marks with values, it works fine. Please note that $conn object works fine in other queries in the project. Any help please.......