Home  >  Article  >  Backend Development  >  php开发分页实现代码第1/3页_PHP教程

php开发分页实现代码第1/3页_PHP教程

WBOY
WBOYOriginal
2016-07-21 15:19:16919browse

项目结构:

运行效果:

conn.php
复制代码 代码如下:

$conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误");
mysql_select_db("form", $conn);
mysql_query("set names 'GBK'"); //使用GBK中文编码;
//替换空格,回车键
function htmtocode($content) {
$content = str_replace("\n", "
", str_replace(" ", " ", $content));
return $content;
}
?>

page.php
复制代码 代码如下:

1 2
3 function _PAGEFT($totle, $displaypg = 20, $url = '') {
4
5 global $page, $firstcount, $pagenav, $_SERVER;
6
7 $GLOBALS["displaypg"] = $displaypg;
8
9 if (!$page)
$page = 1;
if (!$url) {
$url = $_SERVER["REQUEST_URI"];
}
//URL分析:
$parse_url = parse_url($url);
$url_query = $parse_url["query"]; //单独取出URL的查询字串
if ($url_query) {
$url_query = ereg_replace("(^|&)page=$page", "", $url_query);
$url = str_replace($parse_url["query"], $url_query, $url);
if ($url_query)
$url .= "&page";
else
$url .= "page";
} else {
$url .= "?page";
}
$lastpg = ceil($totle / $displaypg); //最后页,也是总页数
$page = min($lastpg, $page);
$prepg = $page -1; //上一页
$nextpg = ($page == $lastpg ? 0 : $page +1); //下一页
$firstcount = ($page -1) * $displaypg;
//开始分页导航条代码:
$pagenav = "显示第 " . ($totle ? ($firstcount +1) : 0) . "-" . min($firstcount + $displaypg, $totle) . " 条记录,共 $totle 条记录";
//如果只有一页则跳出函数:
if ($lastpg return false;
$pagenav .= " 首页 ";
if ($prepg)
$pagenav .= " 前页 ";
else
$pagenav .= " 前页 ";
if ($nextpg)
$pagenav .= " 后页 ";
else
$pagenav .= " 后页 ";
$pagenav .= " 尾页 ";
//下拉跳转列表,循环列出所有页码:
$pagenav .= " 到第 页,共 $lastpg 页";
}
include("conn.php");
$result=mysql_query("SELECT * FROM `test`");
$total=mysql_num_rows($result);
//调用pageft(),每页显示10条信息(使用默认的20时,可以省略此参数),使用本页URL(默认,所以省略掉)。
_PAGEFT($total,5);
echo $pagenav;
$result=mysql_query("SELECT * FROM `test` limit $firstcount,$displaypg ");
while($row=mysql_fetch_array($result)){
echo "
".$row[name]." | ".$row[sex];
}
?>

list.php
[code]
include("conn.php");
$pagesize=5;
$url=$_SERVER["REQUEST_URI"];
$url=parse_url($url);
$url=$url[path];
$numq=mysql_query("SELECT * FROM `test`");
$num = mysql_num_rows($numq);
if($_GET

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/325347.htmlTechArticle项目结构: 运行效果: conn.php 复制代码 代码如下: ?php $conn = @ mysql_connect("localhost", "root", "") or die("数据库链接错误"); mysql_select_db("form", $...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn