MySQL Error: " . mysqli_error($dbc));
$r2 = mysqli_query ($dbc, $q2) or trigger_error("Query: $q2\n MySQL Error: " . mysqli_error($dbc));
$flag1 = mysqli_num_rows($r1);
$flag2 = mysqli_num_rows($r2);
$email_match = ""; //error messages for registered emails and usernames
$username_match = "";
$success= ""; //message indicating whether the account was created successfully
if ($flag1 == 0 && $flag2 == 0){ // No rows were retrieved, email and username are available.
//calculate age
//Add the user to the database:
$q = "INSERT INTO user (username, email, pass, avatar_id) VALUES ('$username','$email',SHA1('$password'), 0)";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n MySQL Error: " . mysqli_error($dbc));
if (mysqli_affected_rows($dbc) == 1) { //One row affected, user successfully added
$success= "Account was successfully created! Now log in!";
}
else {
$success= "You could not be registered due to a system error. Please try again.";
}
}//end if
else { //check for matches, set error messages values. Error messages will appear in the form
if ($flag1 == 1){ //1 row retrieved, email match found
$email_match = "That email address has already been registered.";
}
if ($flag2 == 1){ //1 row retrieved, username match found
$username_match = "That username is already in use.";
}
} //end else
mysqli_close($dbc);
}
?>