Second-hand recycling website developed with PHP implements purchase record viewing function

The second-hand recycling website developed by PHP realizes the purchase record viewing function

With the rapid development of the second-hand market, second-hand recycling websites have become an important channel for people to recycle waste items and purchase second-hand goods. In order to improve user experience and increase transaction transparency, we decided to implement the purchase record viewing function on our second-hand recycling website.

Before implementing the purchase record viewing function, we need to build a basic second-hand recycling website, including user registration, login, product list display, purchase function, etc. Next, we will introduce how to add the purchase record viewing function to an existing website.

First, we need to create a table named "purchase_records" in the database to store the user's purchase records. The table contains the following fields:

• id: The unique identifier of the purchase record
• user_id: The unique identifier of the user
• product_id: The unique identifier of the product
• purchase_date: Purchase date
• price: Purchase price

Next, add a "Purchase Record" link on the user center page of the website, by clicking the The link takes you to the purchase record viewing page.

<a href="purchase_records.php">购买记录</a>

In the purchase_records.php file, we will query the user's purchase records and display them on the page. First, we need to connect to the database and verify the current user's login status.

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

// 验证登录状态
session_start();
if (!isset($_SESSION["user_id"])) {
  header("Location: login.php"); //用户未登录，跳转到登录页面
  exit;
}

// 查询用户的购买记录
$user_id = $_SESSION["user_id"];
$sql = "SELECT * FROM purchase_records WHERE user_id = '$user_id'";
$result = $conn->query($sql);

Next, we will display the purchase record on the page, which can be achieved using an HTML table.

<table>
  <tr>
    <th>购买记录ID</th>
    <th>商品名称</th>
    <th>购买日期</th>
    <th>购买价格</th>
  </tr>
  <?php while ($row = $result->fetch_assoc()) { ?>
    <?php
      $product_id = $row["product_id"]; 
      $product_sql = "SELECT name FROM products WHERE id = '$product_id'";
      $product_result = $conn->query($product_sql);
      $product_row = $product_result->fetch_assoc();
      $product_name = $product_row["name"];
    ?>
    <tr>
      <td><?php echo $row["id"]; ?></td>
      <td><?php echo $product_name; ?></td>
      <td><?php echo $row["purchase_date"]; ?></td>
      <td><?php echo $row["price"]; ?></td>
    </tr>
  <?php } ?>
</table>

The above code will query the corresponding product name based on the user's purchase record, and display the purchase record ID, product name, purchase date and purchase price in the table.

Through the above code example, we successfully implemented the purchase record viewing function on the second-hand recycling website. Users can click on the "Purchase Record" link to enter the purchase record page and view their purchase history. This not only improves the user experience, but also increases transaction transparency.

Of course, the purchase record viewing function is only one of the many functions of the second-hand recycling website. We can also further improve other functions of the website, such as the comment system, favorites function, etc., to provide a better user experience and increase User interaction.

The above is the detailed content of Second-hand recycling website developed with PHP implements purchase record viewing function. For more information, please follow other related articles on the PHP Chinese website!