<?php
if(isset($_POST['register'])) {
	$username = $_POST['username2'];
	$password1 = $_POST['password2'];
	$password2 = $_POST['password3'];

	$userExists = mysqli_query($mysqli, "SELECT username FROM users WHERE username = '".$username."'");
	if(mysqli_num_rows($userExists)==0) {
		if($password1==$password2) {
            $ip = GetCurrIP();
			$password = hash('sha256', $password1);
			$query = mysqli_query($mysqli, "INSERT INTO `users` (ID,username,password,Role,IP First,IP curr,Online) VALUES (NULL,'".$username."','".$password."',1,'". $ip ."','". $ip ."',NULL)");

			if($query) {
				$last_id = $mysqli->insert_id;
				$guery = mysqli_query($mysqli, "INSERT INTO `users_com` (user_id,money,lives,bitches,bedrijven) VALUES ('".$last_id."',10000,5,0,0)");
				echo 'U bent nu geregistreerd!';
                if(!$guery)
                {
                    echo'dikke moedersssssss '
                }
			}
		}else {
			echo 'Wachtwoorden komen niet overeen.';
		}
	}else {
		echo 'Gebruikersnaam is al in gebruik.';
	}

}
else {
	?>
<form action="" method="POST">
	<table width="500px;">
		<h3><u><b>Login gegevens:</b></u></h3>
			<tr>
				<td width="45%"><b>Gebruikersnaam*</b></td>
				<td><input type="text" name="username2" required></td>
			</tr>
			<tr>
				<td><b>Wachtwoord*</b></td>
				<td><input type="password" name="password2" required></td>
			</tr>
			<tr>
				<td><b>Wachtwoord herhalen*</b></td>
				<td><input type="password" name="password3" required></td>
			</tr>
	</table>
		<input type="submit" name="register" value="Regristreren">
</form>
<?php
}
?>