ajax批删

ajax批量删除数据，快捷方便，实现无页面刷新。

<?php
namespace 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>

posted on 2018-11-09 13:10 英勇博客阅读(97) 评论(0) 编辑收藏举报