<?php
    function adduser() {
        $html_content = "<h1 align='center'>Hier was iets, maar het is weg. Probeer in te loggen om deze pagina te bereiken. Of blijf bij deze blije hond.</h1>";
        $html_content .= "<center><img src='https://i.imgur.com/Y97zXvo.jpg' width='250px'></center>";

        if ($_SESSION["logged_in"]){
            $html_content = "<div id=\"user_add_form\"><form method='post'>";
            $html_content .= "<h2>Voeg een gebruiker toe:</h2>";

            $html_content .= "
            <table border=1>
            <tr><td width=150px;>Naam:</td><td><input type=\"text\" name=\"naam\" class='inputfield'></td></tr>
            <tr><td>Tussenvoegsel:</td><td><input type=\"text\" name=\"tv\"class='inputfield'></td></tr>
            <tr><td>Achternaam:</td><td><input type=\"text\" name=\"anaam\"class='inputfield'></td></tr>
            </table></br>";

            $html_content .= "
            <table border=1><tr><td width=150px;>Gebruikersnaam:</td><td><input type=\"text\" name=\"unaam\" class='inputfield'></td></tr>
            <tr><td>Wachtwoord:</td><td><input type=\"password\" name=\"ww\" class='inputfield'></td></tr></table>
            ";

            $html_content .= "
            </br>
            <table border=1>
            <tr><td width=150px;>Telefoon:</td><td><input type=\"text\" name=\"telefoon\" class='inputfield'></td></tr>
            <tr><td>Geboortedatum:</td><td><input type=\"text\" name=\"gebdatum\" class='inputfield'></td></tr>
            </table>";

            $html_content .="<input type='submit' name='useradd_submit' value='Voeg toe' align='center'>";
            $html_content .= "</form></div>";

            /*form to php*/
            if (isset($_POST['useradd_submit'])){
            $adduser_vnaam = $_POST['naam'];
            $adduser_tv = $_POST['tv'];
            $adduser_anaam = $_POST['anaam'];
            $adduser_unaam = $_POST['unaam'];
            $adduser_ww = $_POST['ww'];
            $adduser_telefoon = $_POST['telefoon'];
            $adduser_gebdatum = $_POST['gebdatum'];

            /*connect to SQL*/

            $servername = "localhost";
            $username = "root";
            $password = "";
            $dbname = "test";

            $conn = mysqli_connect($servername, $username, $password, $dbname);

            if (!$conn) {
                die("Connection failed: " . mysqli_connect_error());
}           }

            $sql = "INSERT INTO user (vnaam, tv, anaam, geb_datum, ww, unaam, telefoon, groep)
            VALUES (\"$adduser_vnaam\", \"$adduser_tv\", \"$adduser_anaam\", \"$adduser_gebdatum\", \"$adduser_ww\", \"$adduser_unaam\", \"$adduser_telefoon\",\"2\")";


            if (mysqli_query($conn, $sql)) {
                echo "New record created successfully";
            } else {
                echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}


            $adduser_vnaam = $_POST[''];
            $adduser_tv = $_POST[''];
            $adduser_anaam = $_POST[''];
            $adduser_unaam = $_POST[''];
            $adduser_ww = $_POST[''];
            $adduser_telefoon = $_POST[''];
            $adduser_gebdatum = $_POST[''];
mysqli_close($conn);

        }
        return $html_content;
    }
?>