$transportLimit = TRUE; } elseif ($_POST['desiredTransportation'] == 2 && $ccCount >= 6) { $transportLimit = TRUE; } // duplicate entries $dups = FALSE; $sqlSID = "SELECT * FROM fieldtrippeople"; $resultsSID = mysql_query($sqlSID); while ($row = mysql_fetch_array($resultsSID)) { if (strtolower(trim($row['email'])) == strtolower(trim($_POST['email']))) { $dups = TRUE; $errorDuplicates = "The record already exists. Please check your inbox for the confirmation email."; } } // error checking if ($_POST['datePreffered'] == -1 || $_POST['desiredTransportation'] == -1 || strlen($_POST['sID']) == 0 || !is_numeric($_POST['sID']) || strlen($_POST['sID']) != 10 || strlen($_POST['firstName']) == 0 || strlen($_POST['lastName']) == 0 || $_POST['labSection'] == -1 || strlen($_POST['email']) == 0 || !email_validation($_POST['email']) || !uta_email_validation($_POST['email']) || $transportLimit == TRUE || $dups == TRUE) { $errors = TRUE; } else { $errors = FALSE; } if (!$errors) { $datePreffered = $_POST['datePreffered']; $prefferedTransportation = $_POST['desiredTransportation']; $studentID = $_POST['sID']; $firstName = $_POST['firstName']; $lastName = $_POST['lastName']; $labSection = $_POST['labSection']; $email = $_POST['email']; $status = 'pending'; $rand = strtolower(substr($firstName, 0, 1)) . strtolower(substr($lastName, 0, 1)) . rand(100000, 999999); $sql = "INSERT INTO \r\n\t\t\t\t\t\t\t\tfieldtrippeople (\r\n\t\t\t\t\t\t\t\t\t\tID, \r\n\t\t\t\t\t\t\t\t\t\tfirstName, \r\n\t\t\t\t\t\t\t\t\t\tlastName, \r\n\t\t\t\t\t\t\t\t\t\teid, \r\n\t\t\t\t\t\t\t\t\t\tdatePreffered, \r\n\t\t\t\t\t\t\t\t\t\ttransportation,\r\n\t\t\t\t\t\t\t\t\t\tsection,\r\n\t\t\t\t\t\t\t\t\t\tdateSigned,\r\n\t\t\t\t\t\t\t\t\t\temail,\r\n\t\t\t\t\t\t\t\t\t\tstatus,\r\n\t\t\t\t\t\t\t\t\t\trand\r\n\t\t\t\t\t\t\t\t\t\t) \r\n\t\t\t\t\t\t\t\tVALUES (\r\n\t\t\t\t\t\t\t\t\t\tNULL, \r\n\t\t\t\t\t\t\t\t\t\t'{$firstName}', \t\r\n\t\t\t\t\t\t\t\t\t\t'{$lastName}', \r\n\t\t\t\t\t\t\t\t\t\t'{$studentID}',\r\n\t\t\t\t\t\t\t\t\t\t'{$datePreffered}', \r\n\t\t\t\t\t\t\t\t\t\t'{$prefferedTransportation}', \r\n\t\t\t\t\t\t\t\t\t\t'{$labSection}',\r\n\t\t\t\t\t\t\t\t\t\tNOW(),\r\n\t\t\t\t\t\t\t\t\t\t'{$email}',\r\n\t\t\t\t\t\t\t\t\t\t'{$status}',\r\n\t\t\t\t\t\t\t\t\t\t'{$rand}'\r\n\t\t\t\t\t\t\t\t\t\t)";
<?php function uta_email_validation($email) { $atEmail = explode('@', strtolower($email)); $dotEmail = explode('.', $atEmail[1]); echo $email . "::"; if ($dotEmail[0] == "uta" && $dotEmail[1] == "edu") { echo "TRUE<br />"; } else { if ($dotEmail[1] == "uta" && $dotEmail[2] == "edu") { echo "TRUE<br />"; } else { echo "FALSE<br />"; } } } uta_email_validation("*****@*****.**"); uta_email_validation("*****@*****.**"); uta_email_validation("*****@*****.**"); uta_email_validation("*****@*****.**"); if (uta_email_validation("*****@*****.**")) { echo "TRUE"; } else { echo "FALSE"; }