首先在文章列表页面(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[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('删除成功!');history.back();< /script>'); }else{ echo('< script type='text/javascript'> alert('请先选择项目!');history.back();< /script>'); } ?> PHP批量删除数据首先引入jquery脚本库< script language='JavaScript' type='text/javascript' src='http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js'> < /script>
将下列代码加上
< script language='JavaScript' type='text/javascript'> $(document).ready(function() { $('input[id='del']').click(function() { var del_arry=''; $('input[name='del_id[]'][checked]').each(function(){ del_arrydel_arry=del_arry+$(this).val()+','; }); if (del_arry!='') { $.post('com_del.php', {value:''+del_arry+''}, function(data){ if(data==1) { window.location.reload(); alert(' 删除成功!'); }else if(data==2){ alert('删除失败!'); } }); } }); }); < /script>
