php - 表格中的值没有被添加到数据库中

Question

我正在尝试将值输入到名为“测验”的数据库中，其中包含行“ID、名称、问题、答案、用户答案”但是，我似乎无法将值输入到表中。有人可以看看我的代码并指导我哪里出错了。我只是一个初学者，对 PHP 和 mySQL 不太熟悉。

    <form method = "post" action = "create.php">
        <div = "input-group">
            <label for = "name"> Quiz Name: </label>
            <input type = "text" id = "name" name = "name" value = "<?php echo $name; ?>" onsubmit = "return validateform()"></input>

            <label for = "question"> Question: </label>
            <input type = "text" id = "question" name = "question" value = "<?php echo $question; ?>"></input>

            <label for = "answer"> Answer: </label>
            <input type = "text" id = "answer" name = "answer" value = "<?php echo $answer;?>"></input>

            <input type = "submit" class = "btn" name = "quiz"</input>
        </div>
    </form>

上面的代码是通过 PHP 文件传递​​的表单。

<?php

    if(isset($_POST['quiz'])) {

        $name = $_POST['name'];
        $question = $_POST['question'];
        $answer = $_POST['answer'];


        $db = mysqli_connect('host', 'username', 'password', 'database') or die('Error connecting to MySQL server')
            $query = "INSERT INTO Quiz(name, question, answer) VALUES('$name', '$question', '$answer')";
            $result = mysqli_query($db, $query) or die('Error querying database.');
            mysqli_close($db);
        echo "1 record added";
    };
?>

上面的代码是到我的数据库的连接，如果有效，将用于添加值。

标签： phpmysqldatabase