Home  >  Article  >  Backend Development  >  How to use PHP to generate html paginated list

How to use PHP to generate html paginated list

不言
不言Original
2018-06-21 11:04:231245browse

This article mainly introduces how to use PHP to generate html paging list, which has certain reference value. Now I share it with everyone. Friends in need can refer to it

<?php 
$db = mysql_connect("127.0.0.1","root","*******") or die("cant&#39;t connect host"); 
$re = mysql_select_db("t",$db)or die ("can&#39;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=&#39;index.html&#39;>First</a> | <a href=&#39;index_".($i-1).".html&#39;>Front</a>"; 
    } 
    if($i==$pages){ 
        $page_turn.=&#39; | Behind | Last&#39;; 
    }else{ 
        $page_turn.=" | <a href=&#39;index_".($i+1).".html&#39;>Behind</a> | <a href=&#39;index_".$pages.".html&#39;>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[&#39;0&#39;]; 
        $title  = $doc[&#39;1&#39;]; 
        $path   = $doc[&#39;3&#39;]; 
        $list   .="<a href=&#39;".$id.".html&#39;>".$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");            
?>

The above is the entire content of this article. I hope it will be helpful to everyone’s learning. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

How to use html static pages to call php files

How to use PHP to solve the problem of large website traffic and High concurrency issues

How to use PHP to generate web pages that are easy to print

The above is the detailed content of How to use PHP to generate html paginated list. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn