How to implement a reservation system on WeChat public account using PHP

How to use PHP to implement a reservation system on WeChat public accounts

With the popularity and use of WeChat public accounts, more and more companies and individuals are beginning to use WeChat We use public accounts to develop business and provide services. Among them, the appointment system is one of the necessary functions for many enterprises and service providers. This article will introduce how to use PHP language to implement a simple WeChat public account reservation system and provide specific code examples.

1. Overview

The WeChat public account reservation system, as the name suggests, means that users can make reservations, cancel reservations, and query reservations through the WeChat public account. The basic functions of the reservation system include user authentication, reservation submission, reservation inquiry and reservation cancellation, etc. This article will focus on how to implement the appointment submission and query functions on the WeChat official account.

2. Preparation

1. Register a WeChat public platform account and obtain relevant development configuration information, such as AppID, AppSecret, etc.
2. Set up a PHP development environment, such as using XAMPP or WampServer.
3. Open a server with public network access permissions to receive push messages from the WeChat server.

3. Implement the reservation system

1. Configure the server interface

First, configure the developer server address in the public platform. Enter the Developer Center, set the server address to your server address, and fill in the server verification token. After saving and taking effect, your server will be able to receive messages from the WeChat server.

2. Verification interface

In your PHP project, create an interface for receiving and verifying messages from the WeChat server. The code of the verification interface is as follows:

$token = 'your_token'; //Fill in the server verification token configured above
$signature = $_GET['signature '];
$timestamp = $_GET['timestamp'];
$nonce = $_GET['nonce'];
$echoStr = $_GET['echostr'];

$tmpArr = array($token, $timestamp, $nonce);
sort($tmpArr, SORT_STRING);
$tmpStr = implode($tmpArr);
$tmpStr = sha1($tmpStr) ;

if ($tmpStr == $signature) {

echo $echoStr;
exit;

}
?>

The $token variable in the above code needs to be replaced by your public Server verification token set by the platform.

By calling the above interface, after the WeChat public account background verification is successful, we can start to implement the specific reservation function.

3. Implementing reservation submission

After the user clicks the reservation button, we need to implement a function to submit the reservation information and save it to the database. Here is a simple code example:

$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Detect connection
if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}

// Get the appointment information submitted by the user
$appointment = $_POST['appointment'];

//Perform database insert operation
$sql = "INSERT INTO appointments (appointment) VALUES ('$appointment')";

if ($conn->query($sql ) === TRUE) {

echo "预约成功";

} else {

echo "预约失败: " . $conn->error;

}

$conn->close();
?>

The $servername, $username, $password, $dbname and other variables in the above code need to be replaced with your own database configuration information.

4. Realize reservation query

Users can query their reservation information through the WeChat official account. Here is a simple code example:

$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Detect connection
if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}

// Get the user’s openid
$openid = $_POST['openid'];

// Query the user's appointment information in the database
$sql = "SELECT * FROM appointments WHERE openid = '$openid'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
    echo "预约信息：" . $row['appointment'] . "<br>";
}

} else {

echo "未查询到预约信息";

}

$conn->close( );
?>

The $servername, $username, $password, $dbname and other variables in the above code need to be replaced with your own database configuration information.

4. Summary

This article introduces how to use PHP language to implement the reservation system on the WeChat official account. We configured the server interface, verified the validity of the interface, and implemented the functions of appointment submission and query. Through the guidance of this article, I hope readers can implement more complex reservation systems through PHP and provide better services for their own business.

The above is the detailed content of How to implement a reservation system on WeChat public account using PHP. For more information, please follow other related articles on the PHP Chinese website!