php ajax .get 批量删除
php批量删围绕sql语句构建
$sql ="delete from kc_cate where id in ({$id})";
批量删除按钮:
<td align="left"><input data-id="<?php echo $t['id'] ;?>" type="checkbox"></td> <td align="left" colspan='4'> <a id="del_btn" href="javascript:volid(0);" onclick="pldel();">批量删除</a></</td>
获取批量删除的id数组
var tbodyCheckBox = $('input'); var allCheckedIds = []; tbodyCheckBox.on('change',function () { var id = $(this).data('id'); if ($(this).prop('checked')) { allCheckedIds.push(id); } else { allCheckedIds.splice(allCheckedIds.indexOf(id), 1); } });
ajax删除:
function pldel() { var ids =new Array(); if(allCheckedIds.length){ var url = "/admin/cate_del.php?id="+allCheckedIds; layer.open({ type : 0, title : '是否提交?', btn: ['yes', 'no'], icon : 3, closeBtn : 2, content: "是否确定批量删除", scrollbar: true, yes: function(){ // 执行相关跳转 $.get( url, function(s){ if(s.status == 1) { return dialog.success(s.message,''); // 跳转到相关页面 }else { return dialog.error(s.message); } } ,"JSON"); }, }); } }
php接收执行删除
if($_SERVER['REQUEST_METHOD'] == 'GET'){ if(empty($_GET['id'])){ exit('缺少必要的参数'); } $id = $_GET['id']; $sql ="delete from kc_cate where id in ({$id})"; try { $row =sql_excute($sql); if($row>=1) { return show(1,'分类名称批量删除成功'); }else { return show(0,'分类名称批量删除失败!'); } }catch(Exception $e) { return show(0,$e->getMessage()); } }