How do you create a csv file from a while loop and attach it to an email in php?

Question

Ive been on this for a while. What I am trying to do is create a CSV file from the while loop with CODE & QUANTITY then attach it to the email below then send. Any help would be greatly appreciated

$sql = mysql_query("SELECT code, quantity 
                    FROM table 
                    WHERE active = '1' 
                    ORDER BY code Asc");

while($row = mysql_fetch_array($sql)){
    $code = $row['code'];
    $quantity = $row['quantity'];   
    //CREATE CSV FILE HERE I THINK?
}


$to = “email@gmail.com” ;
$from = “email@website.com”;
$subject = “Inventory”;
$message = ''<html>Code</html>'';    

$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
$headers .= 'From: Inventory' . "\r\n";
      
mail($to, $subject, $message, $headers);

I want it to look something like this. The .csv file will be an attachment and Ill still display the regular email below it.

attach it as a .csv file to download in the email. I still want the regular html email to display but with the file as an attachment. — BTR383434, Mar 27 '21 at 21:46

score 0 · Answer 1 · answered Mar 27 '21 at 22:22

0

Here you go. But You need the PHPMailer. Learn how to set up PHPMailer on shared hosting

function create_cvs_from_db($sql)
{
    // create a temp location in memory with 5MB
    $csv = fopen('php://temp/maxmemory:' . (5 * 1024 * 1024), 'r+');

    // add the headers
    fputcsv($csv, array("code", "quantity"));
    // the loop
    while ($row = mysql_fetch_array($sql)) {
        $code = $row['code'];
        $quantity = $row['quantity'];
        // creates a valid csv string
        fputcsv($csv, array($code, $quantity));

    }

    rewind($csv);
    // return the the written data
    return stream_get_contents($csv);

}

// you need to setup PHPMailer
$mail = new PHPMailer();

// configurations

$mail->isSMTP();
$mail->Host = 'smtp.mailtrap.io';
$mail->SMTPAuth = true;
$mail->Username = '1a2b3c4d5e6f7g'; //your mail username
$mail->Password = '1a2b3c4d5e6f7g'; //your mail password
$mail->SMTPSecure = 'tls';
$mail->Port = 2525;


// now the fun part
$mail->setFrom('info@mailtrap.io', 'Mailtrap');
// the subject of the email
$mail->Subject = 'Test Email via Mailtrap SMTP using PHPMailer';
// if your mail body uses html
$mail->isHTML(true);
$mailContent = "";
$mail->Body = $mailContent;

/**
 * now here you attach your file
 */
// the cvs extension is very important
$filename = "summary.cvs";
$mail->addStringAttachment(create_cvs_from_db($sql), $filename);

// now send  the mail

if ($mail->send()):
    echo 'Message has been sent';
else:
    echo 'Message could not be sent.';
    echo 'Mailer Error: ' . $mail->ErrorInfo;
endif;

answered Mar 27 '21 at 22:22

Jwan

177
3
12

You dont NEED `phpMailer` to send attachments, it may make it easier, but you can do it all manually and use `mail()` – RiggsFolly Mar 28 '21 at 17:42
How can you use mail to attach a csv file. Ive been searching for 2 days – BTR383434 Mar 28 '21 at 18:59
I know that he doesn't need it. But for what I wrote is PHPMailer necessary – Jwan Mar 28 '21 at 19:39
@BTR383434 As a beginner use `PHPMailer`. As you develop if you want you can switch to `mail()` – Jwan Mar 28 '21 at 19:41
@BTR383434 You can't install it or you can't use it? – Jwan Mar 28 '21 at 19:48
I am now creating and saving the csv file into a directory before its emailed. I don't know why its so hard to just add a file attachment I can't figure it out. PHPMailer isn't working for me and Im seeing Godaddy has issues with it. – BTR383434 Mar 28 '21 at 19:51
Can you provide screenshots of the problem? – Jwan Mar 28 '21 at 19:53
The problem is probably in the configurations somewhere – BTR383434 Mar 28 '21 at 20:02
The `mail()` function I think it's autoconfigured. The `PHPMailer` needs configuration. – Jwan Mar 28 '21 at 20:06

How do you create a csv file from a while loop and attach it to an email in php?

1 Answers1