|
|
<?php
/*
author:www.5dkx.com
done:生成html文檔
date:2009-10-27
*/
require_once("conn.php");
if($_GET['all'])
{
/*獲取數據庫記錄，以便于生成html文件有個文件名*/
$sqlquery = "select * from $tbname";
$result = mysql_query($sqlquery,$conn)or die("查詢失敗!");
$fp = fopen("./template/article.html",r);
$fpcontent = fread($fp,filesize("./template/article.html"));
fclose($fp);
/*寫入文件*/
while($row = mysql_fetch_array($result))
{
$fpcontent = str_replace("{thetitle}",$row['title'],$fpcontent);
$fpcontent = str_replace("{chatitle}",$row['title'],$fpcontent);
$fpcontent = str_replace("{bookcontent}",$row['content'],$fpcontent);
$fp = fopen("./html/".$row['id'].".html",w)or die("打開寫入文件失敗!");
fwrite($fp,$fpcontent)or die("寫入文件失敗!");
}
echo "<script language=/"Javascript/">alert('全部更新');</script>";
}
if($_GET['part'])
{
/*獲取最后一條記錄的ID，以便于生成html文件有個文件名*/
$sqlquery = "select * from $tbname order by id desc limit 1";
$result = mysql_query($sqlquery,$conn)or die("查詢失敗!");
$row = mysql_fetch_array($result);
$fp = fopen("./template/article.html",r);
$fpcontent = fread($fp,filesize("./template/article.html"));
fclose($fp);
$fpcontent = str_replace("{thetitle}",$row['title'],$fpcontent);
$fpcontent = str_replace("{chatitle}",$row['title'],$fpcontent);
$fpcontent = str_replace("{bookcontent}",$row['content'],$fpcontent);
$fp = fopen("./html/".$row['id'].".html",w)or die("打開寫入文件失敗!");
fwrite($fp,$fpcontent)or die("寫入文件失敗!");
echo "<script language=/"Javascript/">alert('部分更新成功!');</script>";
}
?>
<html>
<head>
<title>生成html文檔</title>
<script language="Javascript">
function btnsubmit(form)
{
theform.submit();
}
</script>
</head>
<body>
<?
echo "<a href=?all=111>全部更新</a><br><a href=?part=111>部分更新</a>";
?>
</body>
</html>
php技術：php將數據庫中所有內容生成靜態html文檔的代碼，轉載需保留來源！
鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯系我們修改或刪除，多謝。
