• php页面分页设计


      当前页数 页导航
    总页数1-11 * 输出所有
    总页数>11 <7 输出前11条
    总页数>11 >总数-6 后11条
    总页数>11 其他 前五条,后五条
        /**
         * 选择所有发号信息,联合查询
         * @param array $where
         */
        public function selectAllFaohao($where=array(),$p=1)
        {
            $nums=2;//每页显示数量
            $count=$this->where($where)->count();
            $page['firstpage']=1;
            $page['totalpage']=floor(($count-1)/$nums)+1;
            if(!@is_numeric($p)||@$p<1||$p>$page['totalpage']){$p=1;}
            $page['currentpage']=intval($p);
            $page['totalnum']=$count;
            $page['prevpage']=($p==1)?1:$p-1;
            $page['nextpage']=($p==$page['totalpage'])?$page['totalpage']:$p+1;
            if($page['totalpage']<11)
            {
                $page['navigationstart']=1;
                $page['navigationend']=$page['totalpage'];
            }
            else
            {
                if($page['currentpage']<=6)
                {
                    $page['navigationstart']=1;
                    $page['navigationend']=11;                
                }
                elseif($page['currentpage']>=$page['totalpage']-6)
                {
                    $page['navigationstart']=$page['totalpage']-10;
                    $page['navigationend']=$page['totalpage'];                
                }
                else
                {
                    $page['navigationstart']=$page['currentpage']-5;
                    $page['navigationend']=$page['currentpage']+5;                
                }
            }
            $field="tp_fahao.id ,tp_fahao.game_id ,tp_fahao.type ,tp_fahao.shuoming ,tp_fahao.insert_time ,tp_fahao.user_id ,tp_fahao.common_lb ,tp_gamename.game_name ,tp_gamename.game_gw ,tp_gamename.game_ope ,tp_user.username,tp_user.type as utype";
            $list=$this->where($where)->field($field)->join(' tp_gamename ON tp_fahao.game_id = tp_gamename.id')->join('tp_user ON dbo.tp_user.id=tp_fahao.user_id')->page($p,$nums)->select();
            foreach($list as $key=>$value)
            {
                $list[$key]['insert_time']=date('Y-m-d H:i:s',$value['insert_time']);
            }
            $result['list']=($list==null||$list===false||empty($list))?array():$list;
            $result['page']=$page;
            $result['error']=0;
            return $result;
        }
    我的博客:www.shishangguan.net

     我的博客:www.while0.com

  • 相关阅读:
    Ubuntu1804命令行安装vmtool
    Pyspider的基本使用
    HDU-4507
    CF264BGood Sequences
    CF285D.D. Permutation Sum
    我罗斯方块最终篇(Player类、Game类)
    ES学习(三)--查询
    ES学习(二)--增删改查
    GIT学习
    ES学习(一)--核心概念,NRT、索引、分片、副本
  • 原文地址:https://www.cnblogs.com/yamadie/p/2853412.html
Copyright © 2020-2023  润新知