PHP 실시간 채팅 기능을 위한 메시지 저장 및 이력 처리

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "chat";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取聊天消息的内容和发送者
$message = $_POST['message'];
$sender = $_POST['sender'];

// 插入消息到数据库
$sql = "INSERT INTO messages (message, sender) VALUES ('$message', '$sender')";
if ($conn->query($sql) === TRUE) {
    echo "消息已存储";
} else {
    echo "存储消息失败: " . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "chat";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 从数据库中获取历史记录
$sql = "SELECT * FROM messages ORDER BY id DESC LIMIT 10";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出历史记录
    while($row = $result->fetch_assoc()) {
        echo "发送者: " . $row["sender"]. " - 消息内容: " . $row["message"]. "<br>";
    }
} else {
    echo "暂无历史记录";
}

// 关闭数据库连接
$conn->close();
?>