php实现简单的分页功能

大家在浏览网页的时候，都会看到每篇文章都会会显示“上一页”“下一页”。

下面跟大家分享一下如何用php实现简单的分页功能。

首先，先创建一个mysql表：
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
然后在里面插入数据：
-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('1', '张三');
INSERT INTO `test` VALUES ('2', '李四');
INSERT INTO `test` VALUES ('3', '王五');
INSERT INTO `test` VALUES ('4', '赵六');
INSERT INTO `test` VALUES ('5', '阿萨达');
INSERT INTO `test` VALUES ('6', '回火');
INSERT INTO `test` VALUES ('7', 'adada');
然后新建一个php文件，连接数据库：
header("content-type:text/html;charset=UTF-8");//防止页面乱码$link = mysql_connect("localhost","root","") or die("数据库连接失败"); $result = mysql_select_db("test",$link);
mysql_query("SET NAMES 'utf8'");//设置数据库连接编码
然后调取数据，并且计算出该表里面总共有多少条数据：
function selectdata(){
$sql = "SELECT name FROM `test` ORDER BY id desc";
$arr = array();
$result = mysql_query($sql);
while ($array = mysql_fetch_row($result)) {
$arr[] = $array;
}
return $arr;
}
function selectdatabypages($limit1,$limit2){
$sql = "SELECT name FROM `test` ORDER BY id desc LIMIT
$limit1,$limit2";
$arr = array();
$result = mysql_query($sql);
while ($array = mysql_fetch_row($result)) {
$arr[] = $array;
}
return $arr;
}
function countdata(){
$sql = "SELECT name FROM `test` ORDER BY id desc"; $query = mysql_query($sql);
$num = mysql_num_rows($query);
return $num;
}
最后，来制作页码：
$page = @$_GET["page"];
if ($page == null) {
$page = 1;
}
$each_disNums=5;//每次显示的条数
$pageNums = ceil($num / $each_disNums);//总页数
$startPage=($page-1)*$each_disNums;//开始每一页的第一条记录echo "<a href=index.php?page=".($page-1).">上一页</a>";
echo "<a href=index.php?page=".($page+1).">下一页</a>";
echo '共有' . $num . '条数据' . '共' . $pageNums . '页';
下面是完整的代码：
<?php
header("content-type:text/html;charset=UTF-8");
$link = mysql_connect("localhost","root","") or die("数据库连接失败"); $result = mysql_select_db("test",$link);
mysql_query("SET NAMES 'utf8'");
$data = selectdata();
$num = countdata();
$page = @$_GET["page"];
if ($page == null) {
$page = 1;# code...
}
$each_disNums=5;//每次显示的条数
$pageNums = ceil($num / $each_disNums);//总页数
$startPage=($page-1)*$each_disNums;//开始每一页的第一条记录$arr = selectdatabypages($startPage,$each_disNums);
foreach ($arr as $key => $value) {
$name = $value[0];
echo "姓名：" . $name ."<br>";
}
echo "<a href=index.php?page=".($page-1).">上一页</a>"; echo "<a href=index.php?page=".($page+1).">下一页</a>"; echo '共有' . $num . '条数据' . '共' . $pageNums . '页'; function selectdata(){
$sql = "SELECT name FROM `test` ORDER BY id desc"; $arr = array();
$result = mysql_query($sql);
while ($array = mysql_fetch_row($result)) {
$arr[] = $array;
}
return $arr;
}
function selectdatabypages($limit1,$limit2){
$sql = "SELECT name FROM `test` ORDER BY id desc LIMIT $limit1,$limit2";
$arr = array();
$result = mysql_query($sql);
while ($array = mysql_fetch_row($result)) {
$arr[] = $array;
}
return $arr;
}
function countdata(){
$sql = "SELECT name FROM `test` ORDER BY id desc"; $query = mysql_query($sql);
$num = mysql_num_rows($query);
return $num;
}
?>。