Detailed introduction to the mall group purchasing function developed using PHP

Detailed introduction to the mall group buying function developed using PHP

With the rapid development of the e-commerce industry, group buying has become a popular shopping model. In order to adapt to this trend, many malls have begun to introduce group buying functions to increase user stickiness and increase sales. This article will introduce how to use PHP to develop a mall group purchasing function and provide relevant code examples.

1. The implementation principle of the group purchase function
The implementation principle of the group purchase function mainly involves the following aspects:

1. Display of group purchase products: The mall needs to be able to display information about group purchase products , including product pictures, names, group purchase prices, original prices, remaining time, etc.
2. Joining and withdrawing from the group: Users can choose to join or withdraw from the group. When joining a tour, you need to determine whether there is enough inventory. If there is insufficient inventory, the user will not be able to join the tour. When canceling a group, the user needs to be removed from the group purchase order.
3. Purchase and payment: After joining the group, users can choose to purchase group purchase products. During the purchase process, you need to generate an order, calculate the price and select a payment method.
4. Update of group purchase status: Another important function is to be able to update the status of group purchase in real time, such as the remaining time, the number of people who have participated in the group, etc.

2. Database design and product display
First, we need to design a database table to store group purchase product information and group purchase order information. Create two tables in the database: goods and orders.

1. The structure of the goods table is as follows:

CREATE TABLE goods (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    stock INT NOT NULL,
    start_time TIMESTAMP NOT NULL,
    end_time TIMESTAMP NOT NULL,
    image VARCHAR(255) NOT NULL
);

2. The structure of the orders table is as follows:

CREATE TABLE orders (
    id INT PRIMARY KEY AUTO_INCREMENT,
    user_id INT NOT NULL,
    goods_id INT NOT NULL,
    price DECIMAL(10, 2) NOT NULL,
    quantity INT NOT NULL,
    total_price DECIMAL(10, 2) NOT NULL,
    payment_status INT NOT NULL,
    create_time TIMESTAMP NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (goods_id) REFERENCES goods(id)
);

Next, we can write PHP code to display group purchase product information. The code is as follows:

<?php
// 获取团购商品信息
$sql = "SELECT * FROM goods WHERE end_time > NOW()";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo "商品名称：" . $row['name'] . "<br>";
        echo "团购价格：" . $row['price'] . "<br>";
        echo "原价：" . $row['original_price'] . "<br>";
        echo "剩余时间：" . $row['end_time'] - time() . "<br>";
        echo "<img  src='" . $row['image'] . "' alt="Detailed introduction to the mall group purchasing function developed using PHP" ><br>";
        echo "<br>";
    }
} else {
    echo "当前没有团购商品";
}

mysqli_close($conn);
?>

3. Joining and withdrawing from the group

Next, we need to implement the functions for users to join and withdraw from the group.

1. When users join a group tour, we need to first determine whether the current product inventory is sufficient. If there is insufficient stock, the user will be prompted that they cannot participate in the group; if there is sufficient stock, a group purchase order will be generated.
2. When a user withdraws from a group, it is necessary to first check whether the user has joined the group. If the user has already joined the group purchase, the user will be removed from the group purchase order.

The following is a sample code:

<?php
// 用户参团
$goodsId = $_POST['goodsId'];
$userId = $_SESSION['userId'];

$sql = "SELECT stock FROM goods WHERE id = $goodsId";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$stock = $row['stock'];

if ($stock <= 0) {
    echo "库存不足，无法参团";
} else {
    // 生成团购订单
    $sql = "INSERT INTO orders (user_id, goods_id, price, quantity, total_price, payment_status, create_time) VALUES ($userId, $goodsId, $price, 1, $price, 0, NOW())";
    $result = mysqli_query($conn, $sql);

    echo "参团成功";
}

// 用户退团
$orderId = $_POST['orderId'];

$sql = "DELETE FROM orders WHERE id = $orderId";
$result = mysqli_query($conn, $sql);

echo "退团成功";

mysqli_close($conn);
?>

4. Purchase and payment

Purchasing and payment are a very important part of the group buying function. After joining the group, users can choose to purchase group purchase products and choose a payment method.

The following is a sample code:

<?php
// 用户购买和支付
$orderId = $_POST['orderId'];
$paymentMethod = $_POST['paymentMethod'];

$sql = "SELECT * FROM orders WHERE id = $orderId";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_assoc($result);
$totalPrice = $row['total_price'];

// 根据支付方式处理支付逻辑
if ($paymentMethod == 'wechat') {
    // 微信支付
    // 调用微信支付接口
    echo "调用微信支付接口，支付金额为：" . $totalPrice;
} elseif ($paymentMethod == 'alipay') {
    // 支付宝支付
    // 调用支付宝支付接口
    echo "调用支付宝支付接口，支付金额为：" . $totalPrice;
} else {
    echo "无效的支付方式";
}

mysqli_close($conn);
?>

5. Group purchase status update

The last function is to update the group purchase status, such as the remaining time and the number of people who have participated in the group. We can use JavaScript to refresh the page regularly to achieve real-time updates.

<script type="text/javascript">
    function updateCountdown() {
        // 更新剩余时间
        var endTime = "<?php echo $row['end_time']; ?>";
        var remainingTime = new Date(endTime) - new Date();
        document.getElementById("countdown").innerHTML = remainingTime;

        // 更新已参团人数
        var participants = "<?php echo $participants; ?>";
        document.getElementById("participants").innerHTML = participants;
    }
    setInterval(updateCountdown, 1000);
</script>

The above is a detailed introduction to the mall group purchasing function developed using PHP. By realizing the display of group purchase products, group participation and withdrawal, purchase and payment, and group purchase status updates, we can introduce powerful group purchase functions into the mall to improve user experience and sales. Hope this article is helpful to you.

The above is the detailed content of Detailed introduction to the mall group purchasing function developed using PHP. For more information, please follow other related articles on the PHP Chinese website!