|
<?php
$db=mysql_connect("127.0.0.1","root","***")ordie("cant'tconnecthost");
$re=mysql_select_db("t",$db)ordie("can'topendatabase"); $sql="SelectFROMnews";
$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";
$pageturn.="First|Front";
}else{
$indexpath="index".$i.".html";
$pageturn.="<ahref='index.html'>First|<ahref='index".($i-1).".html'>Front";
}
if($i==$pages){
$page_turn.='|Behind|Last';
}else{
$pageturn.="|<ahref='index".($i+1).".html'>Behind|<ahref='index_".$pages.".html'>Last";
}
$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.="<ahref='".$id.".html'>".$title."
";
$j+=1;
}
$list.="
".$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");
?> （编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
