search

Home  >  Article  >  php教程  >  php 利用数据库信息生成静态页面实例代码

php 利用数据库信息生成静态页面实例代码

WBOY
WBOYOriginal
2016-05-25 16:42:411213browse

这是一款用户自己写的php生成html页面的代码,简单实用比较适合初学者,如果你正在学习php生成静态文件,这一个实例从数据库到php到模板文件都一步步的很清楚,代码如下:

<?php
$con = mysql_connect("localhost", "root", "") or die("链接错误！！！");
mysql_select_db("message", $con) or die("数据库链接错误！！！");
mysql_query("set names &#39;gbk&#39;");
$sql = mysql_query("select * from message");
if ($_post[button]) {
    while ($row = mysql_fetch_array($sql)) {
        $path = $row[0] . &#39;.html&#39;;
        $user = $row[1];
        $title = $row[2];
        $content = $row[3];
        $date = $row[4]; //开源代码phprm.com
        $fp = fopen("moban/html.html", "r");
        $str = fread($fp, filesize("./moban/html.html"));
        $str = str_replace("{user}", $user, $str);
        $str = str_replace("{title}", $title, $str);
        $str = str_replace("{content}", $content, $str);
        $str = str_replace("{date}", $date, $str);
        fclose($fp);
        $handle = fopen("news/" . $path, "w");
        fwrite($handle, $str);
        fclose($handle);
        echo "<script>alert(&#39;生成成功!!!&#39;);window.location.href=&#39;html.php&#39;;</script>";
    }
}
?>
<!doctype html> 
<html> 
<head> 
<meta http-equiv="content-type" content="text/html; charset=gb2312" /> 
<title>无标题文档</title> 
</head> 
<body> 
<form id="form1" name="form1" method="post" action=""> 
  <label> 
  <input type="submit" name="button" id="button" value="生成静态页面" /> 
  </label> 
</form> 
</body> 
</html> 
模板文件代码,代码如下:
<!doctype html> 
<html> 
<head> 
<meta http-equiv="content-type" content="text/html; charset=gb2312" /> 
<title>无标题文档</title> 
</head> 
<body> 
<table width="500"> 
  <tr> 
<td width="80"><div align="right">名称：</div></td> 
<td width="408"><div align="left">{user}</div></td> 
  </tr> 
  <tr> 
<td><div align="right">标题：</div></td> 
<td><div align="left">{title}</div></td> 
  </tr> 
  <tr> 
<td><div align="right">内容：</div></td> 
<td><div align="left">{content}</div></td> 
  </tr> 
  <tr> 
<td><div align="right">日期：</div></td> 
<td><div align="left">{date}</div></td> 
  </tr> 
  <tr> 
<td><div align="right"></div></td> 
<td><div align="left"></div></td> 
  </tr> 
</table> 
</body> 
删除html代码,代码如下:
<?php
$con = mysql_connect("localhost", "root", "") or die("链接错误！！！");
mysql_select_db("message", $con) or die("数据库链接错误！！！");
mysql_query("set names &#39;gbk&#39;");
$sql = mysql_query("select * from message");
if ($_post[button]) {
    while ($row = mysql_fetch_array($sql)) {
        $path = $row[0] . &#39;.html&#39;;
        if (@unlink("news/" . $path)) {
            echo "<script>alert(&#39;删除成功!!!&#39;);window.location.href=&#39;unlink_html.php&#39;;</script>";
        } else {
            echo "<script>alert(&#39;无内容可以删除!!!&#39;);window.location.href=&#39;unlink_html.php&#39;;</script>";
        }
    }
}
?>
<form id="form1" name="form1" method="post" action=""> 
  <label> 
  <input type="submit" name="button" id="button" value="删除静态页面" /> 
  </label> 
</form>

数据库结构,用phpmyadmin导入就行了.

表的结构 `message` 

-- 
create table `message` ( 
  `id` int(4) not null auto_increment, 
  `user` varchar(20) not null, 
  `title` varchar(100) not null, 
  `content` text not null, 
  `date` date not null, 
  primary key  (`id`) 
) engine=myisam  default charset=gbk auto_increment=3 ; 
-- 
-- 导出表中的数据 `message` 
-- 
insert into `message` (`id`, `user`, `title`, `content`, `date`) values 
(1, &#39;dfkk&#39;, &#39;数据库信息生成静态页面&#39;, &#39;www.phprm.com&#39;, &#39;2010-02-12&#39;), 
(2, &#39;dfkk&#39;, &#39;数据库信息生成静态页面&#39;, &#39;原理很简单&#39;, &#39;2010-02-12&#39;);

自己写的,可通过按钮生成静态页面和删除已生成的静态页面.

moban存放模板文件夹（勿删）。

news生成静态页面文件夹（勿删）。

注意事项:phpmyadmin工具导入数据库文件message.sql。


教程地址：

欢迎转载！但请带上文章地址^^

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
Previous article：php 缓存技术 Next article：php 数据库内容以数组形式保存文件中

Related articles

See more