MYSQL prepare query for update using PHP
function SavePaymentStatus($status,$refno)
{
$stmt = $this->conn->stmt_init();
if ($stmt->prepare("update rlss4 set id10=? where id2=?"))
{
$stmt->bind_param("ss", $status, $refno);
$stmt->execute() or die("<h1>Error</h1>".mysqli_error($this->conn));
$stmt->close();
return true;
}
else
{
return false;
}
}