Untitled

<!doctype html>
<html>
<head>
    <meta charset="utf-8">
    <title>Opdracht 2</title>
</head>

<body>
<?php
$dbhost = "localhost";
$dbuser = "root";
$password = "";
$dbname = "lessenphp";

$connect = new mysqli($dbhost, $dbuser, $password, $dbname);

if ($connect->connect_error) {
    die("Connection failed: " . $connect->connect_error);
}

echo "Connected successfully";

if (isset($_POST['submit'])) {
    $vak = $_POST['vak'];
    $docent = $_POST['docent'];
    $periode = $_POST['periode'];
    $cijfer = $_POST['cijfer'];
    $query = "INSERT INTO rapporten('Vak', 'Docent', 'Cijfer', 'Periode') VALUES('$vak', '$docent', '$periode', '$cijfer')";
    mysqli_query($connect, $query);
}
?>

<form method="post">
        <table>
                <tr><td>Vak:</td>
                        <td><input type="text" name="vak"></td></tr>

                <tr><td>Docent:</td>
                        <td><input type="text" name="docent"></td></tr>

                <tr><td>Periode:</td>
                        <td><input type="text" name="periode"></td></tr>

                <tr><td>Cijfer:</td>
                        <td><input type="text" name="cijfer"></td></tr>

                <tr><td><input type="submit" name="submit" value="Verzenden"></td></tr>
            </table>
</form>

</body>
</html>