Name: How do you create a csv file from a while loop and attach it to an email in php?
Rating: 5 (2286 reviews)

Message:

This question already has answers here:

My Answer:
How to create a CSV file in PHP and send as an email attachment

Here is an example code snippet that demonstrates how to create a CSV file from a while loop and attach it to an email in PHP:

php

// Create a CSV file

$csv_file = fopen('data.csv', 'w');

while ($row = $result->fetch_assoc()) {

    fputcsv($csv_file, $row);

}

fclose($csv_file);



// Send email with CSV file attachment

$to = 'recipient@example.com';

$subject = 'CSV File Attachment';

$message = 'Please find the attached CSV file.';

$from = 'sender@example.com';



$file = 'data.csv';

$content = file_get_contents($file);

$content = chunk_split(base64_encode($content));



$attachment = "Content-Type: application/octet-stream; name=\"" . basename($file) . "\"\r\n";

$attachment .= "Content-Transfer-Encoding: base64\r\n";

$attachment .= "Content-Disposition: attachment\r\n\r\n";

$attachment .= $content . "\r\n";



$headers = "From: $from\r\n";

$headers .= "MIME-Version: 1.0\r\n";

$headers .= "Content-Type: multipart/mixed; boundary=\"boundary\"\r\n";

$headers .= "--boundary\r\n";

$headers .= "Content-Type: text/plain; charset=\"ISO-8859-1\"\r\n";

$headers .= "Content-Transfer-Encoding: 7bit\r\n\r\n";

$headers .= $message . "\r\n";

$headers .= "--boundary\r\n";

$headers .= $attachment . "\r\n";

$headers .= "--boundary--";



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



// Delete the CSV file after sending the email

unlink('data.csv');

This code snippet first creates a CSV file from a while loop and then attaches it to an email using the `mail()` function in PHP. The CSV file is deleted after the email is sent.

Rate this post

5 of 5 based on 2286 votes