<?php
echo “<form method=’post’ name=’form1′ action=’#’>”;
echo “<table border=1>”;
while($row=mysql_fetch_row($sql))
{
$id=$row[0];
$beizhu=$row[3];
echo “<tr>”;
echo “<td><input type=’checkbox’ name=’del[]’ value=’$id’></td>”;
echo “<td>$id</td>”;
echo “<td>$beizhu</td>”;
echo “</tr>”;
}
echo “</table>”;
echo “<input type=’reset’ name=’reset’ value=’重选’><input type=’submit’ name=’submit’ value=’提交’></form>”;
if($_POST[‘submit’]!=””)
{
foreach($_POST[‘del’] as $id)
{
$query=mysql_query(“delete from admin where id={$id}”)or die(“删除失败”);
}
}
?>
这个是利用复选框name值为数组,然后利用foreach对数组删除每一条记录
由此可以延伸用于批量插入和更新数据,大家自己摸索摸索。呵呵。。