#!/home/c/s/cs50/pub/local/i386/php/bin/php-cgi // display errors ini_set("display_errors", true); error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING); // database details $DB = ""; $DBUSER = ""; $DBPASS = ""; $DBSERVER = "mysql.cs50.org:5050"; // connect to server $connection = mysql_connect($DBSERVER, $DBUSER, $DBPASS); // select database mysql_select_db($DB, $connection); // validate submission if ($_GET["name"] == "" || $_GET["gender"] == "" || $_GET["dorm"] == "") { header("Location: http://www.courses.fas.harvard.edu/~cs50/lectures/weeks/11/src/monday/froshims.php?name=" . $_GET["name"]); exit; } // prepare inputs $name = mysql_real_escape_string($_GET["name"]); if ($_GET["captain"]) $captain = "1"; else $captain = "0"; $gender = mysql_real_escape_string($_GET["gender"]); $dorm = mysql_real_escape_string($_GET["dorm"]); // prepare query $sql = sprintf("INSERT INTO froshims (name,captain,gender,dorm) VALUES('%s','%s','%s','%s')", $name, $captain, $gender, $dorm); // execute query mysql_query($sql); ?>