如何检查UPDATE mysqli查询是否正确执行? [英] How to check if an UPDATE mysqli query is correctly executed?

问题描述

这是我的情况:

$sql = 'UPDATE user SET password = ? WHERE username = ? AND password = ?';
if($stmt->prepare($sql)) {
    $stmt->bind_param('sss', $newPass, $_SESSION['username'], $oldPass);
    $stmt->execute();
}

现在，如何查看UPDATE查询是否成功执行?更准确地说，如何查看旧密码和用户名是否正确，以便我可以存储新密码? 我已经尝试过这样做:

Now, how can I see if the UPDATE query is successfully executed? And more precisely how can I see if the old password and username are correct so that I can store the new password? I've tried by doing this:

$res = $stmt->execute();
echo 'Result: '.$res;

但是我总是得到:

Result: 1

即使旧密码不正确.

推荐答案

不更新任何行的查询都不是错误条件.这只是一个成功的查询，没有任何改变.要查看更新是否确实更改了任何内容，您必须使用 mysqli_affected_rows()

A query which updates no rows is NOT an error condition. It's simply a succesful query that didn't change anything. To see if an update actually did change anything, you have to use mysqli_affected_rows()

这篇关于如何检查UPDATE mysqli查询是否正确执行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！