PHP を使用してレコメンデーション システムのリアルタイムのパーソナライズされたレコメンデーションを実装する方法

CREATE TABLE actions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    action VARCHAR(255),
    item_id INT,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

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

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

// 捕获用户的点击行为
$action = "click";
$item_id = $_GET['item_id']; // 从GET请求中获取item_id
$user_id = $_SESSION['user_id']; // 从会话中获取user_id

// 将用户的行为存储到数据库中
$sql = "INSERT INTO actions (user_id, action, item_id) VALUES ('$user_id', '$action', '$item_id')";
$conn->query($sql);
$conn->close();
?>

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

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

// 获取用户的兴趣模型
$user_id = $_SESSION['user_id']; // 从会话中获取user_id
$sql = "SELECT item_id FROM actions WHERE user_id = '$user_id' AND action = 'click'";
$result = $conn->query($sql);
$interests = array();

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $item_id = $row['item_id'];
        $interests[] = $item_id;
    }
}

// 根据用户的兴趣模型进行推荐
$sql = "SELECT item_id FROM actions WHERE user_id <> '$user_id' AND action = 'click' AND item_id NOT IN (" . implode(',', $interests) . ")";
$result = $conn->query($sql);
$recommendations = array();

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $item_id = $row['item_id'];
        $recommendations[] = $item_id;
    }
}

$conn->close();
?>

<?php
foreach ($recommendations as $item_id) {
    // 根据item_id从数据库中获取item的详细信息
    $sql = "SELECT * FROM items WHERE item_id = '$item_id'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            // 显示item的标题、图片等信息
            echo $row['title'] . "<br>";
            echo "<img src='" . $row['image'] . "'><br>";
            // ...
        }
    }
}
?>