thinkPHP分页显示数据

落日映苍穹つ 2022-06-10 02:51 291阅读 0赞

第一种：利用Page类和limit方法

1.  `//实例化User对象`
2.  `$User=M('User');`
3.  `//查询满足要求的总记录数`
4.  `$count=$User->where('status=1')->count();`
5.  `//实例化分页类，传入总记录数和每页显示的记录数(25)`
6.  `$Page=new \Think\Page($count,25);`
7.  `//分页显示输出`
8.  `$show=$Page->show();`
9.  `//进行分页数据查询，注意limit方法的参数要使用Page类的属性`
10. `$list=$User->where('status=1')->order('create_time')->limit($Page->firstRow.','.$Page->listRows)->select();`
11. ``
12. `//赋值数据集`
13. `$this->assign('list',$list);`
14. `//赋值分页输出`
15. `$this->assign('page',$show);`
16. `//输出模板`
17. `$this->display();`

### 第二种：分页类和page方法的实现 ###

1.  `//实例化User对象`
2.  `$User=M('User');`
3.  `//进行分页数据查询，注意page方法的参数的前面部分是当前的页数使用$_GET[p]获取`
4.  `$list=$User->where('status=1')->order('create_time')->page($_GET['p'].',25')->select();`
5.  `//赋值数据集`
6.  `$this->assign('list',$list);`
7.  `//查询满足要求的总记录数`
8.  `$count=$User->where('status=1')->count();`
9.  `//实例化分页类，传入总记录数和每页显示的记录数`
10. `$Page=new \Think\Page($count,25);`
11. `//分页显示输出`
12. `$show=$Page->show();`
13. `//赋值分页输出`
14. `$this->assign('page',$show);`
15. `//输出模板`
16. `$this->display();`

第三种：

$classify=M("demand\_classify")->where("topplay=1")->select();

$classifyIDs=array();  
foreach ($classify as $k => $v) \{  
$classifyIDs\[\]=$v\['id'\];  
\}  
  
  
$map\['l.demand\_classify'\]=array("IN",$classifyIDs); //点播分类允许显示

$lists=M("users\_liverecord l")  
  
\->field("u.user\_nicename,u.avatar,u.id,a.title as course\_name,a.content,l.\*")  
\->join("left join \{$prefix\}users u on u.id=l.uid")  
\->join("left join \{$prefix\}apply\_records a on l.applyid=a.id")  
\->where($map)  
\->where("l.isdisplay=1 and isdel=0 and l.type=0")  
\->order("l.hits desc,l.endtime desc")  
\->select();

foreach($lists as $k=>$v)\{  
$lists\[$k\]\['title1'\]=$lists\[$k\]\['title'\];  
if(mb\_strlen($v\['course\_name'\],"utf-8")>11)\{  
$lists\[$k\]\['course\_name'\]=mb\_substr($v\['course\_name'\],0,11,"utf-8")."…";  
\}  
\}

$vodio=M("users\_liverecord")->where("type=1 and isdisplay=1")->select();

foreach($vodio as $ko=>$vo)\{

$userinfo=M("users")->field("user\_nicename,avatar")->where("id='\{$vo\['uid'\]\}'")->find();  
$vodio\[$ko\]\['user\_nicename'\]=$userinfo\['user\_nicename'\];  
$vodio\[$ko\]\['avatar'\]=$userinfo\['avatar'\];  
$vodio\[$ko\]\['course\_name'\]=$vo\['video\_name'\];  
$vodio\[$ko\]\['content'\]=$vo\['video\_conn'\];  
\}  
  
  
$hebing= array\_merge($vodio, $lists);//将数组合并

$count=count($hebing);  //获取数据总数  
 $pagesize=20; //分页显示数量  
 $Page= new \\Page2($count,$pagesize); //实例化分页类  
 $show= $Page->show(); //分页显示输出  
  
$hebing=array\_slice($hebing,$Page->firstRow,$Page->listRows); //将数据按照分页数分割获取  
              
$this->assign("live",$hebing);  
$this->assign('page',$show);