php批量删围绕sql语句构建$sql ="delete from kc_cate where id in ({$id})";
批量删除按钮:
" type="checkbox"> 批量删除获取批量删除的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());
}
}