PHP-Mall-Entwicklungsfähigkeiten: Entwerfen von Produktdetailseiten und empfohlenen Produktfunktionen

<?php
// 连接数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 查询商品信息
$query = "SELECT * FROM products WHERE id = 1";
$result = mysqli_query($connection, $query);
$product = mysqli_fetch_assoc($result);

// 展示商品信息
echo "商品名称：" . $product['name'];
echo "商品价格：" . $product['price'];
echo "商品描述：" . $product['description'];
// 等等...
?>

<div class="product-image">
    <img src="<?php echo $product['image']; ?>" alt="商品图片">
</div>

<?php
// 查询规格参数
$query = "SELECT * FROM spec_params WHERE product_id = 1";
$result = mysqli_query($connection, $query);
while ($param = mysqli_fetch_assoc($result)) {
    echo $param['param_name'] . "：" . $param['param_value'];
}

<?php
// 获取用户ID
$user_id = $_SESSION['user_id'];

// 获取用户浏览记录
$query = "SELECT * FROM view_logs WHERE user_id = $user_id";
$result = mysqli_query($connection, $query);

// 提取浏览记录中的商品ID
$product_ids = [];
while ($log = mysqli_fetch_assoc($result)) {
    $product_ids[] = $log['product_id'];
}

// 根据浏览记录推荐相关商品
$query = "SELECT * FROM products WHERE id IN (" . implode(',', $product_ids) . ")";
$result = mysqli_query($connection, $query);
while ($product = mysqli_fetch_assoc($result)) {
    echo $product['name'];
    // 等等...
}
?>

<?php
// 获取用户喜欢的商品ID
$user_id = $_SESSION['user_id'];
$query = "SELECT * FROM like_logs WHERE user_id = $user_id";
$result = mysqli_query($connection, $query);
$product_ids = [];
while ($log = mysqli_fetch_assoc($result)) {
    $product_ids[] = $log['product_id'];
}

// 根据商品相似度推荐相关商品
$query = "SELECT * FROM products WHERE id IN (
    SELECT product_id FROM product_similarity WHERE source_product_id IN (" . implode(',', $product_ids) . ")
)";
$result = mysqli_query($connection, $query);
while ($product = mysqli_fetch_assoc($result)) {
    echo $product['name'];
    // 等等...
}
?>