PHP code example to implement query paging-PHP Tutorial-php.cn

PHP code example to implement query paging

怪我咯

Release： 2023-03-10 13:06:02

Original

1686 people have browsed it

This article mainly introduces the implementation code of PHP query paging in detail. It has certain reference value. Interested friends can refer to it.

The example in this article shares with everyone the PHP query paging code. The specific code, the back-end is based on the thinkphp framework, for your reference, the specific content is as follows

The front-end requires the dataTables plug-in: Portal download address

HTML code

First The first step is to introduce the plug-in

<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css" href="http://cdn.datatables.net/1.10.15/css/jquery.dataTables.css" rel="external nofollow" >
<!-- jQuery -->
<script type="text/javascript" charset="utf8" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>
<!-- DataTables -->
<script type="text/javascript" charset="utf8" src="http://cdn.datatables.net/1.10.15/js/jquery.dataTables.js"></script>

Copy after login

The second step is to add

<table id="table_id_example" class="display">
 <thead>
 <tr>
  <th>ID</th>
  <th>发布时间</th>
  <th>发布IP</th>
  <th>公告内容</th>
 </tr>
 </thead>
 <tbody>
  <volist name="notice" id="vo">
   <tr>
   <td>{$vo.id}</td>
   <td>{$vo.create_time}</td>
   <td>{$vo.create_ip}</td>
   <td>{$vo.notice_content}</td>
   </tr>
  </volist>
 </tbody>
</table>

Copy after login

Step ThreeJS

 <script>
 $(document).ready( function () {
  $(&#39;#table_id_example&#39;).DataTable();
 } );
 </script>

Copy after login

PHP Code

 public function gonggaochakan(){
 /* 公告查看
  */
 $dbNotice = M(&#39;notice&#39;);//实例化dbNotice对象
 $count  = $dbNotice->count();// 查询满足要求的总记录数
 $Page  = new \Think\Page($count,$count);// 实例化分页类 传入总记录数和每页显示的记录数(全部记录)
 $data = $dbNotice->order(&#39;create_time&#39;)->limit($Page->firstRow.&#39;,&#39;.$Page->listRows)->select();//获得所有记录
 $this->assign(&#39;notice&#39;,$data);//传给模板
 $this->show();
}

Copy after login

Effect

The above is the detailed content of PHP code example to implement query paging. For more information, please follow other related articles on the PHP Chinese website!