php query paging code

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 thinkphp framework, for your reference, the specific content is as follows

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

HTML code

The first step is to introduce the plug-in

The second step is to add

   

 

 

  
ID
  
发布时间
  
发布IP
  
公告内容
 
 
 

  

   
{$vo.id}
   
{$vo.create_time}
   
{$vo.create_ip}
   
{$vo.notice_content}
   
  
 

The third step is JS

PHP code

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

Effect

The above is the entire content of this article. I hope it will be helpful to everyone’s study and I hope you will support me a lot. Script House.

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