How to use PHP to develop the task evaluation function of WeChat applet?

How to use PHP to develop the task evaluation function of WeChat applet?

In today’s Internet era, task evaluation is a very important functional module in WeChat mini programs. Through task evaluation, users can evaluate completed tasks and provide references and choices for other users. When developing the task evaluation function of WeChat applet, using PHP is a very common and practical development language. This article will introduce how to use PHP to develop the task evaluation function of WeChat applet and provide specific code examples.

First of all, we need to clarify the basic elements of task evaluation. A task evaluation usually includes the following information:

1. Task ID: Each task has a unique ID, which is used to identify the uniqueness of the task.
2. User ID: The unique ID of the user who evaluated the task.
3. Rating: The rating of the task can generally be from 1 to 5 stars.
4. Comments: Text comments on the task, which can be the user's specific description or feelings about the task.

Next, we can use PHP to implement related operations of the task evaluation function. First, we need to create a table in the database to store task evaluations. A table named "task_evaluation" can be created according to the following structure:

CREATE TABLE `task_evaluation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

After the user completes the task, we need to develop a task evaluation page on the mini program client, where the user can evaluate the task. evaluate. When the user submits an evaluation, we can send the evaluation data to the server through the API of the mini program. The following is an example of PHP code for submitting task evaluation:

<?php
// 接收评价数据
$task_id = $_POST['task_id'];
$user_id = $_POST['user_id'];
$rating = $_POST['rating'];
$comment = $_POST['comment'];

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

// 插入评价数据到数据库
$sql = "INSERT INTO task_evaluation (task_id, user_id, rating, comment)
        VALUES ('$task_id', '$user_id', '$rating', '$comment')";
if ($conn->query($sql) === TRUE) {
  echo "评价提交成功";
} else {
  echo "评价提交失败: " . $conn->error;
}

$conn->close();
?>

In the above code, the evaluation data passed from the applet client is first obtained through $_POST. Then, connect to the database through the mysqli class, and use the INSERT INTO statement to insert the evaluation data into the database table.

Since the comment function generally needs to be displayed on the task details page of the mini program, we also need to develop an interface for obtaining task evaluation based on the task ID. The following is an example of PHP code used to obtain task evaluation:

<?php
// 查询评价数据
$task_id = $_GET['task_id'];

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

// 查询评价数据
$sql = "SELECT * FROM task_evaluation WHERE task_id = '$task_id'";
$result = $conn->query($sql);

// 将评价数据转换为JSON格式，并输出给小程序客户端
$evaluations = array();
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    $evaluation = array(
      'id' => $row['id'],
      'task_id' => $row['task_id'],
      'user_id' => $row['user_id'],
      'rating' => $row['rating'],
      'comment' => $row['comment']
    );
    array_push($evaluations, $evaluation);
  }
}
echo json_encode($evaluations);

$conn->close();
?>

In the above code, first obtain the task ID passed from the applet client through $_GET. Then, connect to the database through the mysqli class, and use the SELECT statement to query the evaluation data of the specified task ID. Finally, convert the evaluation data into JSON format and use the json_encode function to output it to the mini program client.

Through the above sample code, we can implement the task evaluation function of the WeChat applet. When the user completes the task and submits a review, the review data will be saved to the database. Through the interface for obtaining the task ID, the relevant evaluation data can be displayed on the task details page to provide reference and choice for other users.

In summary, PHP’s simplicity and practicality make it an ideal choice for developing WeChat mini program task evaluation functions. By using PHP's database operation function, we can easily implement task evaluation-related operations and data storage. I hope the sample code in this article can be helpful to your WeChat applet development work.

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