how can u Sending a stored pdf in an sql databse by email

[kardklub]

this is what i have so far

<?php
require "backend/functions.php";
dbconn();
$errmsg = "";


// get the .pdf
#################### this is me getting my pdf###############
$gotten = @mysql_query("select * from pdf order by pid desc limit 1");
$row = @mysql_fetch_assoc($gotten);
$fileatt = $row[imgdata];
################################################################
#but with this lines 27 28 29 do not function##############


$fileatt_type = "application/octet-stream"; // File Type
$fileatt_name = "letter.pdf"; // Filename that will be used for the file as the attachment

$email_from = "sss"; // Who the email is from
$email_subject = "hello"; // The Subject of the email
$email_txt = "jjie"; // Message that the email has in it

$email_to = "[e-mail]"; // Who the email is too

$headers = "From: ".$email_from;


#########this part fails but still sends email ############# 
$file = fopen($fileatt,'rb');
$data = fread($file,filesize($fileatt));
fclose($file);
###############################
$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";

$headers .= "\nMIME-Version: 1.0\n" .
"Content-Type: multipart/mixed;\n" .
" boundary=\"{$mime_boundary}\"";

$email_message .= "This is a multi-part message in MIME format.\n\n" .
"--{$mime_boundary}\n" .
"Content-Type:text/html; charset=\"iso-8859-1\"\n" .
"Content-Transfer-Encoding: 7bit\n\n" .
$email_message . "\n\n";

$data = chunk_split(base64_encode($data));

$email_message .= "--{$mime_boundary}\n" .
"Content-Type: {$fileatt_type};\n" .
" name=\"{$fileatt_name}\"\n" .
//"Content-Disposition: attachment;\n" .
//" filename=\"{$fileatt_name}\"\n" .
"Content-Transfer-Encoding: base64\n\n" .
$data . "\n\n" .
"--{$mime_boundary}--\n";

$ok = @mail($email_to, $email_subject, $email_message, $headers);

if($ok) {
echo "<font face=verdana size=2>The file was successfully sent!</font>";
} else {
die("Sorry but the email could not be sent. Please go back and try again!");
} 

?>

Any ideas. when i send the mail it sends but i cannot open the file and acrobat says that it does not understand the format. any info and this would be greatful

thanks

steve

[colweb]

This problem seems to be solved already. Look here: http://www.daniweb.com/code/snippet217105.html.

[kardklub]

This problem seems to be solved already. Look here: http://www.daniweb.com/code/snippet217105.html.

Many Thanks
Ill take a look

Kard