- php文章批量删除
发布时间:2010-12-22 类别:PHP技术 来源:侠客工作室 -
- 1
- 2
- 3
- 4
- 5
<form name="del_form" action="a_do.php" method="post">
<?php
$link=mysql_connect("localhost","root","123") or die("不能连接数据库:".mysql_error());
mysql_select_db("wgbawei",$link) or die("不能选择数据库:".mysql_error());
mysql_query("set names utf8");$result=mysql_query("select * from admin");
while($rs=mysql_fetch_array($result)){
?>
<input name="del_id[]" type="checkbox" value="<?=$rs[admin_id]?>" /><?=$rs[admin_name]?>
<?php
}
?>
<input type="submit" value="删除" />
</form><?php
$link=mysql_connect("localhost","root","123") or die("不能连接数据库:".mysql_error());
mysql_select_db("wgbawei",$link) or die("不能选择数据库:".mysql_error());
mysql_query("set names utf8");$id = implode(",",$_POST[‘del_id‘]);
$query = mysql_query("delete from admin where admin_id in (".$id.")");
if ($query) {
echo "<script>alert(‘批量删除成功!‘)</script>";
echo "<script>location.href=‘new_list.php‘</script>";
}else {
echo "<script>alert(‘删除失败‘)</script>";
}
?>- ☆☆☆技术交流群:5684178☆☆☆
- 上一篇:ecshop商品分类显示数量
- 下一篇:PHP 获取客户端与服务器的IP的实例代码