如何利用PHP生成html分页列表

<?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");            
?>