How to use PHP to develop the exercise class booking function of WeChat applet?

How to use PHP to develop the exercise class booking function of WeChat applet?

With the improvement of health awareness and the rise of exercise craze, more and more people are beginning to participate in various exercise classes. In order to facilitate users to book exercise courses, we can use PHP to develop a WeChat applet with an exercise course booking function. How to achieve this is explained in detail below.

1. Create database and related tables
   First, we need to create a database to store the user's reservation information. You can use MySQL or other database management systems to create a database and create a table named "courses" to store sports course information, including course ID, course name, coach, course time, remaining quota and other fields. In addition, you need to create a table named "orders" to store the user's booking information, including order ID, user ID, course ID, booking time and other fields.
2. Connecting to the database
   In the PHP code, we need to use extensions such as mysqli or PDO to connect to the database and obtain the database connection object. You can define the database connection information as constants or configuration files, and call the connection function to obtain the connection object where you need to connect to the database.
3. Get the list of exercise courses
   In the WeChat applet page, we need to display the list of bookable exercise courses for users to choose from. In the PHP code, we can use the SELECT statement to obtain course information from the "courses" table, and then return the results to the mini program front end. You can use the fetch(PDO::FETCH_ASSOC) method to convert the result set into an associative array, and convert the array into JSON format and return it to the applet.
4. User Booking Courses
   After the user selects the course to be booked, we need to save the booking information to the database. On the front end of the mini program, when the user clicks the reservation button, a request can be sent to the background PHP interface, passing parameters such as user ID and course ID. In the PHP code, we first need to verify the validity of the user ID and course ID, and then insert the reservation information into the "orders" table through the INSERT INTO statement. At the same time, the remaining quota fields in the "courses" table also need to be updated. If the reservation is successful, a success prompt will be returned to the mini program front end.

The following is a code example to implement the booking function:

// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "test";
$conn = new mysqli($servername, $username, $password, $dbname);

// 获取运动课程列表
$sql = "SELECT * FROM courses";
$result = $conn->query($sql);
$courses = array();
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    $courses[] = $row;
  }
}

// 用户预订课程
$userID = $_POST['userID'];
$courseID = $_POST['courseID'];

// 验证用户ID和课程ID的有效性，此处省略验证逻辑
// ...

// 将预订信息插入到数据库
$sql = "INSERT INTO orders (userID, courseID, orderTime) VALUES ('$userID', '$courseID', NOW())";
if ($conn->query($sql) === TRUE) {
  // 更新"courses"表格中的剩余名额字段
  $sql = "UPDATE courses SET remaining_slots = remaining_slots - 1 WHERE courseID = '$courseID'";
  $conn->query($sql);

  echo "预订成功！";
} else {
  echo "预订失败！";
}

// 关闭数据库连接
$conn->close();

Through the above steps, we can implement the exercise class booking function of the WeChat applet. When the user chooses to book a course, the booking information will be saved in the database and the remaining quota field of the corresponding course will be updated. In this way, we can easily manage users' exercise class reservations.

The above is the detailed content of How to use PHP to develop the exercise class booking function of WeChat applet?. For more information, please follow other related articles on the PHP Chinese website!