Second-hand recycling website developed in PHP to implement user purchase history recording function

The second-hand recycling website developed by PHP realizes the user purchase history function

With the enhancement of environmental awareness, people are paying more and more attention to second-hand items. In order to meet users' needs for second-hand items, many second-hand recycling websites have emerged. In the process of developing a second-hand recycling website, the user purchase history function is a very important function, which can help users track their purchase records and facilitate management and secondary transactions. This article will introduce how to use PHP to develop a second-hand recycling website and implement the user purchase history function.

First, we need to create a database table to store information about user purchase history. Suppose our database name is "recycle" and the data table name is "purchase_history". The table needs to contain the following fields: id, user_id, item_name, price, purchase_date. Among them, the id field is the auto-incrementing primary key, the user_id field is the user ID, the item_name field is the name of the purchased item, the price field is the purchase price, and the purchase_date field is the purchase date. The following is the SQL statement to create this table:

CREATE TABLE purchase_history (
  id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  user_id INT(11) NOT NULL,
  item_name VARCHAR(255) NOT NULL,
  price DECIMAL(10,2) NOT NULL,
  purchase_date DATE NOT NULL
);

Next, we need to insert the purchase history record into the database table after the user purchases the item. In the code logic for purchasing items, we need to obtain the current user's ID, item name, price, and current date, and use the INSERT statement to insert this information into the purchase_history table. Here is a sample code:

<?php
// 获取当前用户的ID，这里假设使用session保存用户ID
$user_id = $_SESSION['user_id'];

// 获取购买的物品名称和价格
$item_name = $_POST['item_name'];
$price = $_POST['price'];

// 获取当前日期
$purchase_date = date('Y-m-d');

// 将购买历史记录插入到数据库表中
$sql = "INSERT INTO purchase_history (user_id, item_name, price, purchase_date)
        VALUES ('$user_id', '$item_name', '$price', '$purchase_date')";

// 执行SQL语句
if (mysqli_query($conn, $sql)) {
    echo "购买历史记录插入成功";
} else {
    echo "购买历史记录插入失败: " . mysqli_error($conn);
}
?>

In the above code, we first get the ID of the current user, then get the name and price of the purchased item, and then get the current date. Next, we insert this information into the database table purchase_history, and output corresponding prompt information based on the insertion results.

Finally, we need to write a page to display the user's purchase history. In this page, we need to query the database table purchase_history, obtain the current user's purchase history, and display it. The following is a sample code:

<?php
// 获取当前用户的ID，这里假设使用session保存用户ID
$user_id = $_SESSION['user_id'];

// 查询数据库表purchase_history，获取购买历史记录
$sql = "SELECT * FROM purchase_history WHERE user_id = '$user_id'";
$result = mysqli_query($conn, $sql);

// 遍历查询结果，输出购买历史记录
while ($row = mysqli_fetch_assoc($result)) {
    echo "物品名称: " . $row['item_name'] . "<br>";
    echo "购买价格: " . $row['price'] . "<br>";
    echo "购买日期: " . $row['purchase_date'] . "<br><br>";
}
?>

In the above code, we first obtain the ID of the current user, then query the database table purchase_history based on the user ID, and traverse the query results to output the purchase history records one by one.

Summary:

Through the above steps, we can use PHP to develop a second-hand recycling website and implement the user purchase history function. After the user purchases the item, the purchase history will be inserted into the database table; the user can view his purchase history through the relevant page. Such a function can help users retain purchase records and facilitate management and secondary transactions. I hope this article will be helpful for developing a second-hand recycling website in PHP to implement the user purchase history function.

The above is the detailed content of Second-hand recycling website developed in PHP to implement user purchase history recording function. For more information, please follow other related articles on the PHP Chinese website!