How to write a simple online questionnaire system through PHP-PHP Tutorial-php.cn

How to write a simple online questionnaire system through PHP

王林

Release： 2023-09-28 09:18:01

Original

1439 people have browsed it

How to write a simple online questionnaire system through PHP

Introduction:
Online questionnaire system plays an important role in modern data collection and market research character of. In this article, we will learn how to write a simple online questionnaire system using PHP to collect user feedback and data. We will involve the creation and design of the database, the design of the front-end interface, and the writing of back-end PHP code. let's start!

Step One: Database Design
First, we need to create a database to store the data of the questionnaire system. We can use MySQL as the database management system. The following is a simple database design example:

Create a database named "surveys"
Create a table named "questions" in the "surveys" database, using Data for storage issues. The table can contain fields: id, question, type, etc.
Create a table named "answers" in the "surveys" database to store the user's answer data. The table can contain fields: id, question_id, answer, etc.

Step 2: Front-end interface design
Next, we need to design a user-friendly front-end interface to display questions and collect User's answer. We can use HTML and CSS to create the front-end interface. The following is a simple sample code:

<!DOCTYPE html>
<html>
<head>
    <title>调查问卷系统</title>
    <style>
        .question {
            margin-bottom: 10px;
        }

        .submit-btn {
            margin-top: 10px;
        }
    </style>
</head>
<body>
    <h1>调查问卷</h1>

    <form action="submit.php" method="post">
        <?php
        // 根据数据库中的问题数据，动态生成问题列表
        $questions = [
            [
                'id' => 1,
                'question' => '您对公司的产品是否满意？',
                'type' => '单选',
                'options' => ['非常满意', '满意', '一般', '不满意']
            ],
            [
                'id' => 2,
                'question' => '您的年龄段是？',
                'type' => '单选',
                'options' => ['18-25岁', '26-35岁', '36-45岁', '45岁以上']
            ],
            // 添加更多的问题...
        ];

        foreach ($questions as $question) {
            echo '<div class="question">';
            echo '<label for="question-' . $question['id'] . '">' . $question['question'] . '</label><br>';

            if ($question['type'] === '单选') {
                foreach ($question['options'] as $option) {
                    echo '<input type="radio" name="question-' . $question['id'] . '" value="' . $option . '"> ' . $option . '<br>';
                }
            } elseif ($question['type'] === '多选') {
                foreach ($question['options'] as $option) {
                    echo '<input type="checkbox" name="question-' . $question['id'] . '[]" value="' . $option . '"> ' . $option . '<br>';
                }
            } elseif ($question['type'] === '文本') {
                echo '<textarea name="question-' . $question['id'] . '"></textarea>';
            }

            echo '</div>';
        }
        ?>

        <input type="submit" class="submit-btn" value="提交">
    </form>
</body>
</html>

Copy after login

Step 3: Back-end code writing
Finally, we need to write PHP code to process the data submitted by the front-end interface and save the data to the database. The following is a simple sample code:

<?php
// 获取问题和答案数据
$questions = [
    ['id' => 1, 'question' => '您对公司的产品是否满意？'],
    ['id' => 2, 'question' => '您的年龄段是？'],
    // 添加更多的问题...
];

// 创建一个名为“surveys”的数据库连接
$servername = 'localhost';
$username = 'root';
$password = '';
$dbname = 'surveys';

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

// 检查数据库连接是否成功
if ($conn->connect_error) {
    die('数据库连接失败：' . $conn->connect_error);
}

// 处理提交的表单数据
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    foreach ($questions as $question) {
        $questionId = $question['id'];
        $answer = isset($_POST['question-' . $questionId]) ? $_POST['question-' . $questionId] : '';

        // 将答案保存到数据库中的“answers”表
        $sql = "INSERT INTO answers (question_id, answer) VALUES ('$questionId', '$answer')";

        if ($conn->query($sql) !== TRUE) {
            echo '保存数据时出错：' . $conn->error;
        }
    }
}

$conn->close();
?>

Copy after login

Summary:
Through the above steps, we have learned how to use PHP to write a simple online questionnaire system. Use a database to store question and answer data, design a user-friendly front-end interface to display questions and collect answers, and use PHP code to process user-submitted data and save it to the database. I hope this article is helpful to you, and I wish you a successful online questionnaire system!

The above is the detailed content of How to write a simple online questionnaire system through PHP. For more information, please follow other related articles on the PHP Chinese website!