2.已经制作使用easyui Datagrid 的index.js文件
并将Datagrid的URL设置为：
url:'./read.html',
3.在index.html模板中调用index.js；
4.在Index.html中修改页数，查询结果，不随页数变动；
---------------------------------------------------------
IndexController内容：
---------------------------------------------------------
<?php
namespace Backend\Controller;
use Think\Controller;
class TestController extends ba
public function index(){
$this->display();
}
public function read(){
$menus = D('Menus');
$info = $menus
->field('id,menu_date,goods_name,goods_introduce,goods_big_img,cook_name,foodtype_name')
->join('left join sw_goods ON menu_goods_id=sw_goods.goods_id')
->join('left join sw_cook ON menu_cook_id=sw_cook.cook_id')
->join('left join sw_foodtype ON menu_foodtype_id=sw_foodtype.foodtype_id')
->select();
$total=$menus
->field('id,menu_date,goods_name,goods_introduce,goods_big_img,cook_name,foodtype_name')
->join('left join sw_goods ON menu_goods_id=sw_goods.goods_id')
->join('left join sw_cook ON menu_cook_id=sw_cook.cook_id')
->join('left join sw_foodtype ON menu_foodtype_id=sw_foodtype.foodtype_id')
->count();
$json='{"total":'.$total.',"rows":'.json_encode($info).'}';
//重要，easyui的标准数据格式，数据总数和数据内容在同一个json中
echo $json;
}
}
---------------------------------------------------------
index.js内容：
---------------------------------------------------------
$(function(){
$('#dg').datagrid({
url:'./read.html',
width : 400,
ti
striped :true,
showFooter :true,
pagination :true,
pageSize :3,
pageList :[3,6,9,13],
iconCls : 'icon-search',
columns : [[
{field :'id', ti
{field :'goods_name', ti
{field :'menu_date', ti
{field :'goods_introduce', ti
{field :'cook_name', ti
{field :'foodtype_name', ti
]]
});
});
---------------------------------------------------------
index.html内容：
---------------------------------------------------------
<!DOCTYPE html>
<html>
<head>
<ti
<me
<sc
<sc
<sc
<sc
<li
<li
</head>
<body>
<table id="dg"></table>
</body>
</html>
最佳答案
