session_start();
include ("../RaceDirector/includes/config.php");
include ("../inc/function.SanitizePhone.php");
//Create an Account
if (isset($_POST['RegisterSubmit'])){
$FN=mysqli_real_escape_string($con,$_POST['FN']);
$LN=mysqli_real_escape_string($con,$_POST['LN']);
$School=mysqli_real_escape_string($con,$_POST['School']);
$Phone=mysqli_real_escape_string($con,$_POST['Phone']);
$Phone=sanitize_phone($Phone);
$Email=mysqli_real_escape_string($con,$_POST['Email']);
$PW=mysqli_real_escape_string($con,$_POST['PW']);
$PW2=mysqli_real_escape_string($con,$_POST['PW2']);
if ($PW != $PW2) { $ErrorMsg="Passwords do not match, please try again";}
else
{
$s="SELECT COUNT(*) as C FROM MR_coaches WHERE Email='$Email'";
$query=$con->query($s);
$a=$query->fetch_assoc();
if ($a['C'] < 1){
$sql2="INSERT INTO MR_schools (School, SchoolCode) VALUES ('$School', '')";
$q2=$con->query($sql2);
$SchoolID=mysqli_insert_id($con);
$sql="INSERT INTO MR_coaches (FN, LN, School, Phone, Email, PW) VALUES ('$FN', '$LN', '$SchoolID', '$Phone', '$Email', '$PW')";
$q=$con->query($sql);
$CoachID=mysqli_insert_id($con);
$sql="INSERT INTO MR_Teams (CoachID, Name) VALUES('$CoachID', '$School')";
$con->query($sql);
$ErrorMsg="Your account has been successfully created. Click HERE to login!";
}
else {
$ErrorMsg="This Email Address has already been used for an account. Please use a different account or the \"Forgot Password\" App .";}
}
}?>
TheMeetResults.com