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

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

WeChat mini programs have become an important part of people’s lives, and more and more companies and individual developers have begun to develop their own mini programs. Among them, the task statistics function is a function that many small program developers often need to implement. This article will introduce how to use PHP to develop the task statistics function of WeChat applet and provide specific code examples.

Before we start, we need to make sure that we have completed the following steps:

1. Apply for a developer account of the WeChat applet and obtain the AppID and AppSecret of the applet.
2. The function of user login and task information entry has been implemented in the mini program.

Next, let’s introduce the specific development steps.

Step 1: Obtain the user's OpenID

In the task statistics function, we need to obtain the user's OpenID to distinguish the tasks of different users. Obtaining the user's OpenID needs to be performed when the user logs in.

First, we need to add a button to the applet to trigger the user login operation:

<button open-type="getUserInfo" bindgetuserinfo="onGetUserInfo">登录</button>

Then, add the onGetUserInfo function in the Page object to obtain the user's OpenID:

onGetUserInfo: function (res) {
  if (res.detail.userInfo) {
    wx.login({
      success: function (loginRes) {
        if (loginRes.code) {
          wx.request({
            url: 'https://api.weixin.qq.com/sns/jscode2session',
            data: {
              appid: '小程序的AppID',
              secret: '小程序的AppSecret',
              js_code: loginRes.code,
              grant_type: 'authorization_code'
            },
            success: function (res) {
              var openid = res.data.openid;
              // 将openid保存到本地或发送到后台服务器
            }
          });
        }
      }
    });
  }
}

In PHP, we can save the user's OpenID through the interface and database:

<?php
$openid = $_POST['openid']; // 接收前端传递的openid参数

// 将openid保存到数据库
$servername = "localhost";
$username = "用户名";
$password = "密码";
$dbname = "数据库名";

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

$sql = "INSERT INTO users (openid) VALUES ('$openid')";
if ($conn->query($sql) === TRUE) {
  echo "保存成功";
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

Step 2: Statistics of the user's tasks

After the user logs in, we The user's task status can be queried from the database based on the user's OpenID and statistics can be made.

In PHP, you can use the following code to query task information from the database:

<?php
$openid = $_POST['openid']; // 接收前端传递的openid参数

// 查询用户的任务
$servername = "localhost";
$username = "用户名";
$password = "密码";
$dbname = "数据库名";

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

$sql = "SELECT COUNT(*) as count FROM tasks WHERE openid = '$openid'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    $count = $row["count"];
    echo "用户的任务数量：" . $count;
  }
} else {
  echo "用户没有任务";
}

$conn->close();
?>

The above example code is for reference only. Developers can make appropriate adjustments according to their actual needs and database structure. .

Summary:

Through the above steps, we can use PHP to develop the task statistics function of the WeChat applet. First, we get the user's OpenID and save it to the database. Then, query the user's task status from the database based on OpenID and perform statistics. Developers can make appropriate modifications and extensions to the code according to their actual needs to achieve more flexible and powerful task statistics functions.

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