if (isset($_POST['submit'])){
$username = $username;
$Level4hash = password_hash($Level4, PASSWORD_DEFAULT);
$ProjectionPassword = password_hash($ProjectionPassword, PASSWORD_DEFAULT);

$house1 = $_POST['House1'];
$house1colour = $_POST['House1colour'];
$house1colour = str_replace("#", "", $house1colour);

$house2 = $_POST['House2'];
$house2colour = $_POST['House2colour'];
$house2colour = str_replace("#", "", $house2colour);

$house3 = $_POST['House3'];
$house3colour = $_POST['House3colour'];
$house3colour = str_replace("#", "", $house3colour);

$house4 = $_POST['House4'];
$house4colour = $_POST['House4colour'];
$house4colour = str_replace("#", "", $house4colour);

/*
echo $username."<br>";
echo $Level4hash."<br>";
echo $house1."<br>";
echo $house1colour."<br>";
echo $house2."<br>";
echo $house2colour."<br>";
echo $house3."<br>";
echo $house3colour."<br>";
echo $house4."<br>";
echo $house4colour."<br>";
echo $ProjectionPassword."<br>";
die();
*/

$stmts = $link->prepare("INSERT INTO `users` (`id`, `username`, `Level4`, `ProjectionPassword`, `House1`, `House1colour`, `House2`, `House2colour`, `House3`, `House3colour`, `House4`, `House4colour`) VALUES (NULL, '".$username."', '".$Level4hash."', '".$ProjectionPassword."', '".$house1."', UNHEX('".$house1colour."'), '".$house2."', UNHEX('".$house2colour."'), '".$house3."', UNHEX('".$house3colour."'), '".$house4."', UNHEX('".$house4colour."')");

$res = $stmts->execute();
$res->close();}}