How to use PHP to develop the group purchasing function of WeChat mini program?

How to use PHP to develop the group purchasing function of WeChat mini program?

With the rapid development of WeChat mini programs, group buying has become an important way for many merchants to attract consumers. For programmers who develop group buying functions, how to use PHP to implement this function is a key issue. This article will introduce how to use PHP to develop the group purchasing function of WeChat mini program and provide specific code examples.

1. Create database table
   Create the following table in the MySQL database to store group buying products and order information.

Group purchase product table (group_buy_goods):

##Field nameTypeDescriptionidint(11)Product IDnamevarchar(100)Product namepricedecimal(10,2) Product pricequantityint(11)Quantity of itemsstart_atdatetimeGroup purchase start timeend_atdatetimeGroup purchase end timecreated_at datetimeCreation timeupdated_atdatetimeUpdate timeGroup purchase order table (group_buy_order):

Field nameTypeDescriptionidint(11)Order IDgoods_idint(11) Product IDuser_idint(11)User IDquantity#int(11)Quantity of goods##total##created_atdatetimeOrder creation timeWrite the group purchase product list interface

decimal(10,2 )	Total order price

In the PHP code, write the interface for obtaining the group purchase product list. The specific code examples are as follows:

2. <?php
   // 连接数据库
   $conn = mysqli_connect("localhost", "root", "", "your_database_name");
   if (!$conn) {
       die("数据库连接失败: " . mysqli_connect_error());
   }
   
   // 获取团购商品列表
   $sql = "SELECT * FROM group_buy_goods";
   $result = mysqli_query($conn, $sql);
   
   $goodsList = [];
   if (mysqli_num_rows($result) > 0) {
       while ($row = mysqli_fetch_assoc($result)) {
           $goodsList[] = $row;
       }
   }
   
   // 输出结果
   header('Content-Type: application/json');
   echo json_encode($goodsList);
   ?>

   Copy after login
   
   
Writing the order interface

In the PHP code, write the interface for ordering. Specific code examples are as follows:

3. <?php
   // 连接数据库
   $conn = mysqli_connect("localhost", "root", "", "your_database_name");
   if (!$conn) {
       die("数据库连接失败: " . mysqli_connect_error());
   }
   
   // 获取用户ID和商品ID
   $userId = $_POST['userId'];
   $goodsId = $_POST['goodsId'];
   
   // 获取商品信息
   $sql = "SELECT * FROM group_buy_goods WHERE id = '$goodsId'";
   $result = mysqli_query($conn, $sql);
   $goods = mysqli_fetch_assoc($result);
   
   if ($goods) {
       // 检查商品库存是否充足
       if ($goods['quantity'] > 0) {
           // 生成订单
           $quantity = 1;
           $total = $goods['price'] * $quantity;
   
           $sql = "INSERT INTO group_buy_order (goods_id, user_id, quantity, total, created_at) VALUES ('$goodsId', '$userId', '$quantity', '$total', NOW())";
           if (mysqli_query($conn, $sql)) {
               // 更新商品库存
               $sql = "UPDATE group_buy_goods SET quantity = quantity - 1 WHERE id = '$goodsId'";
               mysqli_query($conn, $sql);
   
               echo "下单成功";
           } else {
               echo "下单失败";
           }
       } else {
           echo "商品库存不足";
       }
   } else {
       echo "商品不存在";
   }
   ?>

   Copy after login
   
   
Mini Program Calling Interface

In the WeChat applet, by calling the group purchasing product list interface and ordering interface, the functions of displaying group purchasing products and placing orders are realized . The specific code examples are as follows:

4. // 获取团购商品列表
   wx.request({
     url: 'https://your_domain/get_goods_list.php',
     success: function(res) {
       var goodsList = res.data;
       console.log(goodsList);
       // 在页面中展示团购商品
     }
   });
   
   // 下单
   wx.request({
     url: 'https://your_domain/place_order.php',
     method: 'POST',
     data: {
       userId: 'your_user_id',
       goodsId: 'your_goods_id'
     },
     success: function(res) {
       console.log(res.data);
       // 下单成功提示
     }
   });

   Copy after login
   
   The above are the steps and code examples for using PHP to develop the group purchasing function of the WeChat applet. Through this method, developers can easily implement group buying functions and attract more users to participate in group buying activities. Of course, the above examples are simplified examples, and some security and performance optimization issues need to be considered in actual development. Hope this article is helpful to you!

The above is the detailed content of How to use PHP to develop the group purchasing function of WeChat mini program?. For more information, please follow other related articles on the PHP Chinese website!