Admission Information Request Results - Graduate School of Arts and Sciences

Unable to locate the GSAS database at this time

'); # #} // set page vars $firstname = ''; $lastname = ''; $homeaddress = ''; $homeaddress2 = ''; $homecity = ''; $homestate = ''; $addressother = ''; $homezip = ''; $homecountry = ''; $email = ''; $phone = ''; $interest = ''; $department = ''; $date = date('Y-m-d'); // Create an empty array to hold the error messages. $arrErrors = array(); // Validate/Submit form if fields contain information, replaced trim with cleanxss 11/1/12 DL if(isset($_POST["submit"])){ if(trim($_POST["firstname"])=='') { $arrErrors["firstname"] ='Please provide your first name.'; } else { $firstname = cleanxss($_POST['firstname']); } if(trim($_POST["lastname"])=='') { $arrErrors["lastname"] ='Please provide your last name.'; } else { $lastname = cleanxss($_POST['lastname']); } if(trim($_POST["homeaddress"])=='') { $arrErrors["homeaddress"] ='Please provide your home street address.'; } else { $homeaddress = cleanxss($_POST['homeaddress']); } if(trim($_POST["homecity"])=='') { $arrErrors["homecity"] ='Please provide your city of residence.'; } else { $homecity = cleanxss($_POST['homecity']); } if(trim($_POST["homezip"])=='') { $arrErrors["homezip"] ='Please provide the zip code of your residence.'; } else { $homezip = cleanxss($_POST['homezip']); $homezip = ereg_replace("[^0-9]", "", $homezip); } if(trim($_POST["homestate"])=='Other' && trim($_POST["addressother"])=='') { $arrErrors["homestate"] ='Please provide your alternative residence area.'; } elseif(trim($_POST["homestate"])=='' && trim($_POST["addressother"])=='') { $arrErrors["homestate"] = 'Please provide your alternative residence area.'; } else { $homestate = cleanxss($_POST['homestate']); $addressother = cleanxss($_POST['addressother']); } if(trim($_POST["homecountry"])=='') { $arrErrors["homecountry"] ='Please provide the country of your residence.'; } else { $homecountry = cleanxss($_POST['homecountry']); } if(trim($_POST["email"])=='') { $arrErrors["email"] ='Please provide your email.'; } else { $email = cleanxss($_POST['email']); # if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email)) # { # $arrErrors["email"] ='Please enter a valid email.'; # } } if(trim($_POST["department"])=='') { $arrErrors["department"] ='Please provide the department in which you are interested.'; } else { $department = cleanxss($_POST['department']); } $phone = cleanxss($_POST['phone']); $phone = ereg_replace("[^0-9]", "", $phone); //Added this variable 11/1/12 DL $interest = ($_POST['interest']); if (count($arrErrors) == 0) { // clean up data - escape single quotes in open text fields $firstname=addslashes($firstname); $lastname=addslashes($lastname); $homeaddress=addslashes($homeaddress); $homecity=addslashes($homecity); $homezip=addslashes($homezip); $addressother=addslashes($addressother); $phone=addslashes($phone); $email=addslashes($email); $query = "INSERT into gsas_brochure_home (date,firstname,lastname,homeaddress,homeaddress2,homecity,homestate,addressother,homezip,homecountry,email,phone,interest,department) value ('$date','$firstname','$lastname','$homeaddress','$homeaddress2','$homecity','$homestate', '$addressother','$homezip','$homecountry','$email','$phone','$interest','$department')"; //execute SQL command $result = mysqli_query($conn, $query); if ($result === TRUE) { //get department name if($department==2) {$department_name="Biology";} if($department==4) {$department_name="Chemistry";} if($department==52) {$department_name="Geology and Geophysics";} if($department==20) {$department_name="Mathematics";} if($department==24) {$department_name="Physics";} if($department==6) {$department_name="Economics";} if($department==26) {$department_name="Political Science";} if($department==28) {$department_name="Psychology";} if($department==32) {$department_name="Sociology";} if($department==18) {$department_name="Classical Studies";} if($department==10) {$department_name="English";} if($department==17) {$department_name="History";} if($department==25) {$department_name="Philosophy";} if($department==42) {$department_name="Romance Languages and Literatures";} if($department==29) {$department_name="Slavic Languages and Literatures";} if($department==36) {$department_name="Theology";} //send email to user confirming request $to = $email; $subject = "Admission Information Request"; $headers = "From: Boston College GSAS \r\n"; $body = 'Your request for a brochure for the '.$department_name.' department from the Boston College Graduate School of Arts and Sciences has been submitted. It will be sent to: '.$firstname.' '.$lastname.' '.$homeaddress.' '.$homeaddress2.' '.$homecity.', '.$homestate.$addressother.' '.$homecountry.' '; mail($to, $subject, $body, $headers); //display the requested brochures echo ' You requested a brochure for the '.$department_name.' department sent to the following adddress:

'.$firstname.' '.$lastname.'
'.$homeaddress.' '.$homeaddress2.'
'.$homecity.', '.$homestate.$addressother.'
'.$homecountry.'

An email confirming this has also been sent to the address provided. '; } else { echo "Could not input data into database at this time. Please contact site administrator"; echo mysqli_error(); } } else { echo "Go back and correct the following errors:

\n

"; print_r($error); echo "

Unable to locate the GSAS database at this time

Biology (PDF)

Chemistry (PDF)

Geology and Geophysics (PDF)

Mathematics (PDF)

Physics (PDF)

Economics (PDF)

Political Science (PDF)

Psychology (PDF)

Sociology (PDF)

Classical Studies (PDF)

English (PDF)

History (PDF)

Philosophy (PDF)

Romance Languages (PDF)

Slavic Languages (PDF)

Theology (PDF)

\r\n"; $body = 'The links to the Boston College Graduate School of Arts and Sciences brochures you requested are below: '.$for_email.' PDF files require Adobe Acrobat Reader. If you cannot open them, download the free reader now: http://www.adobe.com/products/acrobat/readstep2.html '; mail($to, $subject, $body, $headers); //display the requested brochures echo ' The links to the brochures you requested are below

An email with this information has also been sent to the address you provided

'.$for_browser.'

PDF files require Adobe Acrobat Reader. If you cannot open them, download the free reader now. '; } else { echo "Could not input data into database at this time. Please contact site administrator"; echo mysqli_error(); } } else { echo "Go back and correct the following errors:

\n

"; print_r($error); echo "