PHP分页显示类

最新推荐文章于 2019-06-06 16:31:36 发布

tianpeiwen

最新推荐文章于 2019-06-06 16:31:36 发布

阅读量415

点赞数

本文链接：https://blog.csdn.net/tianpeiwen/article/details/8154800

版权

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<?php
class page{
private $dbadd; //数据库地址
private $dbuser; //数据库用户名
private $dbpwd; //数据库密码
private $dbname; //数据库名
private $tablename; //数据表名
private $num; //每页显示的行数
private $total; //表中数据总数
private $totalpage; //总页数
private $page; //当前页数
private $limit; //查询数
private $arrs; //查询后返回的数据
private $col; //总列数
private $nostart; //当前页开始的记录数
private $noend; //当前页结束的记录数
private $head; //首页
private $end; //尾页
private $last; //上一页
private $nexts; //下一页

function __construct($dbadd, $dbuser, $dbpwd, $dbname, $tablename, $num){
      $this->dbadd=$dbadd;
      $this->dbuser=$dbuser;
      $this->dbpwd=$dbpwd;
      $this->dbname=$dbname;
      $this->tablename=$tablename;
      $this->num=$num;
      $this->total=$this->gettotal();   //得到总条数
     $this->totalpage=ceil($this->total/$this->num); //获取总页数
      $this->page=$this->getpage(); //得到当前页数
     $this->limit=$this->setlimit(); //得到查询的数据
     $this->arrs=$this->getarrs(); //得到查询的结果
      $this->col=$this->getcol(); //获取总列数
        $this->nostart=($this->page-1)*$num+1;
         $this->noend=$this->page==$this->totalpage ? $this->total : $this->page*$num;
        $this->head=$this->page==1 ? "首页" : "<a href='?page=1'>首页</a>";
        $this->end=$this->page==$this->totalpage ? "尾页" : "<a href='?page={$this->totalpage}'>尾页</a>";
        $this->last=$this->page==1 ? "上一页" : "<a href='?page=".($this->page-1)."'>上一页</a>";
         $this->nexts=$this->page==$this->totalpage ? "下一页" : "<a href='?page=".($this->page+1)."'>下一页</a>";
    }

    private function getcol(){
        $linkss=mysql_connect($this->dbadd, $this->dbuser, $this->dbpwd);
         mysql_select_db($this->dbname, $linkss);
        $result=mysql_query("select * from {$this->tablename}", $linkss);
        $col=mysql_num_fields($result);
         mysql_close($linkss);
       return $col;
    }

     private function getarrs(){ //根据条件再次查询并返回结果
        $sql="select * from {$this->tablename} limit {$this->limit}, {$this->num}";
         $links=mysql_connect($this->dbadd, $this->dbuser, $this->dbpwd);
        mysql_select_db($this->dbname, $links);
         $result=mysql_query($sql, $links);
       echo "<table align='center' border='1'>";
        echo "<caption><h2>学生信息查询结果</h2></caption>";
       echo "<th>学号</th><th>姓名</th><th>性别</th><th>民族</th><th>出生年月</th><th>专业</th><th>系别</th><th>备注</th>";
       while($arr=mysql_fetch_assoc($result)){

       echo "<tr>";
   foreach($arr as $data)
   {echo "<td>".$data."</td>";}
   echo "</tr>";

}
echo "</table>";
         return $data;
         mysql_close($links);
    }

    private function setlimit(){
        return ($this->page-1)*$this->num;
    }

    private function getpage(){
         $page=isset($_GET["page"]) ? $_GET["page"] : 1;
         $page=$page>$this->totalpage ? $this->totalpage : $page;
         $page=$page<1 ? 1 : $page;
        return $page;
    }

    private function gettotal(){    //得到表中所有记录的总数
        $link=mysql_connect($this->dbadd, $this->dbuser, $this->dbpwd);
        mysql_select_db($this->dbname, $link);
        $result=mysql_query("select * from {$this->tablename}", $link);
        $total=mysql_num_rows($result);
        mysql_close($link);
       return $total;
    }

    function __get($args){
        switch($args){
             case "arrs":    //根据条件查询出的结果，是二维数组
                 return $this->arrs;
                break;
            case "totalpage":   //总页数
                return $this->totalpage;
                 break;
            case "col": //总列数
                return $this->col;
                break;
             case "page":    //当前页
                return $this->page;
                break;
             case "nostart": //当前页显示的记录的起始条数
                return $this->nostart;
                break;
            case "noend": //当前页显示的记录的结束条数
                 return $this->noend;
                break;
            case "head":    //首页按钮
                 return $this->head;
                break;
             case "end": //尾页按钮
                return $this->end;
                break;
            case "last": //上一页按钮
               return $this->last;
                 break;
            case "nexts": //下一页按钮
                return $this->nexts;
                 break;
         }
     }
}
?>

</body>
</html>

tianpeiwen

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
PHP分页显示类

无标题文档class page{ private $dbadd; //数据库地址 private $dbuser; //数据库用户名 private $dbpwd; //数据库密码 private $dbname; //数据库名 private $tablename; //数据表名 private $num; //每页显示的行数 pr
复制链接

扫一扫