2023年6月21日发(作者：)
大家在浏览网页的时候，都会看到每篇文章都会会显示“上一页”“下一页”。下面跟大家分享一下如何用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 "上一页";
echo "下一页";
echo '共有' . $num . '条数据' . '共' . $pageNums . '页';
下面是完整的代码：
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;#
}
$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 ."
";
}
echo "上一页";
echo "下一页";
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;
}
?>
2023年6月21日发(作者：)
大家在浏览网页的时候，都会看到每篇文章都会会显示“上一页”“下一页”。下面跟大家分享一下如何用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 "上一页";
echo "下一页";
echo '共有' . $num . '条数据' . '共' . $pageNums . '页';
下面是完整的代码：
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;#
}
$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 ."
";
}
echo "上一页";
echo "下一页";
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;
}
?>
发布评论