php 利用數據庫信息生成靜態頁面實例代碼

2024-05-04 21:58:30

字體：大中小

來源：轉載

供稿：網友

這是一款用戶自己寫的php生成html頁面的代碼,簡單實用比較適合初學者,如果你正在學習php生成靜態文件,這一個實例從數據庫到php到模板文件都一步步的很清楚,代碼如下:

<?php

$con=mysql_connect("localhost","root","")or die("鏈接錯誤！！！");

mysql_select_db("message",$con)or die("數據庫鏈接錯誤！！！");

mysql_query("set names 'gbk'");

$sql=mysql_query("select * from message");

if($_post[button]){

while($row=mysql_fetch_array($sql)){

$path=$row[0].'.html';

$user=$row[1];

$title=$row[2];

$content=$row[3];

$date=$row[4];//開源代碼Vevb.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('生成成功!!!');window.location.href='html.php';</script>";

}

}

?>

<!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<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 public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">

<html xmlns="http://www.111cn.net/1999/xhtml">

<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 'gbk'");

$sql=mysql_query("select * from message");

if($_post[button]){

while($row=mysql_fetch_array($sql)){

$path=$row[0].'.html';



  if(@unlink("news/".$path)){

  echo "<script>alert('刪除成功!!!');window.location.href='unlink_html.php';</script>";

  }else{

  echo "<script>alert('無內容可以刪除!!!');window.location.href='unlink_html.php';</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, 'dfkk', '數據庫信息生成靜態頁面', 'm.survivalescaperooms.com', '2010-02-12'),

(2, 'dfkk', '數據庫信息生成靜態頁面', '原理很簡單', '2010-02-12');