<?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($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.="<ahref='index.html'>First</a>|<ahref='index_".($i-1).".html'>Front</a>";

}

if($i==$pages){

$page_turn.='|Behind|Last';

}else{

$page_turn.="|<ahref='index_".($i+1).".html'>Behind</a>|<ahref='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.="<ahref='".$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");

?>