ab520025520025 发表于 2017-3-20 10:06:59

php批量删除

批量删除

将要删除的数据的id组成数组
删除语句:
delete from `user` where id in ($ID_Dele)
如下:
<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)";
页: [1]
查看完整版本: php批量删除