/*********************************************************************** * register8.php * * Computer Science 50 * David J. Malan * * Implements a registration form for Frosh IMs. Records registration * in database. Redirects user to froshims8.php upon error. **********************************************************************/ // validate submission if (empty($_POST["name"]) || empty($_POST["gender"]) || empty($_POST["dorm"])) { header("Location: http://localhost/~jharvard/froshims/froshims8.php"); exit; } // connect to database mysql_connect("localhost", "jharvard", "crimson"); mysql_select_db("jharvard_week9"); // scrub inputs $name = mysql_real_escape_string($_POST["name"]); if ($_POST["captain"]) $captain = 1; else $captain = 0; $gender = mysql_real_escape_string($_POST["gender"]); $dorm = mysql_real_escape_string($_POST["dorm"]); // prepare query $sql = "INSERT INTO registrants (name, captain, gender, dorm) VALUES('$name', $captain, '$gender', '$dorm')"; // execute query mysql_query($sql); ?>