thinkphp實現資料分頁

標籤：

方法一：

 

 1 public function show_cate(){ 2          3         $category_name = array( 4             ‘1‘ => ‘政法綜治前沿‘, 5             ‘2‘ => ‘政策法規‘, 6             ‘3‘ => ‘平安建設‘, 7             ‘4‘ => ‘通知公告‘, 8             ‘5‘ => ‘理論研討‘, 9             ‘6‘ => ‘本地動態‘,10             ‘7‘ => ‘隊伍建設‘,11             );12         $category_id = I(‘get.category_id‘);13         $model = M(‘zx_article‘);14                                  //計算要顯示的總資料條數15         $count = $model->where(‘category_id =‘.$category_id)->order(‘article_id desc‘)->count();16                                 //執行個體化Page類，傳入總條數和每頁要顯示的條數17         $page = new \Think\Page($count,2);18                               //使用limit函數指定查詢和操作的數量19         $data = $model->where(‘category_id =‘.$category_id)->order(‘article_id desc‘)->limit($page->firstRow.‘,‘.$page->listRows)->select();20                                 //傳資料給模板21         $this->assign(‘data‘,$data);22                                //調用Page類的show()函數
23         $this->assign(‘page‘,$page->show());24         $this->assign(‘name‘,$category_name[$category_id]);25         $this->display();26     }

 

thinkphp實現資料分頁