数据库连接配置
dbconfig.php
<?php
define("HOST","localhost");
define("USER","root");
define("PASS","root");
define("DBNAME","message");
?>
conn.php
<?php
header('content-type:text/html;charset=utf8');
// $servername = "localhost";
// $username = "root";
// $password = "root";
// $dbname = "message";
require("dbconfig.php");
$conn = @mysql_connect(HOST,USER,PASS) or die("数据库连接失败!");
mysql_select_db(DBNAME,$conn);
?>
留言板主页
index4.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>留言板主页</title>
</head>
<body>
<div id="header">
<a href="login.php">登录</a>
<a href="register.php">注册</a>
</div>
<div id="content">
<h2>留言板留言列表</h2>
<table border="1px" cellspacing="0">
<tr>
<th>序号</th>
<th>标题</th>
<th>作者</th>
<th>时间</th>
<th>操作</th>
</tr>
<?php
//定义分页查询的变量信息
require("conn.php");
$pageSize = 2;//每一页显示1条记录
//获取当前数据表中的总页码数
$sql = "select * from msgs";
$results = mysql_query($sql);
$pageMaxNumber = ceil((float)(mysql_num_rows($results)) / $pageSize);
mysql_free_result($results);
if(isset($_GET['page'])) {
$page = $_GET['page'];