PHP batch deletion of data reduces programmer stress

PHP batch deletion of data reduces programmer stress_PHP tutorial

WBOY

Release： 2016-07-15 13:34:46

Original

897 people have browsed it

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

< 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[id]?>' />
< ?=$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('Delete successfully!');history.back();< /script>');
}else{
echo('< script type='text/javascript'>
alert('Please select the project first!');history.back();< /script>');
}
?>

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>

Copy after login

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>

Copy after login

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>

Copy after login

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