第2个回答 2011-09-20
你是要做批量删除。。有单个删除也有批量删除
<?php
mysql_connect("localhost","root","");
mysql_select_db("new");
mysql_query("set names gb2312");
$sql="select * from meet";
$re=mysql_query($sql);
while($rs=mysql_fetch_array($re)){
?>
<tr>
<td height="51"><div align="center"><b id="b1">
<input name="name[]" type="checkbox" value="<?php echo $rs['id']?>" />
</b></div></td>
<td><div align="center"><b id="b1"><a href="#"><?php echo $rs['meet_name']?></a></b></div></td>
<td><div align="center"><?php echo $rs['meet_time']?></div></td>
<td><div align="center"><?php echo $rs['meet_add']?></div></td>
<td><div align="center"><a href="1.php?id=<?php echo $rs['id']?>">删除</a></div></td>
<td><div align="center"><?php echo $rs['meet_new_time']?></div></td>
<td><div align="center">
<?php if($rs['meet_s']==1){ echo "审核";}else{ echo "未审核";}?>
</div></td>
</tr>
<?php
}
?>
</table>
<h4><b id="b1"><a href="#"><input type="submit" value="删除" name="del" />
批量用的:list_do.php
mysql_connect("localhost","root","");
mysql_select_db("new");
mysql_query("set names gb2312");
if($d=$_POST['del']){
if(isset($d)){ echo "请选择删除"; }
$a=$_POST['name'];
foreach($a as $row){
$sql="delete from meet where id=$row;";
mysql_query($sql);
?>
<script type="text/javascript">alert("删除成功");location='list.php';</script>
<?php
}
}
单个用的 1.php
<?php
$row=$_GET[id];
$sql="delete from meet where id=$row;";
mysql_query($sql);
?>
<script type="text/javascript">alert("删除成功");location='list.php';</script>本回答被网友采纳