php mysql函数未定义,PHP致命错误:调用未定义函数mysqli_stmt_get_result()

我不断收到错误PHP致命错误:调用未定义函数mysqli_stmt_get_result()。我正在使用PHP版本5.6,并在主机提供商c面板中启用了扩展mysqlind,但我不知道为什么仍然出现此错误。我进行了研究,发现每次需要启用mysqli

nd才能使用mysqli_stmt_get_result。任何人都可以协助/教导我在做什么错。谢谢。

SIGNUP.PHP:

session_start();

include '../dbh.php';

$respond = array(

'status' => true,

'message' => 'There was an error',

'redirect',

'errors'

);

if (isset($_POST['submit'])) {

$first = $_POST['first'];

$last = $_POST['last'];

$email = $_POST['email'];

$pwd = $_POST['pwd'];

$errorEmpty = false;

$errorEmail = false;

if (empty($first) || empty($last) || empty($email) || empty($pwd)) {

$respond['errors'][] = "Please fill out all fields!";

$respond['errorEmpty'] = true;

} elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {

$respond['errors'][] = "Please enter a valid email address!";

$respond['errorEmail'] = true;

} else {

$sql = "SELECT email FROM user WHERE email= ? ";

$stmt = mysqli_prepare($conn, $sql);

mysqli_stmt_bind_param($stmt, 's', $email);

mysqli_stmt_execute($stmt);

$result = mysqli_stmt_get_result($stmt); //This is where I getting my error

$num_rows = mysqli_num_rows($result);

if ($num_rows > 0) {

$respond['errors'][] = "That email address already exists!";

$respond['errorEmail'] = true;

}

else {

$encryptpwd = password_hash($pwd, PASSWORD_DEFAULT);

$sql = "INSERT INTO user (first, last, email, pwd) VALUES (?,?,?,?)";

$stmt = mysqli_prepare($conn, $sql);

mysqli_stmt_bind_param($stmt, 'ssss', $first, $last, $email, $password_hash);

if (mysqli_stmt_execute($stmt)) {

$userID = mysqli_insert_id($conn);

$status = 1;

$sql2 = "INSERT INTO profileImg (email, status) VALUES(?,?)";

$stmt2 = mysqli_prepare($conn, $sql2);

mysqli_stmt_bind_param($stmt2, 'si', $email);

mysqli_stmt_execute($stmt);

$_SESSION['id'] = $userID;

$respond['redirect'] = "../profile.php?id=$userID";

}

}

}

}

echo json_encode($respond);

?>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值