如何检查mysqli_query是否删除了任何行 [英] How to check if mysqli_query deleted any rows

问题描述

我创建了从数据库中删除一些数据的函数.这是其中的一部分:

I created function that delete some data from my database. This is part of it:

mysqli_query($con, "DELETE FROM appsdata WHERE (Name='$what' OR ID='$what') AND ownerID='$userID'");

但是我想检查删除了多少行. Mysql_query始终返回true，无论是否删除了某项内容:/

But I want to check how many rows were deleted. Mysql_query returns always true, no matter if something was deleted :/

推荐答案

您可以使用mysqli_affected_rows:

mysqli_affected_rows($mysqli_link);

或

$mysqli->affected_rows

http://php.net/manual/en/mysqli.affected- rows.php

这篇关于如何检查mysqli_query是否删除了任何行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！