real_escape_string($_POST['myName']); $myPass = md5($connection->real_escape_string($_POST['myPass'])); $myEmail = $connection->real_escape_string($_POST['myEmail']); $myFood1 = $connection->real_escape_string($_POST['myFood1']); $myFood2 = md5($connection->real_escape_string($_POST['myFood2'])); $myFood3 = $connection->real_escape_string($_POST['myFood3']); $query = "SELECT * FROM myUserAccount WHERE myName = '".$myName."'"; $result = $connection->query($query); if (! $result) echo "

Error in database query

"; if($result->num_rows == 1) { //When a username is taken by other user already. echo "

Error

"; echo "

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

"; echo "

Please click here to Go back to Register Form.

"; } else { //When new username is available $query = "INSERT INTO myUserAccount (myName, myPass, myEmail, myFood1, myFood2, myFood3) VALUES('".$myName."', '".$myPass."', '".$myEmail."', '".$myFood1."', '".$myFood2."', '".$myFood3."')"; //1 line $result = $connection->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 {//when users see this screen first time ?>

Register

Please enter your details below to register.







Click hereto go back to homepage.