调用未定义的方法 mysqli_stmt::get_result [英] Call to undefined method mysqli_stmt::get_result
问题描述
这是我的代码:
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();
我在最后一行得到错误:调用未定义的方法 mysqli_stmt::get_result()
I get the error on last line as: Call to undefined method mysqli_stmt::get_result()
这是 conn.php 的代码:
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(!stmt) echo 'Statement prepared'; else echo 'Statement NOT prepared';
它打印'Statement NOT Prepared'.如果我直接在 IDE 中运行查询替换 ?带有值的标记,它工作正常.请注意 $conn 对象在项目中的其他查询中工作正常.
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.......
推荐答案
请阅读此方法的用户注释:
Please read the user notes for this method:
http://php.net/manual/en/mysqli-stmt.get-result.php
它需要 mysqlnd 驱动程序...如果它没有安装在您的网站空间上,您将不得不使用 bind_result()
&fetch()
!
It requires the mysqlnd driver... If it isn't installed on your webspace you will have to work with bind_result()
& fetch()
!
这篇关于调用未定义的方法 mysqli_stmt::get_result的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!