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