WEBB

<!DOCTYPE html>
    <html>
        <head>
            <title>PHP Form</title>
            <style>
                body
                {
                    font-family: Verdana;
                    font-size: 16px;
                }
            </style>
        </head>
    <body>
    <h1>Auto</h1>
        <form action="index2.php" method="POST">
            <table>
            <tr>
                <td> Merk:</td>
                <td><input type="text" name="merk"></td>
            </tr>
            <tr>
                <td> Type:</td>
                <td><input type="text" name="type"></td>
            </tr>
            <tr>
                <td> Bouwjaar:</td>
                <td><input type="date" name="bouwjaar"></td>
            </tr>
            <tr>
                <td> Nummerbord:</td>
                <td><input type="text" name="nummerbord" required></td>
            </tr>
            <tr>
                <td><input type="submit" value="Verzend" value="submit"></td>
                <td><input type="reset" value="Leeg maken"></td>
            </tr>
            </table>

</form>
        </form>
    </body>
</html>
========================================================================================
<?php
            echo "<h3> Je hebt de volgende gegevens ingevuld</h3>";

            echo "Auto merk: ".$_POST ["merk"]."<br>"."Type:".$_POST["type"]."<br>"."Het bouwjaar :"." ".$_POST ["bouwjaar"]."<br>"."Het nummerbord :"." ".$_POST ["nummerbord"].
           "<br>";
echo "<hr>";

                echo "gegevens die naar database gaan : ". "<br>"."<br>";
                $servername = "localhost";
                $username = "root";
                $password = "";
                $dbname = "toets-1";


                $conn = mysqli_connect($servername, $username, $password, $dbname);
                $sql = "INSERT INTO `auto` (`id`,
                                            `merk`,
                                            `type`,
                                            `bouwjaar`,
                                            `nummerbord`)
                                VALUES          (NULL,
                                                '".$_POST["merk"]."',
                                                '".$_POST["type"]."',
                                                '".$_POST["bouwjaar"]."',
                                                '".$_POST["nummerbord"]."')";
echo"$sql";
                mysqli_query($conn, $sql) or die("queryfout");

echo "Gegevens in de database";
              $sql = "SELECT * FROM auto";
                $result = mysqli_query($conn, $sql);


                if (mysqli_num_rows($result) > 0) {

    while($row = mysqli_fetch_assoc($result)) {
        echo "<table>"."<tr>"."<td>". "id: " . $row["id"]. "</td>". "<td>". " - <b>Merk:</b>: " . $row["merk"]. "</td>".
        "<td>". "<b>Type:</b>" . "  ". $row["type"]. "</td>".
         "<td>". "<b>Bouw jaar:</b> " . "  ". $row["bouwjaar"]. "</td>".
          "<td>". "<b>Kenteken:</b> " . "  ". $row["nummerbord"]. "</td>"."</tr>"."</table>"."<br>";
    }
} else {
    echo "0 results";
}
mysqli_close($conn);
?>