Implement product browsing history in PHP mall (30 words)

How to implement the product browsing history function in PHP Developer City

With the rapid development of e-commerce, more and more people choose to shop online. As developers of mall websites, we need to provide some functions to improve users’ shopping experience and sales results. One of the functions is the product browsing history function, which can record the products that users have browsed, allowing users to easily review and find products of interest.

In this article, we will introduce how to use PHP to implement the product browsing history function. We will divide it into the following steps to complete this function.

Step 1: Create a database table
We first need to create a database table to store the user's browsing history. Create a table named "history", containing the following fields:

• id: the unique identifier of the browsing history, set as the primary key.
• user_id: The user's unique identifier.
• product_id: The unique identifier of the product.
• timestamp: The timestamp when the user browsed the product.

Step 2: Record user browsing history
When a user browses a product, we need to record the product information into the "history" table in the database. We can use PHP's MySQL connection function to connect to the database and execute insert statements to insert data into the table. The following is a sample code:

// 假设 $user_id 是当前用户的唯一标识符
// 假设 $product_id 是当前浏览的商品的唯一标识符
// 假设 $timestamp 是当前的时间戳

$conn = mysqli_connect("localhost", "username", "password", "database");
$query = "INSERT INTO history (user_id, product_id, timestamp) VALUES ('$user_id', '$product_id', '$timestamp')";
mysqli_query($conn, $query);
mysqli_close($conn);

By executing the above code, we can insert the product information browsed by the user into the "history" table.

Step 3: Display user browsing history
When a user needs to view his or her browsing history, we can query the corresponding user's browsing history from the database and display it to the user. The following is a sample code:

// 假设 $user_id 是当前用户的唯一标识符

$conn = mysqli_connect("localhost", "username", "password", "database");
$query = "SELECT * FROM history WHERE user_id = '$user_id' ORDER BY timestamp DESC";
$result = mysqli_query($conn, $query);

while ($row = mysqli_fetch_assoc($result)) {
    // 输出商品的相关信息，如商品名称、价格等
}

mysqli_close($conn);

By executing the above code, we can obtain the user's browsing history and display relevant information to the user.

Step 4: Update user browsing history
When the user browses a new product, we need to update the user's browsing history. First, determine whether the product already exists in the user's browsing history. If If it exists, update the latest timestamp of the item; if it does not exist, insert the item into the user's browsing history. The following is a sample code:

// 假设 $user_id 是当前用户的唯一标识符
// 假设 $product_id 是当前浏览的商品的唯一标识符
// 假设 $timestamp 是当前的时间戳

$conn = mysqli_connect("localhost", "username", "password", "database");
$query = "SELECT * FROM history WHERE user_id = '$user_id' AND product_id = '$product_id'";
$result = mysqli_query($conn, $query);

if (mysqli_num_rows($result) > 0) {
    // 如果当前商品已存在于用户的浏览历史中，更新该商品的最新时间戳
    $update_query = "UPDATE history SET timestamp = '$timestamp' WHERE user_id = '$user_id' AND product_id = '$product_id'";
    mysqli_query($conn, $update_query);
} else {
    // 如果当前商品不存在于用户的浏览历史中，将该商品插入到用户的浏览历史中
    $insert_query = "INSERT INTO history (user_id, product_id, timestamp) VALUES ('$user_id', '$product_id', '$timestamp')";
    mysqli_query($conn, $insert_query);
}

mysqli_close($conn);

By executing the above code, we can determine whether the current product already exists in the user's browsing history. If it exists, update the latest timestamp of the product; if it does not exist, then Insert the item into the user's browsing history.

Summary:
Through the above steps, we can use PHP to implement the product browsing history function. When the user browses the product, we insert the relevant information into the "history" table in the database; when the user needs to view the browsing history, we query the corresponding user's browsing record from the database and display it to the user; when the user browses new When items are added, we update the user's browsing history. This function not only improves the user's shopping experience, but also contributes to the sales effectiveness of the mall website.

The above is the detailed content of Implement product browsing history in PHP mall (30 words). For more information, please follow other related articles on the PHP Chinese website!