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";
	?>

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

	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>