// Êý¾Ý¿âÁ¬½ÓÐÅÏ¢

$host = 'localhost';

$username = 'root';

$password = 'password';

$database = 'messages';

// Á¬½ÓÊý¾Ý¿â

$conn = mysqli_connect($host, $username, $password, $database);

// ¼ì²éÁ¬½ÓÊÇ·ñ³É¹¦

if (!$conn) {

die('Êý¾Ý¿âÁ¬½Óʧ°Ü: ' . mysqli_connect_error());

}

// ¼ì²éÊÇ·ñÓбí¸ñ£¬Èç¹ûûÓÐÔò´´½¨

$sql = "CREATE TABLE IF NOT EXISTS messages (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(30) NOT NULL,

message TEXT NOT NULL,

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

)";

if (mysqli_query($conn, $sql)) {

// ±í¸ñ´´½¨³É¹¦

} else {

echo '´´½¨±í¸ñʧ°Ü: ' . mysqli_error($conn);

}

// ´¦ÀíÌá½»µÄÁôÑÔ

if ($_SERVER['REQUEST_METHOD'] === 'POST') {

$name = $_POST['name'];

$message = $_POST['message'];

$sql = "INSERT INTO messages (name, message) VALUES ('$name', '$message')";

if (mysqli_query($conn, $sql)) {

// ÁôÑÔÌá½»³É¹¦

} else {

echo 'ÁôÑÔÌύʧ°Ü: ' . mysqli_error($conn);

}

}

// ²éѯÁôÑÔ

$sql = "SELECT * FROM messages ORDER BY created_at DESC";

$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {

while ($row = mysqli_fetch_assoc($result)) {

echo '

' . $row['name'] . ': ' . $row['message'] . '

}

} else {

echo '

ÔÝÎÞÁôÑÔ

}

// ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó

mysqli_close($conn);

?>