PHP batch deletion of data reduces programmer stress_PHP tutorial

First, on the article list page (list.php), name the multi-select box: "$del_id[]", and the value is the article ID number. For example (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='< ?=$rs[id]?>' />
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('Delete successfully!');history.back();< /script>');
20. }else{
21. echo('< script type='text/javascript'>
    alert('Please select the project first!');history.back();< /script>');
22. }
23. ?>

1. PHP batch deletion of data first introduces the jquery script library

<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>

Add the following code to

<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>

2.com_shen.php (The following part can be played by yourself, use your own Database connection and processing methods)

<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></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>

The above are the relevant implementation methods for batch deletion of data in PHP.

http://www.bkjia.com/PHPjc/445963.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/445963.htmlTechArticleFirst, on the article list page (list.php), name the multi-selection box: $del_id[], the value is the article ID number. For example (list.php): form name = 'del_form' action = 'del.php' method = 'post' ?php $ re...