用PHP生成html分页列表的代码
作者:bea
<?php $db=mysql_connect("127.0.0.1","root","*******")ordie("cant'tconnecthost"); $re=mysql_select_db("t",$db)ordie("can'topendatabase"); $sql="Select*FROMnews"; $res=mysql_query($sql); $row=mysql_num_rows($res); $pagesize=2;//分页 行数 if($r
<?php
$db = mysql_connect("127.0.0.1","root","*******") or die("cant't connect host");
$re = mysql_select_db("t",$db)or die ("can't open database");
$sql = "Select * FROM news";
$res = mysql_query($sql);
$row = mysql_num_rows($res);
$pagesize = 2; //分页
行数
if($row<$pagesize) $pages = 1;
if($row%$pagesize){
$pages = intval($row/$pagesize)+1;
}else{
$pages = intval($row/$pagesize);
}
for($i=1;$i<=$pages;$i++){
$page_turn="";
if($i==1){
$indexpath="index.html";
$page_turn.="First | Front";
}else{
$indexpath="index_".$i.".html";
$page_turn.="<a href='index.html'>First</a> | <a href='index_".($i-1).".html'>Front</a>";
}
if($i==$pages){
$page_turn.=' | Behind | Last';
}else{
$page_turn.=" | <a href='index_".($i+1).".html'>Behind</a> | <a href='index_".$pages.".html'>Last</a>";
}
$search = $sql." LIMIT ".($i-1)*$pagesize .", $pagesize";
$result = mysql_query($search);
$rows = mysql_num_rows($result);
$j=1;
$list="";
while($j<=$rows){
$doc = mysql_fetch_array($result);
$id = $doc['0'];
$title = $doc['1'];
$path = $doc['3'];
$list .="<a href='".$id.".html'>".$title."</a><br>";
$j+=1;
}
$list.="<br><br>".$page_turn;
$fp = fopen("html/list.html","r");
$str = fread($fp,filesize("html/list.html"));
$str = str_replace("{content}",$list,$str);
fclose($fp);
$handle = fopen($path."/".$indexpath,"w");
fwrite($handle,$str);
fclose($handle);
}
copy($path."/index.html",$path."/index_1.html");
?>
有用 | 无用
$db = mysql_connect("127.0.0.1","root","*******") or die("cant't connect host");
$re = mysql_select_db("t",$db)or die ("can't open database");
$sql = "Select * FROM news";
$res = mysql_query($sql);
$row = mysql_num_rows($res);
$pagesize = 2; //分页
行数
if($row<$pagesize) $pages = 1;
if($row%$pagesize){
$pages = intval($row/$pagesize)+1;
}else{
$pages = intval($row/$pagesize);
}
for($i=1;$i<=$pages;$i++){
$page_turn="";
if($i==1){
$indexpath="index.html";
$page_turn.="First | Front";
}else{
$indexpath="index_".$i.".html";
$page_turn.="<a href='index.html'>First</a> | <a href='index_".($i-1).".html'>Front</a>";
}
if($i==$pages){
$page_turn.=' | Behind | Last';
}else{
$page_turn.=" | <a href='index_".($i+1).".html'>Behind</a> | <a href='index_".$pages.".html'>Last</a>";
}
$search = $sql." LIMIT ".($i-1)*$pagesize .", $pagesize";
$result = mysql_query($search);
$rows = mysql_num_rows($result);
$j=1;
$list="";
while($j<=$rows){
$doc = mysql_fetch_array($result);
$id = $doc['0'];
$title = $doc['1'];
$path = $doc['3'];
$list .="<a href='".$id.".html'>".$title."</a><br>";
$j+=1;
}
$list.="<br><br>".$page_turn;
$fp = fopen("html/list.html","r");
$str = fread($fp,filesize("html/list.html"));
$str = str_replace("{content}",$list,$str);
fclose($fp);
$handle = fopen($path."/".$indexpath,"w");
fwrite($handle,$str);
fclose($handle);
}
copy($path."/index.html",$path."/index_1.html");
?>
有用 | 无用
猜你喜欢
您可能感兴趣的文章:
- 隐藏你的.php文件的实现方法
- 生成静态页面的php函数,php爱好者站推荐
- php分页示例代码
- 简单介绍下 PHP5 中引入的 MYSQLI的用途
- IIS6的PHP最佳配置方法
- php中的实现trim函数代码
- php中判断一个字符串包含另一个字符串的方法
- php之字符串变相相减的代码
- PHP入门速成教程
- phpMyAdmin 安装教程全攻略
- PHP5中的this,self和parent关键字详解教程
- Discuz!插件:自动隐藏帖子
- 一篇不错的PHP基础学习笔记
- PHP_MySQL教程-第三天 基本函数
- PHP_MySQL教程-第二天while循环与数据库操作
- PHP_MySQL教程-第一天
- PHP 中dirname(_file_)讲解
- PHP session常见问题集锦及解决办法总结
- php中的session完全教程