How to use PHP to develop the online questionnaire function of WeChat applet?

How to use PHP to develop the online questionnaire function of WeChat mini program?

WeChat Mini Program is a very popular mobile application that many businesses and individuals use to develop their own applications. One of the commonly used features is online questionnaires. In this article, I will introduce in detail how to use PHP to develop the online questionnaire function of the WeChat applet and provide some specific code examples for reference.

First, we need to set up a PHP development environment. You can choose to use tools such as XAMPP, WAMP or LAMP. These tools can install Apache, MySQL and PHP at one time, which is very convenient.

Next, we need to create a database to store the questionnaire data. You can use MySQL or other relational databases. Suppose we have created a database named "questionnaire" and created a data table named "questions" in it to store the questions and options of the questionnaire.

The structure of the data table is as follows:

CREATE TABLE `questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `options` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Next, we need to create a page in the WeChat applet to display the questionnaire. In the mini program page, we can use the wx.request function to send a request to the PHP server to obtain the questions and options of the questionnaire. The following is a simple code example:

Page({
  data: {
    questions: []
  },
  onLoad: function () {
    var that = this;
    wx.request({
      url: 'https://your-domain.com/questions.php',
      method: 'GET',
      success: function(res) {
        that.setData({
          questions: res.data
        });
      }
    });
  }
})

In the above code, the we.request function sends a GET request to the PHP file named "questions.php", which is responsible for obtaining the questions and options of the questionnaire , and return it to the applet.

Next, we need to write the "questions.php" file to handle the mini program's request. Here is a simple code example:

<?php
// 连接到数据库
$servername = "localhost";
$username = "your-username";
$password = "your-password";
$dbname = "questionnaire";

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

// 查询问题和选项
$sql = "SELECT * FROM questions";
$result = $conn->query($sql);

// 将结果转换为JSON格式并返回给小程序
$questions = array();
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    $questions[] = $row;
  }
}
echo json_encode($questions);

// 关闭数据库连接
$conn->close();
?>

In the above code, we first connect to the database and then query the "questions" table for questions and options. The query results are converted into JSON format and returned to the applet.

Finally, we need to add some code to the mini program to handle the user's operations on the questionnaire, such as selecting answers, submitting questionnaires, etc. The following is a simple code example:

// 处理用户选择答案的函数
selectOption: function(e) {
  var index = e.currentTarget.dataset.index;
  var optionIndex = e.currentTarget.dataset.optionIndex;
  
  var questions = this.data.questions;
  questions[index].selected = optionIndex;
  
  this.setData({
    questions: questions
  });
},

// 处理用户提交问卷的函数
submitQuestionnaire: function() {
  // TODO: 将答案提交到服务器
}

In the above code, the selectOption function is used to process the user's operation of selecting answers, and the submitQuestionnaire function is used to process the user's operation of submitting a questionnaire. It should be noted that we also need to submit the answers selected by the user to the server for saving and processing.

To sum up, we can realize the online questionnaire function of the WeChat mini program by building a PHP development environment, creating a database, and writing mini program pages and PHP files. Of course, this is just a simple example, and more details and business logic need to be considered in actual development. Hope this article helps you!

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