#tp5 查询数据并转换为json格式
public function indexJson($page,$limit){
$tol = ($page-1)*$limit; #limit(0,5)
$data = Db::name('数据表')
->field('字段')
->limit($tol,$limit)
->select();
$count = Db::name('主句表')->count('字段');
$data = json_decode(json_encode($data));
$res['code'] = 0;
$res['msg'] = '';
$res['count'] = $count;
$res['data'] = $data;
return json($res);
}
页面
layui.config({
base: '../../layuiadmin/' //静态资源所在路径
}).extend({
index: 'lib/index' //主入口模块
}).use(['index', 'table'], function(){
var admin = layui.admin
,table = layui.table;
table.render({
elem: '#test-table-page'
,url: 'indexJson'
,cols: [
[
{field:'id', title: '编号',align:'center'}
,{field:'nickname',title: '用户',align:'center'}
,{field:'createtime', title: '时间',align:'center'}
,{field:'action', title: '行为',align:'center'}
,{field:'ip', title: 'ip地址',align:'center'}
]
]
,page: true
});
});
Q.E.D.