mysql php 多选框,使用复选框,PHP和MySQL删除多行

正如标题所示,我想从我的数据库中删除多行.为了实现这一目标,我有两个文件,一个前端文件,它生成一个表,显示用户可以删除的文件,这些文件是使用复选框选择的.

后端文件用于处理选定的复选框,并使用SQL语句删除所选文件.

我遇到的问题是将所选文件的ID从前端传递到后端.这两个文件的代码如下：

前端

????

//Build Table Query

$query="SELECT * FROM documents";

$result= mysqli_query($con, $query) or die("Invalid query");

$count = mysqli_affected_rows($con);

?>

Delete Multiple Files # Id Title Description File Location while($row = mysqli_fetch_array($result)){ ?>
	<?php echo $row['id']; ?>	<?php echo $row['title']; ?>	<?php echo $row['description']; ?>	<?php echo $row['doc_link']; ?>

}

?>

后端

????

$delete = $_POST['checkbox'];

//Then do what you want with the selected items://

foreach ($delete as $id) {

$query="DELETE FROM documents WHERE id = '".$id."'";

$result= mysqli_query($con, $query) or die("Invalid query");

}

//Show that the items have been successfully removed.//

if (mysqli_affected_rows($con) > 0) {

echo '

The selected items have been successfully deleted.

';

} else {

echo '

An error has occurred while processing your request

';

}

?>

作为一个注释,一旦这个工作,我将使用unlink函数使用前端表的doc_link部分删除服务器上的文件.

谢谢