用PHP生成html分页列表的代码_PHP教程-php教程-PHP中文网

首页

后端开发

php教程

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

Jul 21, 2016 pm 03:56 PM

connect html mysql or php root 代码分页列表生成用的

$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($rowif($row%$pagesize){
    $pages  = intval($row/$pagesize)+1;
}else{
    $pages  = intval($row/$pagesize);
}

for($i=1;$i    $page_turn="";
    if($i==1){
        $indexpath="index.html";
        $page_turn.="First | Front";
    }else{
        $indexpath="index_".$i.".html";
        $page_turn.="First | Front";
    }
    if($i==$pages){
        $page_turn.=' | Behind | Last';
    }else{
        $page_turn.=" | Behind | Last";
    }
    $search = $sql." LIMIT ".($i-1)*$pagesize .", $pagesize";
    $result = mysql_query($search);
    $rows   = mysql_num_rows($result);
    $j=1;
    $list="";
    while($j        $doc    = mysql_fetch_array($result);
        $id     = $doc['0'];
        $title  = $doc['1'];
        $path   = $doc['3'];
        $list   .="".$title."
";
        $j+=1;
    }
    $list.="

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