Solved

get csv and email it

Posted on 2006-06-20
3
199 Views
Last Modified: 2006-11-18
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
Comment
Question by:livegirllove
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 36

Accepted Solution

by:
Zyloch earned 500 total points
ID: 16946782
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
 
LVL 1

Author Comment

by:livegirllove
ID: 16946849
$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
 
LVL 1

Author Comment

by:livegirllove
ID: 16946851
thanks
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help with mod_substitute 18 71
PHP Web Development 6 61
How difficult would it be build a cookie scanner in PHP? 21 51
Google Recaptcha 13 42
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to implement server side field validation and display customized error messages to the client.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question