<?php

if(!isset($_POST['submit'])){

?>

* Påkrævet

<form action="opret.php" method="post">
<input placeholder="Brugernavn" type="text" name="name"> *<br>
<input placeholder="Email adresse" type="text" name="email"> *<br>
<input placeholder="Password" type="password" name="password"> *<br>
<input placeholder="Dit fulde navn" type="text" name="fuldnavn"> *<br>
<input placeholder="Din adresse" type="text" name="adresse1"> *<br>
<input placeholder="Eventuelt stedangivelse" type="text" name="adresse2"><br>
<select name="bynavn">
  <option>Din by</option>
  <option value="6000 Kolding">6000 Kolding</option>
  <option value="6640 Lunderskov">6640 Lunderskov</option>
  <option value="6580 Vamdrup">6580 Vamdrup</option>
  <option value="6040 Egtved">6040 Egtved</option>
  <option value="6091 Sønder Bjert">6091 Sønder Bjert</option>
  <option value="6070 Christiansfeld">6070 Christiansfeld</option>
  <option value="7000 Fredericia">7000 Fredericia</option>
  <option value="6600 Vejen">6600 Vejen</option>
  <option value="6630 Rødding">6630 Rødding</option>
</select> *<br>
<input placeholder="Phonenumber (+45)" type="text" name="telefonnummer"> *<br>
<input type="submit" name="submit" value="Opret"> Når du trykker "Opret" accepterer du vores <a href="#">retningslinjer</a>
</form><br>

<?PHP

}else{

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

//connection to the database
$dbhandle = mysqli_connect('localhost','root','','test')
  or die("Unable to connect to MySQLI");

$sqli = "INSERT INTO brugere (navn,email,password,fuldnavn,adresse1,adresse2,bynavn,telefonnummer)
VALUES ('".$_POST["name"]."','".$_POST["email"]."','".md5($_POST["password"])."','".$_POST["fuldnavn"]."','".$_POST["adresse1"]."','".$_POST["adresse2"]."','".$_POST["bynavn"]."','".$_POST["telefonnummer"]."')";

$dbhandle->query($sqli);
header("Location: opret.php"); /* Redirect browser */
exit;

}


?>