<?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; }