如何删除选中的每个对象


How do I delete every object that is checked

我有点卡住了。我希望能够删除复选框中选中的每个用户。

这是我现在的表格anvandare.php:

   <?php
                        $query = "select * from user order by date DESC";
                        $run = $mysqli->query($query);
                  while($row=mysqli_fetch_array($run)){ //Hämtar informationen från användaren 
                        $userID = $row['userID'];
                        $email = $row['email'];
                        $company = $row['company'];
                        $fname = $row['fname'];
                        $tel = $row['tel'];
                        $test_status = $row['test_status'];
                        $date = $row['date'];
                  ?>
               <td><?php echo $userID; ?></td>
               <td><?php echo $email; ?></td>
               <td><?php echo $company; ?></td>
               <td><?php echo $fname; ?></td>
               <td><?php echo zero($tel); ?></td>
               <td><?php echo $date; ?></td>
               <td><?php echo $test_status; ?></td>
               <form action="delete.php" method="POST">
               <td><input type="checkbox" name="<?php echo $userID;?>" value="checked"></td>
            </tr>
            <?php } ?>
            <tr><td><input type="submit" value="Skicka"></form></td></tr>
         </table>

这是我现在的delete.php..:

<?php
mysql_connect("localhost","root", "");
mysql_select_db("Webbprojekt");
if(isset($_POST))
{
    var_dump($_POST);
}
?>

你知道如何继续吗?我在提交时收到:中检查了三个

您可以使用foreach循环:

foreach($_POST as $userID => $value){
    // use $userID to delete the database-entry here
}

如果您将输入的名称更改为类似userIds[<? echo $userID; ?>]的名称,您将在接收页面上获得数组$_POST['userIds'],如果您想添加更多带有附加信息的输入,这将非常有用。这个数组可以像上面一样使用:

foreach($_POST['userIds'] as $userID => $value){
    // use $userID to delete the database-entry here
}