php - fatal error : Uncaught Error: Call to a member function bind_result() on boolean in --- line22

Question

<?php
$con = mysqli_connect("localhost","root","","swap"); //connect to database
if (!$con){
    die('Could not connect: ' . mysqli_connect_errno()); //return error is 
connect fail
}
?>

<?php
$user= $_POST['iuser'];
$name= $_POST['iname'];
$pwd = $_POST['ipwd'];
$cont= $_POST['icont'];
$userid = $_POST['uid'];

$updateuser=$con->prepare("UPDATE users SET username = '$user', password = 
'$pwd', email = '$mail', contact = '$cont' WHERE userID ='" .$userid. "'");    
$updateuser->bind_result($user, $pwd, $name, $add, $mail, $cont, $cardno);
$updateuser->execute();`

我检查了许多其他问题，但似乎找不到任何错误。有帮助吗？

Answer 1

您的 bind_result 中的参数多于所需的参数。只需提供您需要的参数并使用 ?而不是参数名称(不确定但我这样使用它):

$updateuser=$con->prepare("UPDATE users SET username = ?, password = 
?, email = ?, contact = ?, WHERE userID = ?");    
$updateuser->bind_result($user, $pwd, $mail, $cont, $cardno);

类似的东西对我有用。 (检查每个参数类型是否与数据库列类型匹配)