<?php
//1
$msg_id = $_GET['id'];
require_once 'dbUtil.php';
$conn = PdoFactory::getConn();
//2.查询指定信息
$sql = <<<SQL
SELECT msgs.title, msgs.content, msgs.time, user.name
FROM msgs, user
WHERE msgs.id = {$msg_id} AND msgs.auth_id = user.id;
SQL;
$msg = PdoFactory::getResults($conn, $sql)[0];
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>显示留言</title>
</head>
<body>
<div>留言标题：<?php
echo $msg['title'];
?>
</div>
<div>留言发表者：<?php
echo $msg['name'];
?>
</div>
<div>留言内容：<?php
} elseif ($page > $pageMaxNumber) {
$page = 1;
}
$lastPage = $page - 1;
$nextPage = $page + 1;
$page_begin = ($page - 1) * $page_size;
//$page = 1;
//$sql = 'select * from msgs';
$sql = <<<SQL
SELECT msgs.id, msgs.title, user.name, msgs.time
FROM msgs, user
WHERE msgs.auth_id = user.id
LIMIT {$page_begin}, {$page_size};
SQL;
//$ret = $conn->query($sql);
$ret = PdoFactory::getResults($conn, $sql);
//var_dump($ret);
foreach ($ret as $row) {
echo <<<STR
<tr>
<td>{$row['id']}</td>
<td><a href="viewMsg.php?id={$row['id']}">{$row['title']}</a></td>
<td>{$row['name']}</td>
<td>{$row['time']}</td>
<td>
<a href="deleteMsg.php?id={$row['id']}&page={$page}">删除</a>
<a href="updateMsg.php?id={$row['id']}&page={$page}">更新</a>
</td>
</tr>
STR;
}
