Solved

get csv and email it

Posted on 2006-06-20
3
192 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
  • 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This article discusses how to create an extensible mechanism for linked drop downs.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now