$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; Page out
Number of rows
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.= "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 <= $rows) {
$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 ");
?>
The above describes the generation of HTML HTML page list generated by PHP code, including the generation of HTML content, you want to be interested in PHP tutorial friends helpful.