Home > Article > Backend Development > How to write a simple online questionnaire system through PHP
How to write a simple online questionnaire system through PHP
- 王林Original
- 2023-09-24 10:21:041373browse
How to write a simple online questionnaire system through PHP
With the development and popularization of the Internet, more and more people are beginning to tend to conduct it through the Internet Various surveys and questionnaires. In order to meet this demand, we can write a simple online questionnaire system through PHP language. This article will introduce how to use PHP to implement a basic questionnaire system and provide specific code examples.
- Database design
First of all, we need to design a database to store the relevant data of the questionnaire survey. We can use MySQL database. The designed database tables include three data tables: "questions", "options" and "responses".
a. questions table: used to store information related to all questions, including question ID, question content, etc.
CREATE TABLE questions (
id INT AUTO_INCREMENT PRIMARY KEY, question_text TEXT
);
b. options table: used to store the option content and corresponding question ID of each question.
CREATE TABLE options (
id INT AUTO_INCREMENT PRIMARY KEY, option_text TEXT, question_id INT
);
c. responses table: used to store user response results. Including the ID of the answer, the content of the answer, etc.
CREATE TABLE responses (
id INT AUTO_INCREMENT PRIMARY KEY, response_text TEXT, question_id INT
);
- Display questionnaire page
Write a page through PHP to display the questionnaire. Users can display the questionnaire on the page Answer the questions and submit your results. The following is a simple sample code:
<!DOCTYPE html>
<html>
<head>
<title>问卷调查</title>
</head>
<body>
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 获取问题列表
$query = "SELECT * FROM questions";
$result = mysqli_query($conn, $query);
// 显示问题列表
while ($row = mysqli_fetch_assoc($result)) {
echo "<h2>".$row['question_text']."</h2>";
echo "<ul>";
// 获取问题的选项
$query = "SELECT * FROM options WHERE question_id=".$row['id'];
$options_result = mysqli_query($conn, $query);
// 显示问题的选项
while ($option_row = mysqli_fetch_assoc($options_result)) {
echo "<li><input type='radio' name='option' value='".$option_row['id']."'/>".$option_row['option_text']."</li>";
}
echo "</ul>";
}
// 关闭数据库连接
mysqli_close($conn);
?>
<button type="submit" name="submit">提交</button>
</body>
</html>In the above sample code, we first connect to the database and obtain the list of questions. Then, get the options for the question via a query and display the question and its options on the page. Finally, we provide a submit button for users to submit answers.
- Processing the results submitted by the user
When the user clicks the submit button, we need to process the results submitted by the user and save them to the database. Here is a simple sample code:
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 检查是否有用户提交的结果
if (isset($_POST['submit'])) {
// 获取用户选择的选项ID
$option_id = $_POST['option'];
// 将用户的回答存储到数据库中
$query = "INSERT INTO responses (response_text, question_id) VALUES ('$option_id', 'question_id_value')";
mysqli_query($conn, $query);
echo "谢谢你的参与！";
}
// 关闭数据库连接
mysqli_close($conn);
?>In the above sample code, we first check whether there are user-submitted results. If there is, we get the option ID selected by the user and store it in the database.
Through the above steps, we can write a simple online questionnaire system through PHP. Of course, this is just a basic example and you can modify and extend it appropriately according to your needs. Hope this article is helpful to you!
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!