<?php
$output = NULL;
if(isset($_POST['submit'])){

	//Connect To Database
	$mysqli = NEW MySQLi ('localhost', 'root', '', 'register');

	$username = $mysqli->real_escape_string($_POST ['username']);
	$password = $mysqli->real_escape_string($_POST ['password']);
	$rpassword = $mysqli->real_escape_string($_POST ['rpassword']);
	$email = $mysqli->real_escape_string($_POST ['email']);

	$query = $mysqli->query("SELECT * FROM users WHERE username = '$username'");
	if (empty($username) OR empty($password) OR empty ($rpassword) OR empty($email)){
		$output = "Please fill in all fields";
	} elseif($query->num_rows != 0){
		$output = "That username is already taken."	;}
} else{
//Encrypt The Password
$password = md5 ($password);
	//Insert Record
	$insert = $mysqli->query("INSERT INTO users(username,password,email) VALUES('$username','$password','$email')");
	if($insert !=TRUE){
		$output = "There was a problem<br>";
		$output .=$mysqli->error;
	}else{
		$output = "You have been registered!";
	}


?>
<form method="POST">
<table>
<tr>
<td>Username:</td>
<td><input type="TEXT" name="username"</td>
<tr>
<td>Password:</td>
<td><input type="PASSWORD" name="password"</td>
<tr>
<td>Repeat Password:</td>
<td><input type="PASSWORD" name="rpassword"</td>
<tr>
<td>Email:</td>
<td><input type="TEXT" name="email"</td>
</table>
<input type="SUBMIT" name="submit" value="Register"
</form>
<?php
echo $output;
?>