如何计算没有行删除的行数，因为我循环遍历php中的记录

Question

我正在使用下面的代码循环并从数据库中删除记录。请我想算一下代码循环中删除的行数。任何想法将不胜感激

$post_ids = intval($_POST['post_id']);

foreach($post_ids as $id){

    // Delete record

// I will sanitize for sql injection attack later

    $query = "DELETE FROM posts WHERE id=".$id;

    mysqli_query($con,$query);

}

Answer 1

只需一次将其全部删除，然后致电 $deleted = mysqli_affected_rows($con);请参阅文档。