How to use PHP to develop simple online exam and score query functions-PHP Tutorial-php.cn

How to use PHP to develop simple online exam and score query functions

PHPz

Release： 2023-09-21 16:22:01

Original

1745 people have browsed it

How to use PHP to develop simple online exam and score query functions

How to use PHP to develop simple online examination and score query functions
With the popularization of the Internet, more and more educational institutions have begun to use online platforms to conduct online education and examinations. This provides convenience to students and teachers. In order to meet the needs of educational institutions, this article will introduce how to use PHP to develop a simple online examination and score query function, and provide specific code examples.

Database design
First, we need to design a database to store exam-related information. The database table can include the following fields: student ID, student name, test subjects, test scores, etc. You can use a MySQL database and create a database called 'exam' that contains a table called 'students'.
Create exam page
Next, we need to create an exam page. The page should display the exam questions and options and provide a submit button. After the user selects an answer, click the submit button to save the answer to the database.

<html>
<head>
    <title>在线考试</title>
</head>
<body>
    <h1>在线考试</h1>
    <form action="submit_exam.php" method="post">
        <p>问题1: ...</p>
        <input type="radio" name="answer1" value="A"> A<br>
        <input type="radio" name="answer1" value="B"> B<br>
        <input type="radio" name="answer1" value="C"> C<br>
        <input type="radio" name="answer1" value="D"> D<br><br>

        <p>问题2: ...</p>
        <input type="radio" name="answer2" value="A"> A<br>
        <input type="radio" name="answer2" value="B"> B<br>
        <input type="radio" name="answer2" value="C"> C<br>
        <input type="radio" name="answer2" value="D"> D<br><br>

        ...

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

Copy after login

Handling exam submission
When the user submits the exam, we need to save the answers to the database. Create a file called 'submit_exam.php' to save user answers to the database. And display the exam end prompt message.

<?php
    $conn = mysqli_connect("localhost", "root", "", "exam"); // 连接数据库
    if ($conn->connect_error) {
        die("连接失败：".$conn->connect_error);
    }

    $answer1 = $_POST['answer1'];
    $answer2 = $_POST['answer2'];
    ...

    $sql = "INSERT INTO students (answer1, answer2, ...) VALUES ('$answer1', '$answer2', ...)";
    if ($conn->query($sql) === TRUE) {
        echo "提交成功";
    } else {
        echo "提交失败：" . $conn->error;
    }

    $conn->close();
?>

Copy after login

Create a score query page
In addition to the exam page, we also need to create a score query page. This page requires the user to enter a student ID and displays the student's test scores.

<html>
<head>
    <title>成绩查询</title>
</head>
<body>
    <h1>成绩查询</h1>
    <form action="query_score.php" method="post">
        <label for="studentID">学生ID:</label>
        <input type="text" id="studentID" name="studentID"><br><br>
        <input type="submit" value="查询">
    </form>
</body>
</html>

Copy after login

Processing score query requests
When the user submits the student ID, we need to query the database and display the student's test scores. Create a file called 'query_score.php' and query the database based on the student ID entered by the user.

<?php
    $conn = mysqli_connect("localhost", "root", "", "exam"); // 连接数据库
    if ($conn->connect_error) {
        die("连接失败：".$conn->connect_error);
    }

    $studentID = $_POST['studentID'];

    $sql = "SELECT * FROM students WHERE studentID = '$studentID'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            echo "学生ID: " . $row["studentID"]. " - 学生姓名: " . $row["studentName"]. " - 考试科目: " . $row["subject"]. " - 考试成绩: " . $row["score"]. "<br>";
        }
    } else {
        echo "该学生不存在";
    }

    $conn->close();
?>

Copy after login

Through the above steps, we have implemented a simple online exam and score query function. Using PHP programming language and database operation, we can easily conduct online exams and query students' exam results through student IDs. This provides convenience to educational institutions and provides students with flexible learning pathways.

The above is the detailed content of How to use PHP to develop simple online exam and score query functions. For more information, please follow other related articles on the PHP Chinese website!