Code: Select all
$hostname = "MYSQLHOST";
mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
mysql_query("INSERT INTO camper_information (camper_lastname, camper_firstname, date_of_birth, grade, school, address, city, state, zip, camper_phone, week1, week2, week3, week4, week5, week6, father_name, father_cell, father_work, father_email, mother_name, mother_cell, mother_work, mother_email, emergency_name1, emergency_home1, emergency_cell1, emergeny_name2, emergency_home2, emergency_cell2, doctor_name, doctor_phone, allergies, treatments, medications, mecdical_others, dismissal_mon, dismissal_tue, dismissal_wed, dismissal_thu, dismissal_fri, handbook, permission, submitter)
VALUES ('$camper_lastname', '$camper_firstname', '$date_of_birth', '$grade', '$school', '$address', '$city', '$state', '$zip', '$camper_phone', '$week1', '$week2', '$week3', '$week4', '$week5', '$week6', '$father_name', '$father_cell', '$father_work', '$father_email', '$mother_name', '$mother_cell', '$mother_work', '$mother_email', '$emergency_name1', '$emergency_home1', '$emergency_cell1', '$emergeny_name2', '$emergency_home2', '$emergency_cell2', '$doctor_name', '$doctor_phone', '$allergies', '$treatments', '$medications', '$mecdical_others', '$dismissal_mon', '$dismissal_tue', '$dismissal_wed', '$dismissal_thu', '$dismissal_fri', '$handbook', '$permission', '$submitter')");