PHP - Php Imap_mail_compose With Attachments, Help

Hello

I have a database table containing users uploaded word docs as long blobs (I know in an ideal world these should be in a filesystem, not a table but that wasn't possible)

I'd like to be able to generate an email with php and send out these files as attachments. I have pear mail installed and can get this to send out emails with attachments form a file share no problems. Getting it to work with blobs escapes me though. Is this possibile of do I need a different class?


Code: [Select]
include('../db_connection.php');
$query1 = "SELECT id, name, type, content, size FROM upload WHERE lref='" . $_POST['lref'] . "'";
$result2 = $mysqlilsr->query($query1) or die ($mysqlilsr->error);

list($id, $name, $type, $content, $size) = $result2->fetch_array();

//echo $name . '<br/>';
//echo $content . '<br/>';
//echo $type . '<br/>';
//$fileattname = file_get_contents($_POST['attachment']);

$fileattname = file_get_contents($_POST['attachment']);

$from_mail = "email address";
$replyto = "email address";

//phpinfo();
//mail_attachment($filename, $path, $mailto, $from_mail, $from_name, $replyto, $subject, $message);

$headers = array(
    'From' => $from_mail,
    'Subject' => $subject,
    'Cc' => $replyto,
);

$body = $header . $spacer .$message . $spacer . $footer;

$mime = new Mail_mime();
$mime->setTXTBody($body);
$mime->addAttachment(base64_encode($content), $name, $type, "iso-8859-1");
$body = $mime->get();
$headers = $mime->headers($headers);
$mailer =& Mail::factory('mail');
$res = $mailer->send($_POST['email'], $headers, $body);
if (PEAR::isError($res)) {
    echo 'error';
} else {
    'success';
}

Hi,
I have done this script that sends emails without attachments.
What I want to do now is add the functionality to attach multiple files using one single field, kind of what Outlook does...you can select one or more files to attach to your email.
Any ideas how I can do this?
Thanks
Code: [Select]
<?php

$EmailTo = Trim(stripslashes($_POST['to']));
$Subject = Trim(stripslashes($_POST['subject']));
$email = Trim(stripslashes($_POST['email']));



// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers

$headers .= 'From: My company<info@mycompany.com>' . "\r\n";
$headers .= "Cc: {$_POST['cc']}\r\n";
$headers .= "Bcc: {$_POST['bcc']}\r\n";


// prepare email body text
$Body = "";
$Body .= $email;
$Body .= "\n";
$Body .= "\n";


// send email 
$success = mail($EmailTo, $Subject, stripslashes($Body), $headers);

// redirect to success page 
if ($success){
  print "<meta http-equiv=\"refresh\" content=\"0;URL=../PC_email_compose.php?emailsentok=true\">";
}
else{
  print "<meta http-equiv=\"refresh\" content=\"0;URL=../PC_email_compose.php?emailsenterror=true\">";
}
?>

Hello,
i have this code for sending email it works great but i don't know where to start in sending emails with a pdf file attached ex: test.pdf. Any suggestions?

 <?php
    session_start();
    require_once('framework/framework.php');
    include('framework/class.smtp.inc');

//--- databse settings

    $dsn = array(
        'dbtype'      => 'mysql',
        'username'     => '',
        'password'     => '',
        'host'         => '',
        'database'  => ''
    );
    
    try {
        $db = db::connect($dsn);
    }
    catch (Exception $e) { 
        die($e->getMessage()); 
    }
    
//---

    $subject="Formular online pentru participantii Diaspora Stiintifica 2010";

// +--------------  BEGIN  ----  Functia de trimitere mail prin smtp  -------------------+ */

    function trimite($destinatar='', $subiect='', $mesaj='') {

//--- mail settings
    $smtp_server_host="mail.server.com";
    $smtp_server_port="25";
    $sender="email@email.com";
    $return_path="email@email.com";
    $smtp_username="email@email.com";
    $smtp_pswd="123";
        /***************************************
        ** Setup some parameters which will be
        ** passed to the smtp::connect() call.
        ***************************************/
        $params['host'] = $smtp_server_host;    // The smtp server host/ip
        $params['port'] = $smtp_server_port;    // The smtp server port
        $params['helo'] = exec('hostname');        // What to use when sending the helo command. Typically, your domain/hostname
        $params['auth'] = false;                    // Whether to use basic authentication or not
//        $params['user'] = $smtp_username;        // Username for authentication
//        $params['pass'] = $smtp_pswd;            // Password for authentication
        $params['timeout'] = '60';
        /***************************************
        ** These parameters get passed to the
        ** smtp->send() call.
        ***************************************/
        $send_params['recipients']    = $destinatar;    // The recipients (can be multiple)
        $send_params['headers']        = array( "MIME-Version: 1.0", 
                                            "X-Mailer: PHP/" . phpversion(),
                                            "Return-Path: ".$return_path,
                                            "From: ".$sender,
                                            "To: ".$destinatar,
                                            "Subject: ".$subiect,
                                            "Content-type: text/html; charset=UTF-8",
                                            "Content-Transfer-Encoding: 8bit");
        $send_params['from']        = $sender;    // This is used as in the MAIL FROM: cmd
                                                // It should end up as the Return-Path: header
        $send_params['body'] = $mesaj;

        /***************************************
        ** The code that creates the object and
        ** sends the email.
        ***************************************/
        $smtp = new smtp($params);
        $smtp->connect();
        $trimis=$smtp->send($send_params);
        $raspuns=array($destinatar, $trimis, $smtp->errors);
        //    $smtp->rset();
    
//--- Bcc:
/*        $send_params['recipients']    = $sender;
        $trimisi=$smtp->send($send_params);
        $errmsgi=$smtp->errors;
        print "<br>bcc: ".$send_params['recipients']."; ".$trimisi."<br>";
            for ($n = 0 ; $n <= count($errmsgi) - 1; $n++) {
                print "<br>"."&nbsp;&nbsp;bccerr: &nbsp;<strong>".$errmsgi[$n]."</strong><br>";
            }
*/
        $smtp->quit();
        return $raspuns;
    }
// +--------------   END   ----  Functia de trimitere mail prin smtp  -------------------+ */


// +---------------------------------------------------------------------------+

    $afisez = "";
    $cond=0;
    
    $query = "SELECT email_1 FROM inregistrari WHERE `completat`=0";
    $useri = $db->getAll($query);
    $i=0;
    $j=0;
    $k=0;
    
    foreach ($useri as $row) {
        $tpl = new HTML_Template_Sigma('mesaj');
        $tpl->loadTemplateFile("mesaj.html");
        $tpl->setVariable($row);
        $html=$tpl->get(); //*/
        $html=nl2br($html);
        $html=str_replace(chr(10), "", $html);
        $html=str_replace(chr(13), "", $html); // */

// +----------------------+
        $subiect = $subject;
        if (!empty($row['email_1'])) {
            $subelements=preg_split("/, /", $row['email_1'], -1, PREG_SPLIT_NO_EMPTY);
            for ($m = 0 ; $m <= count($subelements) - 1; $m++) {

                $rez = trimite($subelements[$m], $subiect, $html);
                if ($rez[1]==true) {
                    $afisez .= $rez[0].";1<br>";
                    $i++;
                } else {
                    $afisez .= $rez[0].";0<br>";
                    $errmsg=$rez[2];
                    for ($n = 0 ; $n <= count($errmsg) - 1; $n++) {
                        $afisez .= "&nbsp;&nbsp;&nbsp;&nbsp;<strong>".$errmsg[$n]."</strong><br>";
                    }
                    $j++;
                }
            }
        } else {
            $afisez .= $row['email_1'].";no email;n<br>";
            $k++;
        }
    }
$afisez .= "<br>{$i} mesaje Trimise<br>";
$afisez .= "{$j} mesaje Netrimise<br>";
$afisez .= "{$k} mesaje fara adresa<br>";
print $afisez;
?>

Hi

I'm very new to PHP. I've been searching high and low for a script that will process a simple form and also allow a file attachment.

I've tried loads of different ones and none of them work as I want. I do actually have one working but this doesn't have any validation of the file.

Can anyone please point me in the direction of a script that will allow me to do this.

Thanks

Basically I have successfully found a function that can send email with attachment. However wasn't able to send multiple attachments. I tried sending two attachments manually, but only the second was successfully attached. Can someone look through the code below and point out my mistake. Thank you in advance....


<?php
if(isset($_POST['send']))
{
$fileatt_one = $_FILES['attachment']['tmp_name'][0];
$fileatt_type_one = "application/octet-stream"; // File Type
$fileatt_name_one = $_FILES['attachment']['name'][0]; // Filename that will be used for the file as the attachment

$fileatt_two = $_FILES['attachment']['tmp_name'][1];
$fileatt_type_two = "application/octet-stream"; // File Type
$fileatt_name_two = $_FILES['attachment']['name'][1]; // Filename that will be used for the file as the attachment

$email_from = "a@gmail.com"; // Who the email is from
$email_subject = "Test"; // The Subject of the email
$email_txt = "Testing 123"; // Message that the email has in it
$email_to = "a@gmail.com"; // Who the email is too

$headers = "From: ".$email_from;

$file_one = fopen($fileatt_one,'rb');
$data_one = fread($file_one,filesize($fileatt_one));
fclose($file_one);

$file_two = fopen($fileatt_two,'rb');
$data_two = fread($file_two,filesize($fileatt_two));
fclose($file_two);

$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
$data_one = chunk_split(base64_encode($data_one));
$data_two = chunk_split(base64_encode($data_two));

$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_txt . "\n\n";

$email_message .= "--{$mime_boundary}\n" ."Content-Type: {$fileatt_type_one};\n" ." name=\"{$fileatt_name_one}\"\n" ."Content-Transfer-Encoding: base64\n\n" .$data_one . "\n\n" ."--{$mime_boundary}--\n";
$email_message .= "--{$mime_boundary}\n" ."Content-Type: {$fileatt_type_two};\n" ." name=\"{$fileatt_name_two}\"\n" ."Content-Transfer-Encoding: base64\n\n" .$data_two . "\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!");
}

}
?>
<form enctype="multipart/form-data" name="send" method="post" action="<?=$_SERVER['PHP_SELF']?>">
<input type="file" name="attachment[]" size="50" />
<input type="file" name="attachment[]" size="50" />
<input type="submit" name="send" value="Submit">
</form>

I am piping email to a php script, from the email I want to get the email attachment that came with it. For our sake, the curent attachment I am working with is jpg.

how can I get an image that is base64 encoded, then save it to a jpg file?

"Content-Transfer-Encoding: base64"

Hello,
I'm trying to send an email with a PDF attachment. The email is sending, but the attachment will not open. Any help you can give is appreciated. Code snippets below:

function mail_attachment($filename, $path, $mailto, $from_mail, $from_name, $replyto, $subject, $message) {
    $file = $path.$filename;
    $file_size = filesize($file);
    $handle = fopen($file, "r");
    $content = fread($handle, $file_size);
    fclose($handle);
    $content = chunk_split(base64_encode($content));
    $uid = md5(uniqid(time()));
    $name = basename($file);
    $header = "From: ".$from_name." <".$from_mail.">\r\n";
    $header .= "Reply-To: ".$replyto."\r\n";
    $header .= "MIME-Version: 1.0\r\n";
    $header .= "Content-Type: multipart/mixed; boundary=\"".$uid."\"\r\n\r\n";
    $header .= "This is a multi-part message in MIME format.\r\n";
    $header .= "--".$uid."\r\n";
    $header .= "Content-type:text/plain; charset=iso-8859-1\r\n";
    $header .= "Content-Transfer-Encoding: 7bit\r\n\r\n";
    $header .= $message."\r\n\r\n";
    $header .= "--".$uid."\r\n";
    $header .= "Content-Type: application/pdf; name=\"".$filename."\"\r\n"; // use different content types here
    $header .= "Content-Transfer-Encoding: base64\r\n";
    $header .= "Content-Disposition: attachment; filename=\"".$filename."\"\r\n\r\n";
    $header .= $content."\r\n\r\n";
    $header .= "--".$uid."--";
    if (mail($mailto, $subject, "", $header)) {
        print("mail send ... OK"); // or use booleans here
    } else {
        print("mail send ... ERROR!");
    }
}

$my_file = "Adol_Packet_v2.pdf";
$my_path = $_SERVER['DOCUMENT_ROOT']."/homepages/35/d350375870/htdocs/html/";
$my_name = "Company Name";
$my_mail = "atheneris@yahoo.com";
$my_replyto = "atheneris@yahoo.com";
$my_subject = "Welcome Email From Carlock & Associates";

$my_message = "Test Message";

mail_attachment($my_file, $my_path, $email_to, $my_mail, $my_name, $my_replyto, $my_subject, $my_message);

Hi all,
is it possible to force download a file as an attachment using ajax?

Thanks

Hi all

I'm trying to send an automated email of a zip file.  However it seems to be just reading the files into the body of the mail rather than attaching a single zip archive containing several files.

I receive the mails, but I effectively want a blank message body with a zip file attached.

Please see code below, any ideas why this is not working.  I'm a bit of a newbie and never used this before so any pointers would be good.

<?php
//Send Zip file as attachment

//Set Email and attachment details
$to = "me@123.com";
$from = "Visionnet <DO_NOT_REPLY>";
$subject = "Subject";
$message = "Please see attached file";
$fileatt = "wiki_zip.zip";
$fileatt_type = "application/zip";
$fileatt_name = "wiki_zip.zip";


//Read in the attachment
$file=fopen($fileatt,'rb');
$data=fread($file,filesize( $fileatt));
fclose($file);

//Add the MIME content

$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";

// Add the Headers for file attachment

$headers .= "\nMIME-Version: 1.0\n" . 
"Content-Type: multipart/mixed;\n" . 
" boundary=\"{$mime_boundary}\"";
$message = "This is a multipart message in MIME format.\n\n" . "--{$mime_boundary}\n" . "Content-Type: text/plain; charset=\"iso-8859-1\"\n" . "Content-Transfer-Encoding: 7bit\n\n" . $message . "\n\n";

//Base64 encode file data
$data = chunk_split(base64_encode($data));

//Add attachment to message

$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";

//Send message
$ok = @mail($to, $subject, $message, $headers, "$from");
if($ok)
{
echo "mail sent";
}
else
{
echo "mail failed";
}

?>

Hi all
Im sending a dynamic created pdf file with php. It gets flagged as spam are things that can be done to help prevent this ?
didnt really know where to post it.

Hey guys I'm using a php based form for my website to take contact information and an attachment from a user and it sends it to my company email address. All the email account information is correct because when I open the message up in Microsoft Outlook I get the information and the attachments. However, when I try to open up the message on my iPhone 4, I just get information with no attachments.

I frequently check my email from my iPhone because sometimes I am not able to make it to my computer to use Outlook. I would really like for this to work and would appreciate any help you guys have.

Not sure if it is needed but here is the code for the from I use:

<?php

//turn off error reporting --easily commented out for development, but keeps site visitors from seeing any random thrown errors
error_reporting(0); 
// specify the recipients and subject
$to = "test@mywebsite.com";
$subject = "Someone Has Requested A Quote";
//grab all our vars from the form
extract($_POST);
//build the body of the message from the form
$body = "
The Quote Requested
Name: $fname $lname
Company: $company
Phone Number: $phone
Ext: $phoneext
Description: $description
Best time to call: $call
";
 
    //Let's start our headers
    $headers = "From:noreply@mywebsite.com\r\n";
    //$headers .= "Reply-To:PUT_YOUR_EMAIL_ADDRESS_OR_VARIABLE_HERE\r\n"; 
    $headers .= "MIME-Version: 1.0\n";
    $headers .= "Content-Type: multipart/related; type=\"multipart/alternative\"; boundary=\"----=MIME_BOUNDRY_main_message\"\n"; 
    $headers .= "X-Sender:noreply@mywebsite.com\r\n";
    $headers .= "X-Mailer: PHP5\n";
    $headers .= "X-Priority: 3\n"; //1 = Urgent, 3 = Normal
    //$headers .= "Return-Path:PUT_YOUR_EMAIL_ADDRESS_OR_VARIABLE_HERE\r\n"; 
    $headers .= "This is a multi-part message in MIME format.\n";
    $headers .= "------=MIME_BOUNDRY_main_message \n"; 
    $headers .= "Content-Type: multipart/alternative; boundary=\"----=MIME_BOUNDRY_message_parts\"\n"; 
    
    $message = "------=MIME_BOUNDRY_message_parts\n";
    $message .= "Content-Type: text/plain; charset=\"iso-8859-1\"\n"; 
    $message .= "Content-Transfer-Encoding: quoted-printable\n"; 
    $message .= "\n"; 
    /* Add our message, in this case it's plain text.  You could also add HTML by changing the Content-Type to text/html */
$message .= "$body\n"; 
        $message .= "\n";  
        $message .= "------=MIME_BOUNDRY_message_parts--\n";  
        $message .= "\n";  
/*deal with mulitple attachments */
        foreach($_FILES as $file => $value) { 
            $_tmpname = $_FILES[$file]['tmp_name']; 
            $_filename = $_FILES[$file]['name']; 
            if (is_uploaded_file($_tmpname)) { //Do we have a file uploaded? 
                $fp = fopen($_tmpname, "rb"); //Open it 
                $data = fread($fp, filesize($_tmpname)); //Read it 
                $data = chunk_split(base64_encode($data)); //Chunk it up and encode it as base64 so it can emailed 
                $message .= "------=MIME_BOUNDRY_main_message\n";  
                $message .= "Content-Type: application/octet-stream;\n\tname=\"" . $_filename . "\"\n"; 
                $message .= "Content-Transfer-Encoding: base64\n"; 
                $message .= "Content-Disposition: attachment;\n\tfilename=\"" . $_filename . "\"\n\n"; 
                $message .= $data; //The base64 encoded message 
                $message .= "\n\n"; 
                fclose($fp); 
            } 
        } 
     
        $message .= "------=MIME_BOUNDRY_main_message--\n";  
 
// set specific SMTP for this message - you may not need this, but I have to manually set the SMTP because it is not localhost
ini_set('SMTP','mail.mywebsite.com');
// send message to recipients
@mail( $to, $subject, $message, $headers );
// redirect to thank you page after sending email
header("Location: http://www.mywebsite.com/quoteComplete.html"); ?> 

Hi All,

I have a form which POSTs data through to PHP, it then places this on a HTML mail and then emails the company. I then have two attachment fields on the form, one for their CV and the other for some sort of ID.

The attachments appear on the HTML email but when you try and open them or download and open them they come up with an error as though they are corrupt. However the odd thing is if I open it on my iPhone the attachments work perfect. Its not just my PC at fault as it doesnt work on many computers/OS's.

The actual PHP attachment code is below:

Code: [Select]
<?php

$unid = md5(time());

for($i=0;$i<count($_FILES["fileAttach"]["name"]); $i++) {  

if($_FILES["fileAttach"]["name"][$i] != "") { 

$filename = $_FILES["fileAttach"]["name"][$i];  
$attachment = chunk_split(base64_encode(file_get_contents($_FILES["fileAttach"]["tmp_name"][$i])));  
$mailheader .= "--" . $unid . "\n";  
$mailheader .= "Content-Type: multipart/mixed; name=" . $filename . "\n";  
$mailheader .= "Content-Transfer-Encoding: base64"."\n";  
$mailheader .= "Content-Disposition: attachment; filename=" . $filename . "\n";  
$mailheader .= $attachment;

} }
?>

What am I doing wrong. More code can be provided if needed.

Cheers in advance!

Hey All,

I am having issues understanding how this works. I am trying to do a quote and send out 5 images of the product. I cannot seem to get how I get the images sent with the email.

If anyone can take a look I would greatly appreciate it.

PHP

<?php

    $email = $_POST ['email'];
    $quote = $_POST ['quote'];
    $item = $_POST ['item'];
    $inventory = $_POST ['inventory'];
    $category = $_POST ['category'];
    $manu = $_POST ['manu'];
    $model = $_POST ['model'];
    $condition = $_POST ['condition'];
    $dimension = $_POST ['dimension'];
    $desc = $_POST ['desc'];
    $skidprice = $_POST ['skidprice'];
    $unitprice = $_POST ['unitprice'];
    $totalprice = $_POST ['totalprice'];
    $img1 = $_POST ['img1'];
    $img2 = $_POST ['img2'];
    $img3 = $_POST ['img3'];
    $img4 = $_POST ['img4'];
    $img5 = $_POST ['img5'];
    
    
    



    
//Get the uploaded file information
$name_of_uploaded_file =
    basename($_FILES['uploaded_file']['name']);
//get the file extension of the file
$type_of_uploaded_file =
    substr($name_of_uploaded_file,
    strrpos($name_of_uploaded_file, '.') + 1);
$size_of_uploaded_file =
    $_FILES["uploaded_file"]["size"]/1024;//size in KBs
    
//Validations
if($size_of_uploaded_file > $max_allowed_file_size )
{
  $errors .= "\n Size of file should be less than $max_allowed_file_size";
}
//------ Validate the file extension -----
$allowed_ext = false;
for($i=0; $i<sizeof($allowed_extensions); $i++)
{
  if(strcasecmp($allowed_extensions[$i],$type_of_uploaded_file) == 0)
  {
    $allowed_ext = true;
  }
}
if(!$allowed_ext)
{
  $errors .= "\n The uploaded file is not supported file type. ".
  " Only the following file types are supported: ".implode(',',$allowed_extensions);
}


//copy the temp. uploaded file to uploads folder
$path_of_uploaded_file = $upload_folder . $name_of_uploaded_file;
$tmp_path = $_FILES["uploaded_file"]["tmp_name"];
if(is_uploaded_file($tmp_path))
{
  if(!copy($tmp_path,$path_of_uploaded_file))
  {
    $errors .= '\n error while copying the uploaded file';
  }
}
    
    
    
    // Always set content-type when sending HTML email
    $headers = "MIME-Version: 1.0" . "\r\n";
    $headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";

    // More headers
    $headers .= 'From: All Food Equipment<sales@allfoodequip.com>' . "\r\n";

    $headers .= "Message-ID: <".$now." sales@".$_SERVER['SERVER_NAME'].">\r\n";
    $headers .= "X-Mailer: PHP v".phpversion()."\r\n";         
 
    $subject = "Your All Food Equip Quote";
    
    $msg = 
            "    
            <!DOCTYPE html PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\" \"http://www.w3.org/TR/REC-html40/loose.dtd\">
<html>
<head><link href=\"http://www.allfoodequip.com/admin/quote/style.css\" rel=\"stylesheet\" type=\"text/css\"></head>
<body>
<div id=\"container\" style=\"width:960px;
    height:auto;
    margin:0 auto;
    border-right: 2px solid #666;
    border-left: 2px solid #666;\">
<div id=\"header\"       style=\"background-image:url(http://www.allfoodequip.com/admin/quote/images/banner_bg.jpg);
    width:100%;
    height:149px;\"></div>
<!--Closes header-->
<div id=\"subHead\" 
style=\"background-image:url(http://www.allfoodequip.com/admin/quote/images/menu_bg.jpg);
    width:100%;
    height:42px;\"></div>
<!--closes subHead-->
<div class=\"contents\" style=\"background:#f2f1f1;
    padding-right: 25px;
    padding-left: 25px;\">
  <h1 style=\"margin:0px;padding:10px 0 5px;font-size:18px;\">Your All Food Equipment Quote:</h1>
  <table width=\"700\" border=\"0\" class=\"table\" style=\"padding:0px 0px 15px;\">
<tr>
<td width=\"119\">Quote #:......................................................... </td>
      <td width=\"208\">$quote</td>
    </tr>
<tr>
<td>Item:..............................................................</td>
      <td>$item</td>
    </tr>
<tr>
<td>Inventory:.......................................................</td>
      <td>$inventory</td>
    </tr>
<tr>
<td>Category:.......................................................</td>
      <td>$category</td>
    </tr>
<tr>
<td>Manufacturer:.................................................</td>
      <td>$manu</td>
    </tr>
<tr>
<td>Model:...........................................................</td>
      <td>$model</td>
    </tr>
<tr>
<td>Condition:......................................................</td>
      <td>$condition</td>
    </tr>
<tr>
<td>Dimension:....................................................</td>
      <td>$dimension</td>
    </tr>
<tr>
<td>Description:...................................................</td>
      <td>$desc</td>
    </tr>
    <br>
<tr>
<td><b>Skid Price:</b>.................................................</td>
      <td><b>$skidprice</b></td>
    </tr>
<tr>
<td><b>Unit Price:</b>.................................................</td>
      <td><b>$unitprice</b></td>
    </tr>
<tr>
<td><b>Total Price:</b>................................................</td>
      <td><b>$totalprice</b></td>
    </tr>
</table>
<div class=\"t_middle\"> <img name=\"Img\" src=\"$img1\" width=\"177\" height=\"115\" alt=\"Img\" style=\"background-color: #999999\"><img name=\"Img\" src=\"$img2\" width=\"177\" height=\"115\" alt=\"Img\" style=\"background-color: #999999\"><img name=\"Img\" src=\"$img3\" width=\"177\" height=\"115\" alt=\"Img\" style=\"background-color: #999999\"><img name=\"Img\" src=\"$img4\" width=\"177\" height=\"115\" alt=\"Img\" style=\"background-color: #999999\"><img name=\"Img\" src=\"$img5\" width=\"177\" height=\"115\" alt=\"Img\" style=\"background-color: #999999\">
</div>
 
  <div class=\"break\" style=\"padding: 15px 0px;
    width:100%;\"><hr></div>
<!--break-->
  <!--close t_middle-->
 
  <div class=\"contactUs\">
    <p style=\"color:#650035;\">How to contact us:</p>
    <ul class=\"contact_list\" style=\"margin:0px;padding:0px;color:#650035;line-height:25px;padding-bottom:30px;list-style:none;\">
<li>Visit us Online: www.allfoodequip.com</li>
      <li>Contact: Dino Roberts</li>
      <li>Direct Line: 615-788-2953 </li>
      <li>Email: dino@allfoodequip.com</li>
    </ul>
<ul class=\"contact_list\" style=\"margin:0px;padding:0px;color:#650035;line-height:25px;padding-bottom:30px;list-style:none;\">
<li>All Food Equipment</li>
      <li>1240 Industrial Park Road</li>
      <li>Columbia, TN 38401</li>
      <li>Main Office: 931-490-1977</li>
    </ul>
</div>
  <p style=\"font-size:14px;color:#333;\">TERMS &amp; CONDITIONS: </p>
  
</div>
<!--close m_disc-->
 
<div id=\"footer\" style=\"clear: both;
    width: 100%;
    padding: 20px 0 20px 0;
    text-align: center;
    border-top: 1px solid #8b8a8b;
    background: #343233 url(http://www.allfoodequip.com/admin/quote/images/footer.jpg) no-repeat;\">
  <ul class=\"footer_list\" style=\"margin:0px;padding:0px;list-style:none;\">
<li style=\"padding: 0 10px;
    display: inline;
    border-right: 1px solid #cccccc;\"><a href=\"http://www.allfoodequip.com\" style=\"color: #cccccc;
    text-decoration: none;\">Home</a></li>
    <li style=\"padding: 0 10px;
    display: inline;
    border-right: 1px solid #cccccc;\"><a href=\"http://www.allfoodequip.com/new-equipment.php\" style=\"color: #cccccc;
    text-decoration: none;\">New Equipment</a></li>
    <li style=\"padding: 0 10px;
    display: inline;
    border-right: 1px solid #cccccc;\"><a href=\"http://www.allfoodequip.com/used-equipment.php\" style=\"color: #cccccc;
    text-decoration: none;\">Used Equipment</a></li>
    <li style=\"padding: 0 10px;
    display: inline;
    border-right: 1px solid #cccccc;\"><a href=\"http://www.allfoodequip.com/services.php\" style=\"color: #cccccc;
    text-decoration: none;\">Services</a></li>
    <li style=\"padding: 0 10px;
    display: inline;
    border-right: 1px solid #cccccc;\"><a href=\"http://www.allfoodequip.com/about-us.php\" style=\"color: #cccccc;
    text-decoration: none;\">About Us</a></li>
    <li class=\"last\" style=\"padding:0 10px;display:inline;border-right:none;\"><a href=\"http://www.allfoodequip.com/contact-us.php\" style=\"color: #cccccc;
    text-decoration: none;\">Contact Us</a></li>
  </ul>
<div class=\"margin_bottom_10\"></div><br>
  <span style=\"color:#FFF;\">Copyright &copy; 2010 </span> - <a href=\"http://www.allfoodequip.com\"><font color=\"#FFFFCC\">All Food Equipment</font></a>
  <div class=\"margin_bottom_10\"></div>
  <!-- end of footer --> 
 
</div>
<!--container-->
 
</div>
</body>
</html>
";
            
    // MAIL SUBJECT
     $subject = "Your All Food Equip Quote";
    // TO MAIL ADDRESS
    $to="$email";
    
    

mail($to, $subject, $msg, $headers);




// Redirect
header("Location: Admin.php?Msg=Sent");

?>


Heres the HTML side of it.
Code: [Select]
   <label for="img1">Image 1:</label>
<input type="hidden" name="MAX_FILE_SIZE" value="2500000"> <input type="file" name="img1">


<label for="img2">Image 2:</label>
<input type="hidden" name="MAX_FILE_SIZE" value="2500000"> <input type="file" name="img2">


<label for="img3">Image 3:</label>
<input type="hidden" name="MAX_FILE_SIZE" value="2500000"> <input type="file" name="img3">


<label for="img4">Image 4:</label>
<input type="hidden" name="MAX_FILE_SIZE" value="2500000"> <input type="file" name="img4">


<label for="img5">Image 5:</label>
<input type="hidden" name="MAX_FILE_SIZE" value="2500000"> <input type="file" name="img5"><br />

Thanks in advance.

I found the below code so I can attach a file to a email message, but there is a small problem I need some help with.  The script works beautifully except for the fact that when message is received the attached file does not contain a file extension.  I am able to open the attachment but I am receiving the windows dialog box that asks:  "Choose the program you want to open this file".  I intend on only using this script to attach HTML files so I am wondering if there is a way to make the file extension of the attachment read as .html?  That way when the user receives the attachment it will automatically open with there default browser. 


Code: [Select]
<?php  
$to = "test@test.com"; 
$from = "test@test.com"; 
$subject = "AHC"; 
$message = "hello world";
$fileatt = $_SERVER['DOCUMENT_ROOT']."/home-care-information/test.html";

$fileatt_type = "multipart/alternative"; //This is where the problem is I think

$fileatt_name = "Application";

$headers = "From: $from";

$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}\"";

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

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

$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($to, $subject, $message, $headers); 

if ($ok) { echo "<p>Mail sent! Yay PHP!</p>"; } 
else { echo "<p>Mail could not be sent. Sorry!</p>"; } 

?>

Hi,

Since the latest versions of Access (2007/2010) it's possible to add attachments to rows. I have such a database with members and their photos, but i would like to export them (including photos) and use them for a new webapplication. I have made a XML-export with Access 2007. The photos which i have attached are encoded in the XML export.

Please find below an example of the file smiley.jpg, which i have attached in a random row in my database.
(The original file smiley.jpg you may find back he http://img812.imageshack.us/img812/8248/smileyq.jpg)

XML-export generated by Access 2007
Code: [Select]
<Foto>
<FileData>FAAAAAEAAAAEAAAAagBwAGcAAAD/2P/gABBKRklGAAEBAQBkAGQAAP/bAEMAAwIC
AwICAwMDAwQDAwQFCAUFBAQFCgcHBggMCgwMCwoLCw0OEhANDhEOCwsQFhARExQV
FRUMDxcYFhQYEhQVFP/bAEMBAwQEBQQFCQUFCRQNCw0UFBQUFBQUFBQUFBQUFBQU
FBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFP/AABEIACgAKAMBIgAC
EQEDEQH/xAAbAAACAgMBAAAAAAAAAAAAAAAABgUHAQgJA//EADIQAAIABAMFBgYC
AwAAAAAAAAECAwQFEQAGEgcTFSExCBRRYYGRCSIkMkGxM3GCodH/xAAYAQADAQEA
AAAAAAAAAAAAAAAEBQgHBv/EACgRAAIBAwMDBAIDAAAAAAAAAAECEQADBAUhMQYS
QQciYYETURRxkf/aAAwDAQACEQMRAD8A6nxoyS8Mu5soxAz1VnI9xBPd4fiBdj64
KpP7+omCD8kHl/l+f+Y0T+KR2m9ofZ+puziHkKomi8Um5qPOTywEi69wIOiCdakB
W3rEjqdAF7XxmWp6te1TLOlafd7GkiZiSASdxuAIjbmjUthF73FbnzMSoKxZZ+YD
eG9NvbBI5yqFMihZ0d8l782AAdR+j6++FSo5xqSbIouaBTTxhaEakKaQf5+77zdW
6/d8vjjUT4aHaJz92gKDtAXPdQasmlzktElJ5oCQiN+IpeCNCgWTdqQOo126WxO7
6h1FgWcnWsDLITHZAwLEz3tA9pkHfmfqmwS0xW2y810ekp2DUZZJiXiCJCcXDDBh
GyZUGp1ZMizfTzNyoPQOBe/qBb2wYp/o/qW31VpKZ6jtee1x+mETHwQQR8GKS5Fk
2LhWstMlavPq33CO/tqNsQGYMv5U2nU+Xh1qj0vMsnIzpiwUqEqkwkGZguyFlDgg
OrBluPMYlNodBVp12imOslO21NLx3gsHFrjWhDC9gevPmOmKRg54idngvR80S802
zxXZqTmaWgvHh02ETcSs6FBaGqE6UjkFCmkOVZbvKGvPn4Gr5eEs/mVyVA2LKSSC
vkkggwN4mJinloK1tW8VeUaNqwq0LLGVtmdOiwKLSKZlqRnJwRIkOnyqS8OLMRWC
BmCAAszFVuevIeGIM9oHZeKXxI7RsqcP06u88altFv714Uouc37Q8SHS8tSs1D2d
7xYlUzJNQXgJU0Uhu6ySuAzo5ADx7BdGpULM2pM2/i5+QzNkq1u1PuJBA2/uAW57
V5J480Z3IONzV0St+P0zT92/T2uL/wCsGPfZ3l9EnUeFv2k5LUEaYjvGdnN+RdyW
NrnqeXIdMGK49HtOvYehXL9wELdclZ2lQAJ+yD/lIdQcNdAHgVYU9IwKlKvLzCCJ
Cccwf2PPCNUMm1Gmuxk/rZf8C4DgeYPI+ntgwY7vqjo/Sep7U56HvUbOphgOYmCC
Pggx4ihrGRcsn2mkYbI8vCrcQGz2liqatffODQt7q8d5ovfzvh5p+TajUnUzv0Uv
+VuC5HkOg9fbBgxknTvp1o2bktczGuXRb4VmEfcAGPgEUdey7irCwJp6kZGDTpVJ
eXQQ4SCwA/Z88GDBikbVpLKLatKFVRAA2AA4AH6pQSSZNf/Z
</FileData>
<FileName>smiley.jpg</FileName>
<FileType>jpg</FileType>
</Foto>
It seems to be encoded with base64, but as soon as i try to decode it using the function base64_decode(), i don't get a valid output back. I have found some additional data back in the XSD-file, which is automatically generated when you make an XML-export in Access. There it seems to refer to base64, so i don't know what's going wrong.

Code: [Select]
<xsd:element name="FileData" minOccurs="0" od:jetType="oleobject" od:sqlSType="image">
<xsd:simpleType>
<xsd:restriction base="xsd:base64Binary">
<xsd:maxLength value="1476395008"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
I have tried the following code, to get the image back ($data is filled with the encoded stuff from the XML-export):

Code: [Select]
<?php
header('Content-Type: image/jpeg');
echo base64_decode($data);
?>
I have looked on several websites, but i can't find a solution for this issue. The main goal is to export approx. 2500 members (with photos attached) from Access 2007. The data can be exported easily, but it's all about the photos which make it complicated.