Second-hand recycling website developed with PHP to implement user shopping cart function

The second-hand recycling website developed by PHP realizes the user shopping cart function

With the development of the Internet, the online second-hand recycling market is gradually emerging. In order to improve users' shopping experience and convenience, we need to integrate the shopping cart function into the website. In this article, we will introduce how to use PHP to develop a second-hand recycling website and implement the user shopping cart function.

First, we need to create a database to store the user's shopping cart information. We can create a database named "shopping_cart" and create a table named "cart_items" in it to store the items in the shopping cart.

The following is an example MySQL table structure:

CREATE TABLE `cart_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Next, we need to add shopping cart related operations to the user registration and login functions of the website. When a user successfully registers or logs in, we will automatically create a shopping cart for them.

After the user successfully logs in, we can display the shopping cart icon in the navigation bar of the website or other appropriate locations to remind the user of the number of items in their shopping cart. When the user clicks on the shopping cart icon, we will jump to the shopping cart page and display all the items in the user's shopping cart.

The layout of the shopping cart page can be designed according to needs, usually including product pictures, names, unit prices, quantities, subtotals and other information. In order to facilitate user operations, we can provide functions such as modifying the quantity of products and deleting products on the shopping cart page.

The following is a sample code for a shopping cart page:

<table>
  <tr>
    <th>商品</th>
    <th>单价</th>
    <th>数量</th>
    <th>小计</th>
    <th>操作</th>
  </tr>
  <?php
  // 查询购物车中的商品
  $user_id = $_SESSION['user_id'];
  $sql = "SELECT * FROM cart_items WHERE user_id = $user_id";
  $result = mysqli_query($conn, $sql);

  while ($row = mysqli_fetch_assoc($result)) {
    $product_id = $row['product_id'];

    // 查询商品信息
    $product_sql = "SELECT * FROM products WHERE id = $product_id";
    $product_result = mysqli_query($conn, $product_sql);
    $product_row = mysqli_fetch_assoc($product_result);
    ?>
    <tr>
      <td><?php echo $product_row['name']; ?></td>
      <td><?php echo $product_row['price']; ?></td>
      <td><?php echo $row['quantity']; ?></td>
      <td><?php echo $product_row['price'] * $row['quantity']; ?></td>
      <td>
        <a href="edit_quantity.php?id=<?php echo $row['id']; ?>">修改数量</a>
        <a href="delete_item.php?id=<?php echo $row['id']; ?>">删除</a>
      </td>
    </tr>
    <?php
  }
  ?>
</table>

In the above sample code, we first query the product list in the shopping cart, and then query the relevant information of the product based on the product ID. Loop through the product list in the shopping cart and dynamically generate the content of the shopping cart page based on the data in the database. In the "Modify Quantity" and "Delete" links, we implement the corresponding operations by passing the product ID or shopping cart record ID.

When the user clicks the "Modify Quantity" link, we can jump to a page to modify the quantity and display the quantity of the current product on the page for the user to modify. After the user submits the modification, we can update the number of items in the shopping cart and jump back to the shopping cart page.

When the user clicks the "delete" link, we can delete the corresponding shopping cart record from the database based on the shopping cart record ID and refresh the shopping cart page.

Through the above code examples and operation instructions, we can implement a simple second-hand recycling website shopping cart function and provide operations such as adding, modifying and deleting items in the shopping cart. Of course, based on specific needs, we can expand more complex functions, such as adding favorite products, settling orders, etc.

Through this article, I hope it can help developers who are developing second-hand recycling websites, allowing you to implement the shopping cart function faster and improve the user's shopping experience.

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