PHP WeChat development: How to implement voting function

In the development of WeChat public accounts, the voting function is often used. The voting function is a great way for users to quickly participate in interactions, and it is also an important tool for holding events and surveying opinions. This article will introduce you how to use PHP to implement WeChat voting function.

1. Obtain WeChat official account authorization

First, you need to obtain WeChat official account authorization. On the WeChat public platform, you need to configure the API address of the WeChat public account, the official account, and the token corresponding to the public account. In the process of our development using PHP language, we need to use the PHP SDK officially provided by WeChat for development.

2. Obtaining user information from the WeChat server

Obtaining user information is a prerequisite for implementing the voting function. In the development of WeChat public accounts, we need to obtain user information from the WeChat server. Before obtaining user information, we need to obtain the openid of the WeChat user. In the process of obtaining the user's openid, we need to authorize the user by scanning the QR code on the WeChat client. The operation of scanning the QR code can be implemented in the WeChat SDK through the following methods:

//引入微信php-sdk
include_once("./wechat-php-sdk/wechat.class.php");
//实例化微信类
$options = array(
        'token'=>'your_token', //填写你设定的微信公众平台Token
        'appid'=>'your_appid', //填写高级调用功能的app id
        'appsecret'=>'your_appsecret' //填写高级调用功能的密钥
);
$wechatObj = new Wechat($options);
//获得网页授权的access_token
$auth_info = $wechatObj->getOauthAccessToken();
//获取用户openid
$openid = $auth_info['openid'];

We can obtain the user's basic information by calling the API of the WeChat public platform, including the user's nickname, gender and other information. For specific operation methods, please refer to the API documentation provided by the WeChat public platform. When the user authorizes, we can obtain the user's openid as the user's unique identifier.

3. Implementing the voting function

Implementing the voting function requires us to create a new voting page during development. We need to add voting options and statistical functions to the new page, and save the user's voting records in the database.

3.1 Create the front page

Before creating the voting page, we need to do the page layout and design first. When designing the page, we need to take into account features such as unlimited number of votes and convenient backend management. In the front-end page design, we can set the style of voting options and the number of voting options. At the same time, the page design should also take into account responsive layout to adapt to different sizes of device screens.

3.2 Add voting options

In order to add voting options to the voting page, we need to use PHP language and MySQL database for development. We need to create a data table named "vote_option" to store the name, number and number of votes for each option. During page creation, we can obtain option data through loop iteration, thereby realizing the function of dynamically adding voting options.

//查询当前所有选项
$sql = "SELECT * FROM `vote_option`";
$res = mysqli_query($con, $sql) or die(mysqli_error($con));
if ($res && mysqli_num_rows($res) > 0) {
    while ($data = mysqli_fetch_assoc($res)) {
        echo "<li>";
        echo    "<span class='option-name'>".$data["name"]."</span>";
        echo    "<span class='option-num'>投票数:".$data["num"]."</span>";
        echo    "<input type='radio' name='option' value='".$data["id"]."' />";
        echo "</li>";
    }
}

In the code, we query all voting options in the current database through loop iteration, and then add them to the front page.

3.3 Statistics of voting results

After the voting option is added, we need to add the function of counting voting results to the page. There are two main ways to implement statistical voting results. The first is to use AJAX for real-time voting. The second is to use PHP to implement asynchronous processing of voting data, and then update the statistical results on the front page. This article uses the second method. realization.

In the voting page, we need to implement functions such as data update of voting options, update of voting data in the database, and recording of user voting data.

//获取选项编号
$option_id = $_POST["option"];
//查询选项数据
$sql = "SELECT `num` FROM `vote_option` WHERE `id`=".$option_id;
$res = mysqli_query($con, $sql) or die(mysqli_error($con));
if ($res && mysqli_num_rows($res) > 0) {
    $data = mysqli_fetch_assoc($res);
    $vote_num = $data["num"]+1;
}
//更新选项投票数
$sql = "UPDATE `vote_option` SET `num`=".$vote_num." WHERE `id`=".$option_id;
$res = mysqli_query($con, $sql) or die(mysqli_error($con));
//获取用户openid
$openid = $_COOKIE["wx_user_openid"];
//记录用户投票
$sql = "INSERT INTO `vote_log`(`openid`,`option_id`) VALUES ('".$openid."',".$option_id.")";
$res = mysqli_query($con, $sql) or die(mysqli_error($con));

We can send the obtained option number and user openid to our PHP script through AJAX or form submission, and then update the voting option data and record the user voting data.

4. Conclusion

Through the introduction of this article, we have learned to use PHP to implement the WeChat voting function. In the process of implementing the voting function, we need to master how to obtain user information, how to create a voting front page, how to add voting options, and how to count voting results. Proper use of PHP and MySQL database for development can quickly build an efficient and safe WeChat voting function, and provide us with powerful data statistics functions.

The above is the detailed content of PHP WeChat development: How to implement voting function. For more information, please follow other related articles on the PHP Chinese website!