Statistics ranking and paging display functions in thinkPHP

This article mainly introduces the statistical ranking and paging display functions of thinkPHP, and analyzes the operation skills related to thinkPHP database query and result paging display in the form of examples. Friends in need can refer to the following

This article analyzes thinkPHP with examples Statistical ranking and paging display functions. Share it with everyone for your reference, the details are as follows:

1. Paging parameters

2. Paging object

It can be for a real data table
It can also be for a statistically calculated data table, or a virtual table
Because LIMIT is executed last, even if you perform group operations, even if you Make a subquery

html

    
 
 月排行 总排行 
 
 
 我的商户数:{sh:$my_user_count} 当前排名: {sh:$my_rank} 
 
  
 
 
 
 #
 
姓名
 
商户数
 
 
 
 
 
     {sh:$vo.rank}  
 
{sh:$vo.name}
 
{sh:$vo.usercount}
 
  
 
 
 {sh:$page} 
 
  

php

// 排行榜 public function ranklist(){ $type = $this->_get('type','trim'); $this->assign('type',$type); $opener_id = $this->opener_id; if($type == 0){ // 上月排行 $arrLastMonth = $this->getLastMonthStartEndDay(); $lastStartDay = $arrLastMonth['lastStartDay']; $lastEndDay = $arrLastMonth['lastEndDay'].' 23:59:59'; $b_time = strtotime($lastStartDay); $e_time = strtotime($lastEndDay); $where['b.addtime'] = array(array('gt',$b_time),array('lt',$e_time),'and'); } $where['a.status'] = array('eq','1'); M()->query('SET @rank =0;'); $subQuery = M()->table('sh_opener a')->join('sh_user b on a.id = b.opener_id')->where($where)->group('a.id')->order('usercount desc')->field('a.id,count(b.id) as usercount,a.name')->select(false); $all = M()->table(''.$subQuery.' a')->getField('a.id,a.usercount,a.name,(@rank:=IFNULL(@rank,0)+1) as rank'); $count = count($all); $Page = new Page($count, 10); $list = M()->table('sh_opener a')->join('sh_user b on a.id = b.opener_id')->where($where)->group('a.id')->order('usercount desc')->limit($Page->firstRow.','.$Page->listRows)->field('count(b.id) as usercount,a.name,a.id')->select(); foreach ($list as $k => $v) { $list[$k]['rank'] = $k + 1 + $Page->firstRow; } // 我的商户 $my_user_count = $all[$opener_id]['usercount']?$all[$opener_id]['usercount']:0; $my_rank = $all[$opener_id]['rank']?$all[$opener_id]['rank']:'-'; $this->assign('my_user_count',$my_user_count); $this->assign('my_rank',$my_rank); $this->assign('page',$Page->show()); $this->assign('list', $list); $this->display(); } // 获取上一月开始与结束日期 private function getLastMonthStartEndDay(){ $thismonth = date('m'); $thisyear = date('Y'); if ($thismonth == 1) { $lastmonth = 12; $lastyear = $thisyear - 1; } else { $lastmonth = $thismonth - 1; $lastyear = $thisyear; } $lastStartDay = $lastyear . '-' . $lastmonth . '-1'; $lastEndDay = $lastyear . '-' . $lastmonth . '-' . date('t', strtotime($lastStartDay)); //t 给定月份所应有的天数,28到31 return array('lastStartDay'=>$lastStartDay,'lastEndDay'=>$lastEndDay); }

here It is implemented using thinkphp's paging class.

Case Effect

The above is the entire content of this article. I hope it will be helpful to everyone’s study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

thinkphp implements paging display function

Statistics of ThinkPHP’s total donations are for entertainment only, not too much Realistic

The above is the detailed content of Statistics ranking and paging display functions in thinkPHP. For more information, please follow other related articles on the PHP Chinese website!