ajax批量删除数据,快捷方便,实现无页面刷新。
<?phpnamespace app\index\controller;use think\Controller;use think\Db;use think\Request;class Dels extends Controller{ ???//展示数据 ???public function show(){ ???????$data = Db::table(‘yun‘)->select(); ???????return view("show",[‘data‘=>$data]); ???} ???//批量删除 ???public function del(){ ???????//接收传值 ???????$ids = Request::instance()->param("ids"); ???????//拼接条件 ???????$where[‘id‘] ?= array(‘in‘,$ids); ???????$res = Db::table("yun")->where($where)->delete(); ???????if($res){ ???????????echo 1; ???????}else{ ???????????echo 2; ???????} ???}}
html代码
<!DOCTYPE html><html lang="en"><head> ???<meta charset="UTF-8"> ???<title>展示数据</title></head><body><center> ???<table border="1"> ???????<tr> ???????????<td>选择</td> ???????????<td>ID</td> ???????????<td>姓名</td> ???????????<td>年龄</td> ???????????<td>地址</td> ???????</tr> ???????{volist name="data" id="vo"} ???????<tr class="{$vo.id}"> ???????????<td><input type="checkbox" name="check" value="{$vo.id}"></td> ???????????<td>{$vo.id}</td> ???????????<td>{$vo.name}</td> ???????????<td>{$vo.age}</td> ???????????<td>{$vo.address}</td> ???????</tr> ???????{/volist} ???</table> ???<button id="del">批删</button></center></body></html><script src="/static/js/jquery.js"></script><script> ???$("#del").click(function(){ ???????var arr = []; ???????$("[type=checkbox]:checked").each(function(i){ ???????????arr[i] = $(this).val(); ???????}); ???????var ids = arr.toString(); ???????$.ajax({ ???????????method:"POST", ???????????data:{ ???????????????ids:ids ???????????}, ???????????url:"{:url(‘Dels/del‘)}" ???????}).done(function(data){ ???????????if(data==1){ ???????????????for(var i=0;i<arr.length;i++){ ???????????????????$("."+arr[i]).remove(); ???????????????} ???????????????alert("删除成功"); ???????????}else{ ???????????????alert(‘删除失败‘); ???????????} ???????}); ???});</script>
ajax批删
原文地址:https://www.cnblogs.com/yingyong/p/9934527.html