1、新闻单页静态化
- 设置tpl模板页，模板页里面有占位符，通过后台添加新闻，同时通过替换模板页生成一个新的新闻静态html页面，以供访问
- 修改页面信息时，操作数据更新至数据库，同时更新html文件页面，删除信息时，数据库和html页面同时删除
2、首页静态化
首页静态化，可通过ob缓存，通过后台动态页面定时生成首页内容，替换旧页面
两个技术：ob缓存控制页面输出到一个html静态页面中、模板替换技术把模板替换成有内容的特定页面
简单代码：
数据库 news表 字段 id title content
manage.html
View Code
1 <html> 2 <head> 3 <meta http-equiv="content-type" content="text/html;charset=utf-8"/> 4 <title>管理新闻</title> 5 </head> 6 <body> 7 <h1>管理新闻</h1> 8 <hr /> 9 <a href="add.html">添加新闻</a>|| 10 <a href="newsList.php">更新首页</a>|| 11 <a href="showNews.php">查看新闻列表</a> 12 </body> 13 </html>
add.html
View Code
1 <html> 2 <head> 3 <meta http-equiv="content-type" content="text/html;charset=utf-8"/> 4 <title>添加新闻</title> 5 </head> 6 <body> 7 <h1>添加新闻</h1> 8 <hr /> 9 <form action="newsAction.php" method="post"> 10 标题：<input type="text" id="title" name="title" /><br /> 11 <br /> 12 内容：<textarea id="content" name="content" cols="40" rows="5"></textarea> 13 <br /> 14 <input type="submit" value="提交" id="sub" name="sub"/> 15 <input type="hidden" value="add" id="action" name="action"/> 16 </form> 17 </body> 18 </html>
news.tpl
View Code
1 <html> 2 <head> 3 <meta http-equiv="content-type" content="text/html;charset=utf-8"/> 4 <title>新闻 - %title%</title> 5 </head> 6 <body> 7 <h1>%title%</h1> 8 <hr /> 9 %content% 10 </body> 11 </html>
newsAction.php
View Code
1 <?php 2 //新闻控制页 3 header('content-type:text/html;charset=utf-8'); 4 if (isset($_REQUEST['action'])) { 5 $con = mysql_connect('127.0.0.1', 'root', '111111'); 6 if (!$con) 7 { 8 die('db connect failed'); 9 } 10 mysql_select_db('test', $con); 11 if (isset($_POST['action']) && $_POST['action'] === 'add') { 12 $sql = "insert into news (title, content) values ('{$_POST['title']}','{$_POST['content']}')"; 13 $res = mysql_query($sql, $con); 14 $addid = mysql_insert_id($con); 15 mysql_close($con); 16 17 $file_html = 'news_id_'.$addid.'.html'; 18 $f = fopen('news.tpl', 'r'); 19 $fnews = fopen('../'.$file_html, 'w'); 20 while (!feof($f)) { 21 $str = fgets($f); 22 $str = str_replace(array('%title%', '%content%'), array($_POST['title'], $_POST['content']), $str); 23 fwrite($fnews, $str); 24 } 25 fclose($f); 26 fclose($fnews); 27 echo '添加新闻成功 <a href="manage.html">返回管理新闻</a>||<a href="../'.$file_html.'">查看新闻</a>'; 28 29 } elseif ($_GET['action'] === 'u') { 30 echo 'upadte'; 31 } elseif ($_GET['action'] === 'd') { 32 echo 'del'; 33 } 34 35 } else { 36 echo '参数错误 <a href="manage.html">返回管理新闻</a>'; 37 } 38 39 40 ?>
newsList.php
View Code
1 <?php 2 3 //列出新闻列表 4 $con = mysql_connect('127.0.0.1', 'root', '111111'); 5 6 if (!$con) 7 { 8 die('fail'); 9 } 10 mysql_select_db('test', $con); 11 $sql = "select * from news"; 12 $res = mysql_query($sql, $con); 13 header('content-type:text/html;charset=utf-8'); 14 ob_start(); 15 echo '<meta http-equiv="content-type" content="text/html;charset=utf-8"/>\n'; 16 echo "<h1>新闻列表</h1>\n"; 17 echo "<table>\n"; 18 echo "<tr><td>id</td><td>标题</td><td>查看详情</td></tr>\n"; 19 while ($row = mysql_fetch_assoc($res)) 20 { 21 echo "<tr><td>{$row['id']}</td><td>{$row['title']}</td><td><a href='news_id_{$row['id']}.html'>查看详情</a></td></tr>\n"; 22 } 23 echo "</table>\n"; 24 $newslist = ob_get_clean(); 25 file_put_contents('../index.html', $newslist); 26 27 mysql_free_result($res); 28 mysql_close($con); 29 30 echo '更新成功！<a href="../index.html">查看首页</a>||<a href="manage.html">返回管理新闻</a>'; 31 32 ?>
showNews.php
View Code
1 <?php 2 //查看新闻列表 3 $con = mysql_connect('127.0.0.1', 'root', '111111'); 4 5 if (!$con) 6 { 7 die('fail'); 8 } 9 mysql_select_db('test', $con); 10 $sql = "select * from news"; 11 $res = mysql_query($sql, $con); 12 13 //显示新闻内容 14 15 echo '<meta http-equiv="content-type" content="text/html;charset=utf-8"/>'; 16 echo "<h1>新闻列表</h1>"; 17 echo "<table>"; 18 echo "<tr><td>id</td><td>标题</td><td>查看详情</td><td>操作</td></tr>"; 19 while ($row = mysql_fetch_assoc($res)) 20 { 21 echo "<tr> 22 <td>{$row['id']}</td> 23 <td>{$row['title']}</td> 24 <td><a href='../news_id_{$row['id']}.html'>查看详情</a></td> 25 <td><a href='newsAction.php?action=d&id={$row['id']}'>删除</a>|<a href='newsAction.php?action=u&id={$row['id']}'>修改</a></td> 26 </tr>"; 27 } 28 echo "</table>"; 29 30 mysql_free_result($res); 31 mysql_close($con); 32 33 ?>