PHP paging a simple implementation of the simplest PHP page code

PHP paging code in a variety of program development is necessary to use, in the development of the Web site is a necessary choice.

To write the paging code, first you have to understand the SQL query statement: SELECT * from goods limit 2, 7. PHP Paging code core is to expand around this statement, SQL statement Description: Query goods data table from the 2nd data start to remove 7 data. In the pagination code, 7 indicates how many items are displayed per page, 2 uses the formula to calculate the number of page turns, and by passing in different parameters to replace the value "2", you can filter out different data.

index.php:

1234567891011121314151617181920212223242526

include‘conn.php‘;　　//引入数据库操作类$conn=newconn();　　//实例化数据库操作类$total=$conn->getOne(‘select count(*) as total from goods‘);$total=$total[‘total‘]; //goods表数据总数据条数$num=6; //每页显示条数$totalpage=ceil($total/$num);   //计算页数if(isset($_GET[‘page‘]) && $_GET[‘page‘]<=$totalpage){//这里做了一个判断，若get到数据并且该数据小于总页数情况下才付给当前页参数，否则跳转到第一页    $thispage=$_GET[‘page‘];}else{    $thispage=1;}<br>//注意下面sql语句中红色部分，通过计算来确定从第几条数据开始取出，当前页数减去1后再乘以每页显示数据条数$sql=‘select goods_id,goods_name,shop_price from goods order by goods_id limit ‘.<span style="color: #ff0000;">($thispage-1)*$num</span>.‘,‘.$num.‘‘;$data=$conn->getAll($sql);foreach($dataas$k=>$v){    echo‘<li>‘.$v[‘goods_id‘].‘、‘.$v[‘goods_name‘].‘---￥‘.$v[‘shop_price‘].‘</li>‘;   }<br>//显示分页数字列表for($i=1;$i<=$totalpage;$i++){    echo‘<a href="?page=‘.$i.‘">‘.$i.‘</a> ‘;     }

The code above implements one of the simplest PHP paging effects:

Only realize the click-to-turn digital display different paging data, can be further improved on this basis, as long as the basic principles of understanding, follow-up work is relatively easy to develop.

conn.php Code:

1234567891011121314151617181920212223242526272829303132333435

/**连接数据库 进行相关查询操作*/classconn{     publicfunction__construct(){        include_once(‘config.php‘);        try{               $this->pdo = newPDO(‘mysql:host=localhost;dbname=test‘, ‘root‘, ‘123456‘);            $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);            $this->pdo->exec(‘set names utf8‘);                    }catch(PDOException $e){            echo‘数据库连接失败:‘.$e->getMessage();            exit();        }    }        //获取一行数据    public functiongetOne($sql){        $rs=$this->pdo->query($sql)->fetch(PDO::FETCH_ASSOC);                return$rs;    }        //获取多行数据结果    publicfunctiongetAll($sql){        $rs=$this->pdo->query($sql)->fetchall(PDO::FETCH_ASSOC);                return$rs;    }}

conn.php function is to complete the database connection, and implementation of data extraction operation method, here I use PDO, here can be used to organize code according to people.

config.php:

12345678

/**配置数据库信息*/$cfg_dbhost=‘localhost‘;$cfg_dbname=‘test‘;$cfg_dbuser=‘root‘;$cfg_dbpw=‘123456‘;

　　

This example is only to illustrate the underlying paging principle, and there are many modifications to the actual use.

PHP paging a simple implementation of the simplest PHP page code