当前位置:首页 > PHP教程 > PHP高级教程

PHP 批量删除 sql语句

首先要了解sql语句
$sql="delete from `jb51` where id in (1,2,4)";
表单大概是:
复制代码 代码如下:

<form action="" method="post">
<input name="id_dele[]" type="checkbox" id="id_dele[]" value="1"/>
<input name="id_dele[]" type="checkbox" id="id_dele[]" value="2"/>
<input name="id_dele[]" type="checkbox" id="id_dele[]" value="3"/>
<input name="id_dele[]" type="checkbox" id="id_dele[]" value="4"/>
<input type="submit"/>
</form>

php函数主要用到implode
复制代码 代码如下:

$id_dele= implode(",",$_post['id_dele']);
$sql="delete from `user` where id in ($id_dele)";

http://www.jb51.net/article/6488.htm

【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:)!