real_escape_string($_POST['username']); $password = md5($conn->real_escape_string($_POST['password'])); $email = $conn->real_escape_string($_POST['email']); $query = "SELECT * FROM users WHERE Username = '".$username."'"; $result = $conn->query($query); if (! $result) echo "

Error in database query

"; if($result->num_rows == 1) { echo "

Error

"; echo "

Sorry, that username is taken. Please go back and try again.

"; } if(!empty($_POST['username']) && !empty($_POST['password'])) { $username = $conn->real_escape_string($_POST['username']); $password = md5($conn->real_escape_string($_POST['password'])); $email = $conn->real_escape_string($_POST['email']); query = "SELECT * FROM users WHERE Username = '".$username."'"; $result = $conn->query($query); if (! $result) echo "

Error in database query

"; if($result->num_rows == 1) { echo "

Error

"; echo "

Sorry, that username is taken. Please go back and try again.

"; } else { $query = "INSERT INTO users (Username, Password, EmailAddress) VALUES('".$username."', '".$password."', '".$email."')"; $result = $conn->query($query); if ($result) { echo "

Success

"; echo "

Your account was successfully created. Please click here to login.

"; } else { echo "

Error

"; echo "

Sorry, your registration failed. Please go back and try again.

"; } } } else {//step1 ?>

Register Form

Please enter your details below to register.

Username:
Password:
Email Address: