How to use PHP to develop online questionnaire function

How to use PHP to develop online questionnaire function

With the development of the Internet, people need to use it in market research, user satisfaction surveys, academic research and other fields Questionnaire. Online questionnaire surveys have become one of the most popular and convenient methods currently. This article will take the PHP development language as an example to introduce how to use PHP to develop a simple online questionnaire function, and attach a code example.

1. Environment preparation
   First, we need to prepare the required development environment. It is recommended to use the latest PHP version and MySQL database, as well as any web server environment. We assume that you have successfully set up these environments and are able to develop PHP.
2. Database design
   Next, we need to design a database to store questionnaire-related data. We can create a database named "questionnaires" and create a table named "surveys" to store the questionnaire information. The table structure can contain fields as follows:

• id: questionnaire unique identifier, primary key, auto-increment
• title: questionnaire title
• description: questionnaire description
• created_at: Questionnaire creation time
• updated_at: Questionnaire update time

We also need to create a table named "questions" to store the questions of the questionnaire. The table structure can contain fields as follows:

• id: unique identifier of the question, primary key, auto-increment
• survey_id: unique identifier of the questionnaire, foreign key, associated with the "surveys" table
• content: Question content
• type: Question type
• created_at: Question creation time
• updated_at: Question update time

3. Page Design
   Next, we need to design a page to display the questionnaire and the user's answers. We can create a file named "index.php" as the home page, where users can view and fill out the questionnaire.

<?php
// 连接数据库
$conn = new mysqli('localhost', 'username', 'password', 'questionnaires');
if ($conn->connect_error) {
    die("连接数据库失败：" . $conn->connect_error);
}

// 查询问卷
$sql = "SELECT * FROM surveys";
$result = $conn->query($sql);

// 显示问卷
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "<h1 id="row-title">{$row['title']}</h1>";
        echo "<p>{$row['description']}</p>";
        
        // 查询问题
        $questionSql = "SELECT * FROM questions WHERE survey_id = {$row['id']}";
        $questionResult = $conn->query($questionSql);
        
        // 显示问题
        if ($questionResult->num_rows > 0) {
            while ($questionRow = $questionResult->fetch_assoc()) {
                echo "<p>{$questionRow['content']}</p>";
                
                // 根据问题类型显示不同的输入框
                if ($questionRow['type'] == 'text') {
                    echo "<input type='text' name='answer{$questionRow['id']}'><br>";
                } elseif ($questionRow['type'] == 'checkbox') {
                    echo "<input type='checkbox' name='answer{$questionRow['id']}[]' value='Option 1'>选项1<br>";
                    echo "<input type='checkbox' name='answer{$questionRow['id']}[]' value='Option 2'>选项2<br>";
                    echo "<input type='checkbox' name='answer{$questionRow['id']}[]' value='Option 3'>选项3<br>";
                } elseif ($questionRow['type'] == 'radio') {
                    echo "<input type='radio' name='answer{$questionRow['id']}' value='Option 1'>选项1<br>";
                    echo "<input type='radio' name='answer{$questionRow['id']}' value='Option 2'>选项2<br>";
                    echo "<input type='radio' name='answer{$questionRow['id']}' value='Option 3'>选项3<br>";
                }
            }
        }
        
        // 显示提交按钮
        echo "<input type='submit' value='提交'>";
    }
}

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

4. Data processing
   After the user fills out the questionnaire and clicks the submit button, we need to process the user's answers and store them in the database.

<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // 连接数据库
    $conn = new mysqli('localhost', 'username', 'password', 'questionnaires');
    if ($conn->connect_error) {
        die("连接数据库失败：" . $conn->connect_error);
    }
    
    // 处理用户答案
    foreach ($_POST as $key => $value) {
        if (strpos($key, 'answer') === 0) {
            $questionId = substr($key, 6);
            $answer = is_array($value) ? implode(", ", $value) : $value;
            
            $sql = "INSERT INTO answers (question_id, answer) VALUES ($questionId, '$answer')";
            if ($conn->query($sql) !== TRUE) {
                echo "插入答案失败：" . $conn->error;
            }
        }
    }
    
    // 关闭数据库连接
    $conn->close();
}
?>

Through the above code example, we can implement a simple online questionnaire function. When a user visits the homepage, the corresponding questionnaire will be displayed and an input box will be provided for the user to fill in. When a user submits an answer, we store it in the database for subsequent analysis.

Of course, this is just a simple example, we can expand and optimize the code according to actual needs. For example, you can add validation logic to ensure the validity of user input, add multi-language support for questionnaires, etc.

I hope this article can help you understand how to use PHP to develop a simple online questionnaire function. Good luck with your development journey!

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