1、前台获取被选中的数据的id(一个字符串)
代码:
//删除多个
$('#batch_del').click(function(){
// alert(123);
var list = $(':checkbox:checked');
ids = '';
list.each(function(){
ids += $(this).val() + ',';
});
// alert(ids);
ids = ids.substr(0,ids.length-1);
var url = "{:U('batch_del')}";
if(window.confirm('此操作不可逆,是否确认?')){
$.ajax({
url:url,
data:{ids:ids},
type:'GET',
dataType:'json',
success:function(res){
if(res.status == 200){
alert(res.msg);
location = location;
}else{
alert(res.msg);
}
}
});
}
});
2、后台获取所有id
①、用expolde()函数,把id值组成的字符串转为数组
②、循环这个数组,并执行更新数据操作
代码:
function batch_del(){
$ids = I('get.ids');
$str = explode(',',$ids);
// print_r($str);die;
$dept = M('Dept');
foreach($str as $v){
$map['dept_id'] = $v;
$res = $dept->where($map)->setField('status',0);
}
// die;
if($res){
$data['status'] = 200;
$data['msg'] = "删除成功";
$this->ajaxReturn($data);
}else{
$data['status'] = 400;
$data['msg'] = "删除失败";
$this->ajaxReturn($data);
}
// echo $dept->getLastSql();
}