留言列表 | Message List
connect_error) {
die("连接失败: " . $conn->connect_error);
}
//查询数据
// 1 id varchar(255) utf8_general_ci
// 2 username varchar(20) utf8_general_ci
// 3 message varchar(255) utf8_general_ci
// 4 time datetime
//时间倒序查询
$sql = "SELECT * FROM message ORDER BY time DESC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while ($row = $result->fetch_assoc()) {
echo "
";
echo "
";
echo "
" . $row["username"] . "
";
echo "时间:" . $row["time"] . "
";
echo '留言内容:' . $row["message"] . '
';
echo "";
echo "
";
echo "
";
}
} else {
//没有数据
echo "
";
echo "
暂无留言 ";
echo "";
}
$conn->close();
?>