用PHP生成html分页列表的代码

　　<?php
$db=mysql_connect(127.0.0.1,root,*******)ordie(canttconnecthost);
$re=mysql_select_db(t,$db)ordie(cantopendatabase);

$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.=FirstFront;
}else{
$indexpath=index_.$i..html;
$page_turn.=<ahref=index.html>First</a><ahref=index_.($i-1)..html>Front</a>;
}
if($i==$pages){
$page_turn.=BehindLast;
}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);
?>