PHP页面静态化学习笔记之四：简易新闻系统v1.0

create table news(
id int unsigned primary key auto_increment,
title varchar(128) not null,
content varchar(256) not null,
filename varchar(32)) engine=MyISAM

INSERT INTO `static_pages_news`.`news` (`id`, `title`, `content`, `filename`) VALUES (NULL, 'hello1', '北京你好', NULL), (NULL, 'hello2', '四川你好', NULL);

<?php //新闻列表
    //查询数据库，获取信息=>SqlHelper.class.php

    $conn = mysql_connect("localhost", "root", "root");
    if (!$conn) {
        die("连接失败");
    }
    mysql_select_db("static_pages_news", $conn);
    mysql_query("set names utf8");
    
    $sql = "select * from news";
    $res = mysql_query($sql);
    
	header("content-type:text/html;charset=utf-8");
    echo "<h1>新闻列表</h1>";
    echo "<a href="#">添加新闻</a><hr>";
    echo "

<?php $id = @$_GET['id'];
//构建文件名
$html_filename = "new_id" . $id . ".html";
$html_path = dirname(__FILE__) . "/" . $html_filename;
//判断html页面是否有并且页面最后修改时间到现在小于30s
if (file_exists($html_path) && filemtime($html_path) &#43; 30 < time()) {
    //直接访问html页面（把html页面的内容echo浏览器）
    echo file_get_contents($html_path);
    exit ;
}

$conn = mysql_connect("localhost", "root", "root");
if (!$conn) {
    die("连接失败");
}
mysql_select_db("static_pages_news", $conn);
mysql_query("set names utf8");

$sql = "select * from news where id=$id";
$res = mysql_query($sql);
//开启缓存
ob_start();
if ($row = mysql_fetch_assoc($res)) {
    header("content-type:text/html;charset=utf-8");
    echo "<table border='1px' bordercolor='green' cellspacing='0' width=400px height=200px>";
    echo "<tr><td>新闻详细内容</td></tr>";
    echo "<tr><td>{$row['title']}</td></tr>";
    echo "<tr><td>{$row['content']}</td></tr>";
    echo "";
} else {
    echo "没有结果";
}

$html = ob_get_contents();
$my_header = "<meta http-equiv="Content-Type" content="text/html; charset=utf-8">";
//把ob写进html文档
file_put_contents($html_path, $my_header . $html);
mysql_free_result($res);
mysql_close($conn);
?>