我想选择多个项目来删除数据库中的记录。但我做不到。我的delete.php
很好。如何使用它删除多个选定项目。我刚刚创建了一个复选框。我怎样才能使该复选框工作。
echo"<TR><TD>Select</td><TD>S.N.</td><td><B>Full Name</B></td><td><B>Options</B></td></TR>";
while ($myrow = $result->fetch_assoc())
{
echo "<tr><td><input type='checkbox'name='mycheck'onclick='toggleform('document.myform','mycheck','ptext')'></td>";
echo "<TD>".$myrow['id']."</TD>";
echo "<TD>".$myrow['name']." </TD>";
echo "<TD><a href='"view1.php?id=".$myrow['id']."'">View</a> ";
echo "<a href='"delete.php?id=".$myrow['id']."'">Delete</a> ";
echo "<a href='"edit1.php?id=".$myrow['id']."'">Edit</a>";
}
<input type="button" name= "ptext" value="Delete selected">
您必须
创建checkbox name
array
类型,即 mycheck[]
.然后,在delete_all.php页面中,找到选中的总复选框并相应地将其删除。
<form method='POST' action="delete_all.php">
<?php
echo"<TR><TD>Select</td><TD>S.N.</td><td><B>Full Name</B></td><td><B>Options</B></td></TR>";
while ($myrow = $result->fetch_assoc())
{
echo "<tr><td><input type='checkbox' name='mycheck[]' value=".$myrow['id']."></td>";
echo "<TD>".$myrow['id']."</TD>";
echo "<TD>".$myrow['name']." </TD>";
echo "<TD><a href='"view1.php?id=".$myrow['id']."'">View</a> ";
echo "<a href='"delete.php?id=".$myrow['id']."'">Delete</a> ";
echo "<a href='"edit1.php?id=".$myrow['id']."'">Edit</a>";
}
?>
<input type="submit" name= "ptext" value="Delete selected">
</form>
delete_all.php
<?
extract($_POST);
$totalCheckboxChecked = sizeof($mycheck);
for($i=0;$i<$totalCheckboxChecked;$i++)
{
$idToDelete = $mycheck[$i];
echo "DELETE FROM table_Name WHERE id_ColumnName = '$idToDelete'";
// Execute Your Querys
}
?>
您是否在删除.php页面上获取所有 ID? 如果是,则简单使用
DELETE FROM tableName
WHERE id IN ($id1 , $id2 , $id3 , etc);
如果没有,我会这样做的方法是,我会使用 form,然后使用方法 post 将其发布在 delete.php 页面中,然后简单地从超级全局中获取值
$_POST[]
并使用上面的查询,希望这有帮助。