Harvard Industrial Outreach Program

Sorry, but this feature is not currently working' . "\n"; exit(); } else { $query1 = "SELECT * from $table_register"; $results = mysql_query($query1); $nrows = mysql_num_rows($results); // set up defaults $formvars = array(); // all the interesting submitted form fields $errmsg = ""; // str of what user needs to fix $errarr = array(); // all bad fields $submitsuccess = 0; // if data fully entered // these are all the fields in the form, and their descriptions $formfields = array('firstname' => 'First Name', 'middlename' => 'Middle Initial', 'lastname' => 'Last Name', 'title' => 'Title', 'addr1' => 'Address', 'addr2' => 'Address2', 'city' => 'City', 'state' => 'State', 'zip' => 'Zip', 'email' => 'Email', 'phone' => 'Phone', 'fax' => 'Fax', 'interest' => 'Field(s) of interest', 'univname' => 'University Name', 'univschool' => 'University School', 'univdept' => 'University Department', 'resadvisor' => 'Research Advisor'); // see if submission if ($HTTP_POST_VARS["subval"] == "1") { // read input readinputunquot($formvars, array_keys($formfields)); $erequiredarr = checkinput($formvars, array('firstname', 'lastname', 'email', 'phone', 'title', 'addr1', 'city', 'state', 'zip', 'interest', 'univname', 'resadvisor')); if (count($erequiredarr)) { // print message using the full field descriptions $ereqarrd = getarrvals($formfields, $erequiredarr); $errmsg .= "Please fill in the following information:
\n" . implode("
\n", $ereqarrd) . "

\n"; $errarr = array_merge($errarr, $erequiredarr); } $uploaddir = '/data/export/content/deaswww/quantum/register/admin/files/'; $uploadfile = $uploaddir . basename($_FILES['userfile']['name']); if (!move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) { $submitsuccess = 0; $errmsg .= "\nUnable to upload document, please include a file or verify that document is under 300K"; } // if no error, submit if (!$errmsg) { $submitsuccess = 1; // the following is a list of text fields (to be quoted) $fldarr = array('firstname', 'middlename', 'lastname', 'title', 'addr1', 'addr2', 'city', 'state', 'zip', 'email', 'phone', 'fax', 'interest', 'univname', 'univschool', 'univdept', 'resadvisor'); $valarr = array(escapesql($formvars['firstname']), escapesql($formvars['middlename']), escapesql($formvars['lastname']), escapesql($formvars['title']), escapesql($formvars['addr1']), escapesql($formvars['addr2']), escapesql($formvars['city']), escapesql($formvars['state']), escapesql($formvars['zip']), escapesql($formvars['email']), escapesql($formvars['phone']), escapesql($formvars['fax']), escapesql($formvars['interest']), escapesql($formvars['univname']), escapesql($formvars['univschool']), escapesql($formvars['univdept']), escapesql($formvars['resadvisor'])); // build insert statement $fldstr = join(", ", $fldarr); $valstr = "'" . join("', '", $valarr) . "'"; $fldstr .= ", DateCreated"; $valstr .= ", now()"; $query = "insert into $table_register ($fldstr) values ($valstr)"; if ($submitsuccess) { mysql_query($query); // build the insert statement for the multi-select // will need id of the above insert $lastid = mysql_insert_id(); if ($formvars['interest'] && is_array($formvars['interest'])) { $fldarr = array('Name', 'RegisterID'); for ($i = 0; $i < count($formvars['interest']); $i++) { $valarr = array($formvars['interest'][$i], $lastid); $fldstr = join(", ", $fldarr); $valstr = "'" . join("', '", $valarr) . "'"; $query = "insert into $table_registerint ($fldstr) values ($valstr)"; mysql_query($query); } } // create some pretty fields for email // put all contact info into an email $ct = ""; $ct .= "Name: " . $formvars['firstname'] . ($formvars['middlename'] ? " " : "") . $formvars['middlename'] . " " . $formvars['lastname'] . "\n"; $ct .= "Title: " . $formvars['title'] . "\n"; $ct .= "Address: " . $formvars['addr1'] . "\n"; if ($formvars['addr2']) { $ct .= " " . $formvars['addr2'] . "\n"; } $ct .= "City: " . $formvars['city'] . "\n"; $ct .= "State: " . $formvars['state'] . "\n"; $ct .= "Zip Code: " . $formvars['zip'] . "\n"; $ct .= "\n"; $ct .= "Email: " . $formvars['email'] . "\n"; $ct .= "Phone: " . $formvars['phone'] . "\n"; $ct .= "Fax: " . $formvars['fax'] . "\n"; $ct .= "\n"; $ct .= "University Name: " . $formvars['univname'] . "\n"; $ct .= "University School: " . $formvars['univschool'] . "\n"; $ct .= "University Department: " . $formvars['univdept'] . "\n"; $ct .= "Research Advisor: " . $formvars['resadvisor'] . "\n"; $ct .= "\n"; $ct .= "Interested In: " . $formvars['interest'] . "\n\n"; $volunteer_desc = "No"; $redistribute_desc = "No"; $mailinglist_desc = "No"; // send confirmation to user $mail_to = $formvars['email']; $mail_from = $Cemail_from; $mail_fromn = $Cemail_fromname; $mail_subject = $Cemail_reg_sub; $mail_body = "Thank you for registering.\n\n"; $mail_body .= "We have recorded your information as listed below.\n\n"; $mail_body .= $ct; $mail_body .= "\n\n"; mail($mail_to, $mail_subject, $mail_body, "From: $mail_fromn <$mail_from>"); // let admin know about the registration $mail_to = $Cemail_to; $mail_from = $Cemail_from; $mail_fromn = $Cemail_fromname; $mail_subject = "EVENT REG: Someone registered for PRACQSYS 2006"; $mail_body = "Someone registered:\n\n"; $mail_body .= $ct; // add a couple fields not in contact information /* $mail_body .= "\n"; $mail_body .= "How Hear: " . $formvars['howhear'] . "\n"; if ($formvars['interest'] && is_array($formvars['interest'])) { $mail_body .= "Interested in:\n " . join("\n ", $formvars['interest']) . "\n"; } $mail_body .= "\n\n"; */ mail($mail_to, $mail_subject, $mail_body, "From: $mail_fromn <$mail_from>"); } } } // first round, set initial default else { $formvars['harvfaculty'] = '0'; $formvars['harvstudent'] = '0'; $formvars['harvstaff'] = '0'; $formvars['university'] = '0'; } } // end ifelse db error ?> Harvard Industrial Outreach Program