且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何测试MySQL查询修改数据库表数据是否成功?

更新时间:2023-02-02 12:28:15

你需要使用 mysqli->affected_rows() 用于检查查询是否成功(或者您可以使用 mysqli_stmt->execute() 的结果值.

You need to use mysqli->affected_rows() for checking if the query was successful (or you could use mysqli_stmt->execute()'s result value).

以你的例子为例,除了上面的内容什么都不修改:

Taking your example, and modifying nothing but for the above:

if($cmd=="deleterec") {
    $deleteQuery = "DELETE FROM AUCTIONS1 WHERE ARTICLE_NO = ?";
    
    if ($delRecord = $con->prepare($deleteQuery)) {
        $delRecord->bind_param("s", $pk);
        $delRecord->execute();
    
    
        if ($delRecord->affected_rows > 0) {
            echo "true";
        } else {
            echo "false";
        }

        $delRecord->close();
    }
}