layui-table-ajax-php显示数据

public function cp_list()
{

    if ($this->request->isAjax()) {
        $map = [];
        $keyword = $this->request->param('keyword');
        $page = $this->request->param('page/d', 1);
        $limit = $this->request->param('limit/d', 20);
        if ($keyword) {
             $map["name"] = ['like', '%'.$keyword.'%'];
        }
        $data['data'] = model('products')->alias('a')
            ->field('a.*,b.nick as store')
            ->join('dianpu b','a.sid=b.id','left')
            ->where($map)->page($page)->limit($limit)->order("id desc")->select();
        //echo db('products')->getLastSql();
        $data['count'] = model('products')->where($map)->count('id');
        $data['code'] = 0;
        return json($data);
    }

    return $this->fetch();
}




    

        

            

                搜索
                

                    
                
            
        
    
    

         添加
         启用
         禁用
         删除

    
    


    

        
        
        
        
    

{include file="block/layui" /}