How to use PHP to implement the task feedback function of WeChat applet?

How to use PHP to implement the task feedback function of WeChat applet?

As a convenient mobile application, WeChat mini program is increasingly popular among developers and users. In the process of developing WeChat mini programs, task feedback function is one of the very common requirements. This article will introduce how to use PHP language to implement the task feedback function of WeChat applet and provide specific code examples.

1. Preparation

Before starting, we need to ensure that the following prerequisites are met:

1. Have obtained a developer account for the WeChat applet, And created a mini program;
2. The server domain name of the WeChat mini program has been configured;
3. The PHP environment has been installed and the corresponding operating environment has been configured.

2. Create a task feedback form

The core of the task feedback function is to save the user's feedback information into the database. First, we need to create a task feedback form to store this data. You can use the following SQL statement to create a table named task_feedback in the MySQL database:

CREATE TABLE `task_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

The table contains the following fields:

• id: the ID that uniquely identifies each piece of feedback information ;
• task_id: the task ID corresponding to the feedback;
• user_id: the user ID of the feedback;
• content: the content of the feedback;
• created_at: the feedback creation time.

3. Write the back-end PHP code

Next, we will write a PHP file to process the feedback data sent by the WeChat applet and store it in the database.

1. Create the feedback.php file and add the following code:

<?php
// 解析JSON数据
$postData = json_decode(file_get_contents('php://input'), true);

// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 插入反馈数据
$stmt = $conn->prepare("INSERT INTO task_feedback (task_id, user_id, content) VALUES (?, ?, ?)");
$stmt->bind_param("iis", $taskId, $userId, $content);

$taskId = $postData['taskId'];
$userId = $postData['userId'];
$content = $postData['content'];

if ($stmt->execute()) {
    $response = array('success' => true, 'message' => '反馈成功');
} else {
    $response = array('success' => false, 'message' => '反馈失败');
}

// 返回JSON响应
header('Content-Type: application/json');
echo json_encode($response);

$stmt->close();
$conn->close();
?>

2. Replace "your_username", "your_password" and "your_database" in the code with your database connection information.
3. Save the feedback.php file and upload it to your server.

4. Call the backend interface

In the WeChat applet, we can use the wx.request function to send feedback data to the backend interface. Here is a sample code:

wx.request({
  url: 'https://your_domain/feedback.php',
  method: 'POST',
  data: {
    taskId: 1,
    userId: 123,
    content: '这是一个任务反馈'
  },
  success: function(res) {
    console.log(res.data);
  },
  fail: function(res) {
    console.log('请求失败');
  }
})

Replace "your_domain" in the code with your server domain name.

So far, we have completed the task feedback function of WeChat applet using PHP. When a user submits feedback, the WeChat applet will send the relevant data to the back-end PHP interface, and the data will be stored in the PHP code. In this way, we can easily manage and process task feedback from users.

I hope the content of this article will be helpful to you!

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