php - 如何包含已删除条目的数量

Question

所以基本上我想做的是让以下代码返回它在回显中删除的条目数量。

$sql6 = "DELETE FROM Already_Selected WHERE LastUpdated < NOW() - INTERVAL 5 DAY7";
if ($conn->query($sql6) === TRUE) {
    echo "Records older than 5 days have been deleted!";
} else {
    echo "<br> 0 Records to delete";
}
}

所以目前它输出

Records older than 5 days have been deleted

我真正希望它返回的地方

5 amount of rows have been deleted

例如

Answer 1

它将存储在数据库对象的 affected_rows 属性中。然后，像这样，例如:

$deleted_qty = $conn->affected_rows;

否则(程序风格):

$deleted_qty = mysqli_affected_rows($conn);