'); } else if (trim($_POST['phone']) == "") { print('
Error: Please go back and provide us with your phone number.
'); } else if (trim($_POST['email']) == "") { print('
Error: Please go back and provide us with your email address.
'); } else if (trim($_POST['regular'])=="0" && trim($_POST['student'])=="0") { print('
Error: You have not specified how many student or non-student attendees you would like to RSVP for the concert.
Please go back and enter the correct number of attendees. You must enter a number other than 0 for at least one of the options.
'); } else if (!is_numeric(trim($_POST['regular'])) || !is_numeric(trim($_POST['student']))) { print('
Error: The value you entered for number of student or non-student attendees is not numeric.
Please go back and enter integers only in those fields. You must enter a number other than 0 for at least one of the options.
'); } else if (trim($_POST['captcha']) != 11) { // What happens when the CAPTCHA was entered incorrectly print ("
Error: Security check failed. The sum you entered is incorrect. Please go back and type in the sum of 5+6.
"); } else { // add to db $sql = "INSERT INTO `julesz`.`FARANTOURI_RSVP` (id, name, phone, email, address, regular, student) VALUES (0, '" . mysql_real_escape_string($_POST["name"]) . "', '" . mysql_real_escape_string($_POST["phone"]) . "', '" . mysql_real_escape_string($_POST["email"]) . "', '" . mysql_real_escape_string($_POST["address"]) . "', " . mysql_real_escape_string($_POST['regular']) . ", " . mysql_real_escape_string($_POST['student']) . ");"; if (!mysql_query($sql)) print ('
Database Error: ' . mysql_error() . '
'); else { // print confirmation print '
Thank you for RSVP-ing!
You have successfully RSVP\'ed for ' . $_POST['regular'] . ' non-student and ' . $_POST['student'] . ' student attendees.
'; } } } ?>
