layui分页table表格使用

html:

<table id="demo" lay-filter="test"></table>

script:

<script>
    layui.use('table', function () {
        var table = layui.table;
        
        table.render({
            elem: '#demo'
            , height: 380
            , url: '../php/main.php?type=rizhitb' //数据接口,请求的php页面路径
            , page: true //开启分页
            , cols: [[ //表头
                { field: 'account', title: '账号',  150, sort: true, fixed: 'left' }
                , { field: 'name', title: '用户名',  180 }
                , { field: 'date', title: '操作时间',  250, sort: true }
                , { field: 'content', title: '操作内容' }
            ]]
        });

    });
</script>

php：

case 'rizhitb':
        $sql = "select count(*) from log";
        $res = $db->query($sql);
        $con = $res->fetch_row();
        
        $page = $_GET["page"];
        $limit = $_GET["limit"];
        $lit = ($page-1)*$limit.",".$limit;//数据分页

        $sql = "select * from log order by date desc limit ".$lit;
        $res = $db->query($sql);
    
        $rows = array();
        while($row=$res->fetch_assoc()){
            $rows[] = $row;
        }
        $arr = array(
            "code"=> 0,
            "msg"=> "",
            "count"=> $con[0],
            "data"=>$rows
        );
        echo json_encode($arr);

        break;