Date: 03/01/06 (PHP Community)    Keywords: mysql, database, sql

Hey all,


I'm trying to build a form that submits its contents to a database, with the exception of two file fields that are supposed to be emailed to someone. I can get the form working fine as usual, but for whatever reason, the file emailing section is not working. It acts like the files don't exist. Any suggestions? Also, I can't upload these files to my server because my admins are nazis - is there any way I can store a word doc or pdf in a mySQL db?

<?php // Connect to Database include('functions/mail_attached.php'); //connect info omitted if ($_POST['submitted'] == "yes") { //are the files there? echo "Submission if works<br />"; //files are there, let's fix the HTML and newlines $newOffAdd = strip_tags($_POST['office_address']); // remove all HTML $newOffAdd = nl2br($newOffAdd); // make the line breaks in to br tags $newHomeAdd = strip_tags($_POST['home_address']); // remove all HTML $newHomeAdd = nl2br($newHomeAdd); // make the line breaks in to br tags $newPolBack = strip_tags($_POST['political_background']); // remove all HTML $newPolBack = nl2br($newPolBack); // make the line breaks in to br tags //prepare the data to be inserted $insert_string = "insert into fellowsapp (`fellowship_date`,`fellow_name`,`fellow_title`,`office_address`,`home_address`,`office_phone`,`home_phone`,`assistant_name`,`office_fax`,`home_fax`,`fellow_email`,`fellow_ssn`,`recommended_by`,`political_background`) VALUES(\"" . $HTTP_POST_VARS['fellow_date'] . "\",\"" . $HTTP_POST_VARS['fellow_name'] . "\",\"" . $HTTP_POST_VARS['fellow_title'] . "\",\"" . $newOffAdd . "\",\"" . $newHomeAdd . "\",\"" . $_POST['office_phone'] . "\",\"" . $_POST['home_phone'] . "\",\"" . $HTTP_POST_VARS['assistant_name'] . "\",\"" . $HTTP_POST_VARS['office_fax'] . "\",\"" . $HTTP_POST_VARS['home_fax'] . "\",\"" . $HTTP_POST_VARS['fellow_email'] . "\",\"" . $HTTP_POST_VARS['fellow_ssn'] . "\",\"" . $HTTP_POST_VARS['recommended_by'] . "\",\"" . $newPolBack . "\");"; //insert the data $result = mysql_query($insert_string); //mail $mail_to = "jessica_jacobs@ksg.harvard.edu"; $message = "Dear Eric, Here are the files that go with " . $_POST['fellow_name'] . "'s fellow application. Enjoy! Jess"; $result2 = mail_attached($mail_to,$webmaster_email,"Fellows Application Files",$message,$_FILES); //tell them they succeeded echo "<span class=\"message_text\"><b>Thank you for your submission! We'll be contacting you shortly.</b></span><br /><br >"; } else {} //tell them they don't have any files //echo "<span class=\"message_text\"><b>You must supply a bio and study group topic information.</b></span><br /><br />"; //} ?> AND MY INCLUDE IS BELOW: <? /* Shamelessly stolen from http://www.theukwebdesigncompany.com/articles/php-file-attachments.php, then adjusted to my needs, found not to work and modified using ideas from http://www.phpdiscuss.com/article.php?id=423&group=php.lang and elsewhere. $filenames is designed basically to just be $_FILES; otherwise, use an array of the form: $filenames = array( "key1" => array( "error" => "0", "tmp_name" => "full_path_to_file", "name" => "file_name", "size" => "size", "type" => "type")); */ function mail_attached($to, $from, $subject, $message, $filenames, $headers = '') { $unique_sep = md5(uniqid(time())); // Set up the top headers $headers .= "From: $from\n"; $headers .= "MIME-Version: 1.0\nContent-Type: multipart/mixed;boundary=\"$unique_sep\";\n"; $headers .= "charset=\"iso-8859-1\"\nContent-Transfer-Encoding:7bit\n\n"; $headers .= "If you are reading this, then your e-mail client does not support MIME.\n"; $headers .= "Sent with mail_attached() (c) 2002 John Coggeshall\n\n"; $headers .= "--$unique_sep\n"; // Include the text portion of the e-mail $headers .= "Content-Type: text/plain; charset=\"iso-8859-1\"\n"; $headers .= "Content-Transfer-Encoding: 7bit\n\n"; $headers .= $message . "\n\n"; // Now the attachment foreach($filenames as $val) { if($val['error'] != 4 && file_exists($val['tmp_name'])) { $headers .= "--$unique_sep\n"; $headers .= "Content-Type: {$val['type']}; name=\"{$val['name']}\"\n"; $headers .= "Content-Transfer-Encoding: base64\n"; $headers .= "Content-Disposition: attachment\n\n"; $linesz= $val['size']+1; $fp= fopen($val['tmp_name'], 'rb'); $headers .= chunk_split(base64_encode(fread($fp,$linesz))); } } $headers .= "--$unique_sep--\n"; if(!mail($to, $subject, $message, $headers)) return false; else return true; } /* End of mail_attached() function */ ?>

Thanks!

Source: http://community.livejournal.com/php/421008.html