[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

get csv and email it

Hi.  I need to create a csv and then email it.

I create the csv like this:
$csv .= "$row[id],$row[date],$row[lead_id],$row[name],$row[lastname],$row[emailaddress],$row[address],$row[city],$row[st],$row[zip],$row[homephone],$row[workphone],NA,$row[best_time_to_call],$row[loanpurpose],$row[desired_loan_amount],$row[propertytype],$row[currentvalue],$row[first_balance],$row[rate],NA,$row[loantype],NA,LTV,$row[credit],NA,NA,NA,NA,$row[ipaddress]\n";
header('Content-type:application/save-as');
header('Content-disposition:attachment;filename='.$CSV_filename.'-'.$today.'.csv');
echo $csv;

opens the save as window....

Instead I would like to attach it to an email.  

Thanks
0
livegirllove
Asked:
livegirllove
  • 2
1 Solution
 
ZylochCommented:
Hi livegirllove,

I recommend you check out this page: http://www.sitepoint.com/article/advanced-email-php/5

which details how to send an attachment with email (PHP mail() function)

Regards,
Ted
0
 
livegirlloveAuthor Commented:
$file = 'uploads/juicy.csv';
$fh = fopen($file, "w");
$file_contents = $csv;
fwrite($fh, $file_contents);
fclose($fh);
$fileatt = "uploads/juicy.csv"; // Path to the file                
$fileatt_type = "application/octet-stream"; // File Type
$fileatt_name = "juicy.csv"; // Filename that will be used for the file as the attachment

$email_from = "support@equotegrabber.com"; // Who the email is from
$email_subject = "leads requested"; // The Subject of the email
$email_txt = "here they are"; // Message that the email has in it

$email_to = "support@solohelp.com"; // Who the email is too

$headers = "From: ".$email_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}\"";

$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!");
}
0
 
livegirlloveAuthor Commented:
thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now