<?php //Look at big if{..}elseif{…}else {…}
if(!empty($_POST['myName']) && !empty($_POST['myPass']))
{//after users put their username, password, email to create new account
$myName = $connection->real_escape_string($_POST['myName']);
$myPass = md5($connection->real_escape_string($_POST['myPass']));
$myEmail = $connection->real_escape_string($_POST['myEmail']);
$query = "SELECT * FROM myUserAccount WHERE myName = '".$myName."'";
$result = $connection->query($query);
if (! $result)
echo "<p>Error in database query</p>";
if($result->num_rows == 1)
 { //When a username is taken by other user already.
 echo "<h1>Error</h1>";
 echo "<p>Sorry, that username is taken. Please go back and try again.</p>";
 echo "<p>Please click <a href=\"myRegister.php\"> here </a> to Go back to Register Form.</p>";
 }
 else
 { //When new username is available
$query = "INSERT INTO myUserAccount (myName, myPass, myEmail) VALUES('".$myName."', '".$myPass."', '".$myEmail."')"; //1 line
 $result = $connection->query($query);
 if ($result)
 {
 echo "<h1>Success</h1>";
 echo "<p>Your account was successfully created. Please <a href=\"myndex.php\">click here to login</a>.</p>";
 }
 else
 {
 echo "<h1>Error</h1>";
 echo "<p>Sorry, your registration failed. Please go back and try again.</p>";
 }
 }
}
else
{//when users see this screen first time
?>
 <h1>Register</h1>
 <p>Please enter your details below to register.</p>
 <form method="post" action="../Assignment_10_2/myRegister.php" name="registerform" id="registerform">
 <fieldset>
 <label for="myName">Username:</label><input type="text" name="myName" id="myName" /><br />
 <label for="myPass">Password:</label><input type="password" name="myPass" id="myPass" /><br />
 <label for="myEmail">Email Address:</label><input type="text" name="myEmail" id="myEmail" /><br />
 <input type="submit" name="register" id="register" value="Register" />
 </fieldset>
 </form>
<p>Click <a href="myIndex.php">here</a>to go back to homepage.</p>
<?php
}
?>