利用php,将数据库中的文章数据生成单个的html文档。首先,有利于搜索引擎的收录。其次,避免数据库中的字段暴露在地址栏上,更安全。
给出代码:
<?<span>php
</span><span>//</span><span>引入数据库配置文件</span>
<span>include</span>( <span>dirname</span>(<span>dirname</span>(<span>__FILE__</span>))."\include\config.php"<span> );
</span><span>/*</span><span>*
*
* 将数据库中的文章生成单个HTML文件.
* @param Date $Date
* @param Time $Time
* @param String $Content
* @param String $Title
</span><span>*/</span>
<span>function</span> GenerateHTML(<span>$Date</span>,<span>$Time</span>,<span>$Content</span>,<span>$Title</span>,<span>$Name</span><span>){
</span><span>//</span><span>将日期、时间变量分解成数组</span>
<span>$GetDateRow</span> = <span>explode</span>("-", <span>$Date</span><span>);
</span><span>$GetTimeRow</span> = <span>explode</span>(":",<span>$Time</span><span>);
</span><span>//</span><span>得到文件的名字。比如:20121028210632.html</span>
<span>$FileName</span> = <span>$GetDateRow</span>[0].<span>$GetDateRow</span>[1].<span>$GetDateRow</span>[2].<span>$GetTimeRow</span>[0].<span>$GetTimeRow</span>[1].<span>$GetTimeRow</span>[2].".html"<span>;
</span><span>//</span><span>打开并读取模板内容</span>
<span>$FP</span> = <span>fopen</span>("tmp.html","r"<span>);
</span><span>$Str</span> = <span>fread</span>(<span>$FP</span>,<span>filesize</span>("tmp.html"<span>));
</span><span>//</span><span>得到替换后的模板内容</span>
<span>$Str</span> = <span>str_replace</span>("{Title}",<span>$Title</span>, <span>$Str</span><span>);
</span><span>$Str</span> = <span>str_replace</span>("{Content}", <span>$Content</span>, <span>$Str</span><span>);
</span><span>$Str</span> = <span>str_replace</span>("{Name}", <span>$Name</span>, <span>$Str</span><span>);
</span><span>$Str</span> = <span>str_replace</span>("{Date}", <span>$Date</span>,<span>$Str</span><span>);
</span><span>$Str</span> = <span>str_replace</span>("{Time}", <span>$Time</span>, <span>$Str</span><span>);
</span><span>//</span><span>关闭文件,减少服务器的压力。</span>
<span>fclose</span>(<span>$FP</span><span>);
</span><span>//</span><span>将内容写入HTML文件</span>
<span>$Handle</span> = <span>fopen</span>(<span>$FileName</span>,"w"<span>);
</span><span>fwrite</span>(<span>$Handle</span>,<span>$Str</span><span>);
</span><span>fclose</span>(<span>$Handle</span><span>);
</span><span>//</span><span>小测一下
//echo "ok,done!";</span>
<span>
}
</span><span>//</span><span>数据库的操作</span>
<span>$querysql</span> = "select * from article"<span>;
</span><span>$queryset</span> = <span>mysql_query</span>(<span>$querysql</span><span>);
</span><span>//</span><span>循环生成HTML文件。</span>
<span>while</span>( <span>$row</span> = <span>mysql_fetch_array</span>(<span>$queryset</span><span>) ){
GenerateHTML(</span><span>$row</span>['date'],<span>$row</span>['time'],<span>$row</span>['content'],<span>$row</span>['title'],<span>$row</span>['name'<span>]);
}</span>OK,DONE!
PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号