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

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

1.  form name='del_form' action='del.php' 
   method='post'>   
2.  ?php   
3. $result=mysql_query('select * from news');   
4. while($rs=mysql_fetch_array($result)){   
5. ?>   
6.  input name='del_id[]' type='checkbox' 
   id='del_id[]' value='' />
7.  ?=$rs[title]?>   
8.  ?php   
9. }   
10. ?>   
11.  /form>   
12. 2、处理页面（del.php）：   
13.  ?php   
14. if($del_id!=''){   
15. $del_num=count($del_id);   
16. for($i=0;$i $del_num;$i++){   
17. mysql_query('Delete from news where 
    id='$del_id[$i]'');   
18. }   
19. echo(' script type='text/javascript'>
    alert('删除成功！');history.back(); /script>');   
20. }else{   
21. echo(' script type='text/javascript'>
    alert('请先选择项目！');history.back(); /script>');   
22. }   
23. ?>  

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

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><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">&gt;</span><span> </span></span></span></li>
<li><span class="tag"><span> /script</span><span class="tag">&gt;</span><span> </span></span></li>
</ol>

将下列代码加上

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><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">&gt;</span><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> /script</span><span class="tag">&gt;</span><span> </span></span></li>
</ol>

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

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><span> ?php   </span></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">&gt;</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> $del_num;$ii++){   </span></span>
</li>
<li>
<span>$conn-</span><span class="tag">&gt;</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">&gt;</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">&gt;</span><span>ColseConnection();  </span>
</li>
<li>
<span class="tag">?&gt;</span><span> </span>
</li>
</ol>

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