How to implement background paging using Layui tables

How to use Layui tables to implement background paging:

<table class="layui-table" lay-data="{width: 892, height:332,url:&#39;&#39;, page:true, id:&#39;idTest&#39;}" lay-filter="demo">
  <thead>
    <tr>
      <th lay-data="{type:&#39;checkbox&#39;, fixed: &#39;left&#39;}"></th>
      <th lay-data="{field:&#39;id&#39;, width:80, sort: true, fixed: true}">id</th>
      <th lay-data="{field:&#39;menubarid&#39;, width:80}">菜单id</th>
      <th lay-data="{field:&#39;name&#39;, width:80, sort: true}">菜名</th>
      <th lay-data="{field:&#39;price&#39;, width:80}">价格</th>
      <th lay-data="{field:&#39;status&#39;, width:160}">状态</th>
      <th lay-data="{fixed: &#39;right&#39;, width:178, align:&#39;center&#39;, toolbar: &#39;#barDemo&#39;}"></th>
    </tr>
  </thead>
</table>

Use layui to automatically render and generate tables. By default, the parameters page and limit are obtained from the front end in get mode

int page = Integer.parseInt(request.getParameter("page"));
int limit = Integer.parseInt(request.getParameter("limit"));	
int count = menuDao.searchcount();             // 查找数据条数
int page_temp = page;
int limit_temp = limit;
if (count < page * limit) {
	limit = count - (page - 1) * limit;
}
page = (page_temp - 1) * limit_temp;

I am using mysql. The first one is to search for the number of rows, and the second one is the paging query statement. Just pass page and limit into two question marks respectively.

 select  count(*) from menu 
select * from menu limit ?,?

Finally, before converting to json, change the value of count to the number of rows obtained from the sql query.

String layjson ="{\"code\":0,\"msg\":\"\",\"count\":"+getcount()+",\"data\":["+data+"]}";

This article is reproduced from: https://blog.csdn.net/qq_42290276/article/details/80508332

For more layui knowledge, please pay attention to the layui usage tutorial column.

The above is the detailed content of How to implement background paging using Layui tables. For more information, please follow other related articles on the PHP Chinese website!