PHP批量删除数据减轻程序员压力_PHP教程-php教程-PHP中文网

PHP批量删除数据减轻程序员压力_PHP教程

php中文网

发布： 2016-07-15 13:34:46

原创

1052人浏览过

首先在文章列表页面(list.php)，将多选筐命名为:“$del_id[]”，值为文章ID号。例如(list.php):

form name='del_form' action='del.php'
method='post'>
?php
$result=mysql_query('select * from news');
while($rs=mysql_fetch_array($result)){
?>
input name='del_id[]' type='checkbox'
id='del_id[]' value='' />
?=$rs[title]?>
?php
}
?>
/form>
2、处理页面（del.php）：
?php
if($del_id!=''){
$del_num=count($del_id);
for($i=0;$i $del_num;$i++){
mysql_query('Delete from news where
id='$del_id[$i]'');
}
echo(' script type='text/javascript'>
alert('删除成功！');history.back(); /script>');
}else{
echo(' script type='text/javascript'>
alert('请先选择项目！');history.back(); /script>');
}
?>

立即学习“PHP免费学习笔记（深入）”；

图可丽批量抠图

用AI技术提高数据生产力，让美好事物更容易被发现

查看详情

1.PHP批量删除数据首先引入jquery脚本库

立即学习“PHP免费学习笔记（深入）”；

<ol class="dp-xml"><li class="alt"><span><span class="tag"><</span><span> </span><span class="tag-name">script</span><span> </span><span class="attribute">language</span><span>=</span><span class="attribute-value">'JavaScript'</span><span> <br /></span><span class="attribute">type</span><span>=</span><span class="attribute-value">'text/javascript'</span><span> <br /></span><span class="attribute">src</span><span>=</span><span class="attribute-value">'http://jqueryjs.googlecode.<br />com/files/jquery-1.3.2.min.js'</span><span class="tag">></span><span> </span></span></li><li><span class="tag"><</span><span> /script</span><span class="tag">></span><span> </span></li></ol>

登录后复制

将下列代码加上

立即学习“PHP免费学习笔记（深入）”；

<ol class="dp-xml"><li class="alt"><span><span class="tag"><</span><span> </span><span class="tag-name">script</span><span> </span><span class="attribute">language</span><span>=</span><span class="attribute-value">'JavaScript'</span><span> <br /></span><span class="attribute">type</span><span>=</span><span class="attribute-value">'text/javascript'</span><span class="tag">></span><span> </span></span></li><li><span>$(document).ready(function()   </span></li><li class="alt"><span>{   </span></li><li><span>$('input[</span><span class="attribute">id</span><span>=</span><span class="attribute-value">'del'</span><span>]').click(function()   </span></li><li class="alt"><span>{   </span></li><li><span>var </span><span class="attribute">del_arry</span><span>=</span><span class="attribute-value">''</span><span>;  </span></li><li class="alt"><span>$('input[</span><span class="attribute">name</span><span>=</span><span class="attribute-value">'del_id[]'</span><span>][checked]')<br />.each(function(){  </span></li><li><span class="attribute">del_arry</span><span class="attribute-value">del_arry</span><span>=del_arry+$(this).val()+',';   </span></li><li class="alt"><span>});  </span></li><li><span>if (del_arry!='')  </span></li><li class="alt"><span>{  </span></li><li><span>$.post('com_del.php', {value:''+<br />del_arry+''}, function(data){  </span></li><li class="alt"><span>if(</span><span class="attribute">data</span><span>==1) {   </span></li><li><span>window.location.reload();  </span></li><li class="alt"><span>alert(' 删除成功！');  </span></li><li><span>}else if(</span><span class="attribute">data</span><span>==2){  </span></li><li class="alt"><span>alert('删除失败！');  </span></li><li><span>}  </span></li><li class="alt"><span>});  </span></li><li><span>}  </span></li><li class="alt"><span>});  </span></li><li><span>});  </span></li><li class="alt"><span class="tag"><</span><span> /script</span><span class="tag">></span><span> </span></li></ol>

登录后复制

立即学习“PHP免费学习笔记（深入）”；

2.com_shen.php（下面的部分可以自己发挥，用你自己的数据库连接和处理方法）

立即学习“PHP免费学习笔记（深入）”；

<ol class="dp-xml"><li class="alt"><span><span class="tag"><</span><span> ?php   </span></span></li><li><span>include '../cyr/inc/conn.php';  </span></li><li class="alt"><span>include '../cyr/inc/page.class.php';  </span></li><li><span>$</span><span class="attribute">conn</span><span> = </span><span class="attribute-value">new</span><span> DB();  </span></li><li class="alt"><span>$conn-</span><span class="tag">></span><span> Connection();  </span></li><li><span>$</span><span class="attribute">array</span><span> = $_POST['value'];   </span></li><li class="alt"><span>//将所选的值组成的数组放入$array数组  </span></li><li><span>$</span><span class="attribute">array</span><span>=</span><span class="attribute-value">split</span><span> (',', $array);  </span></li><li class="alt"><span>if(!empty($array)){   </span></li><li><span>$</span><span class="attribute">del_num</span><span>=</span><span class="attribute-value">count</span><span>($array);   </span></li><li class="alt"><span>for($</span><span class="attribute">ii</span><span>=</span><span class="attribute-value">0</span><span>;$ii</span><span class="tag"><</span><span> $del_num;$ii++){   </span></li><li><span>$conn-</span><span class="tag">></span><span class="attribute">str</span><span> = </span><span class="attribute-value">'update yj_comment set<br /> co_shenhe=1 where id='</span><span>.$array[$ii];  </span></li><li class="alt"><span>$conn-</span><span class="tag">></span><span>getResult();  </span></li><li><span>}   </span></li><li class="alt"><span>echo $</span><span class="attribute">string</span><span> = </span><span class="attribute-value">1</span><span>;  </span></li><li><span>}else{  </span></li><li class="alt"><span>echo $</span><span class="attribute">string</span><span> =</span><span class="attribute-value">2</span><span>;  </span></li><li><span>}  </span></li><li class="alt"><span>$conn-</span><span class="tag">></span><span>ColseConnection();  </span></li><li><span class="tag">?></span><span> </span></li></ol>

登录后复制

立即学习“PHP免费学习笔记（深入）”；

以上就是PHP批量删除数据的相关实现方法。