PHP를 사용하여 지식 Q&A 웹사이트에서 질문 검색 기록 및 녹음 기능을 개발합니다.

CREATE TABLE history (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT,
  question_id INT,
  timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

// 设置数据库连接
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败： " . $conn->connect_error);
}

// 获取当前登录用户的 ID
$user_id = $_SESSION['user_id'];

// 获取用户最近浏览的问题记录
$query = "SELECT * FROM history WHERE user_id = $user_id ORDER BY timestamp DESC LIMIT 10";
$result = $conn->query($query);

// 显示浏览历史记录
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $question_id = $row['question_id'];
        
        // 根据问题 ID 查询问题详情并显示
        $query_question = "SELECT * FROM questions WHERE id = $question_id";
        $result_question = $conn->query($query_question);
        
        if ($result_question->num_rows > 0) {
            while($row_question = $result_question->fetch_assoc()) {
                echo $row_question['title'];
                echo "<br>";
                echo $row_question['content'];
                echo "<br><br>";
            }
        }
    }
} else {
    echo "还没有浏览历史记录";
}

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