js 部分
//头工具栏事件
table.on('toolbar(myorder)', function(){
var checkStatus = table.checkStatus('MyOrder');
var data = checkStatus.data;
// 将id循环放入数组
var ids = [];
data.forEach(function(item){
ids.push(item.id);
});
if (data.length == 0) {
layer.msg('至少选择一条数据',{time:1000});
return false;
}
layer.confirm('您确认要删除吗',function(e){
if (e) {
$.ajax({
url:'OrderAction.php?type=DeleteNumberPool',
data:{ids:ids},
type: 'POST',
success:function(data){
window.location.reload();
layer.close(e);
}
})
}
})
});
PHP部分
if ($_GET['type'] == 'DeleteNumberPool') {
$arr = $_POST['ids'];
$str = implode("','",$arr);
$sql = "delete from numberpool where id in('{$str}')";
mysqli_query($link, $sql);
}