试图在电子邮件中发送csv附件和正文文本


Trying to send csv attachment AND body text in email

我已经能够编写php脚本(与HTML) $_REQUEST在线表单数据输入或(1)写入CSV文件并将其作为附件以电子邮件发送,或(2)在任何电子邮件的正文中包含数据。

但是我不能同时做这两件事。我想要快速导入数据库的CSV,我希望电子邮件正文也包括详细信息,使航运部门有一个挑选清单的包装。我如何让这两个功能同时工作而不相互干扰?

提前谢谢你。

PHP脚本

        $to = "name@domain.com";
        $subject = "Order - " . $_Tech_Name;
        //Add the headers 
        $semi_rand = md5(time());
        $mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
        $headers = "MIME-Version: 1.0'n" .
                   "From: {$email_from}'n" .
                   "Content-Type: multipart/mixed;'n" .
                   " boundary='"{$mime_boundary}'"";
        // email body includes only fields not null
        $body = "";
        foreach ($_REQUEST as $Field=>$Value) { 
            if($Value != ''){
                $body .= "$Field: $Value'n'n";
            }
        }
        $email_body = "Here are the details: 'n'n $body";
        // csv file name format
        $today = date("m.d.y"); 
        $csv_name = "order - " . $_Tech_Name . " " . $today . ".csv";
        $fp = fopen($csv_name,'a');
        fwrite($fp,$data);
        fclose($fp);
        $attachments[] = Array(
           'data' => $data,
           'name' => $csv_name,
           'type' => 'application/vnd.ms-excel'
        );
       //Add sttachments
        foreach($attachments as $attachment){
           $data = chunk_split(base64_encode($attachment['data']));
           $name = $attachment['name'];
           $type = $attachment['type'];
           $message .= 
                      "--{$mime_boundary}'n" .
                      "Content-Type: {$type};'n" .
                      " name='"{$name}'"'n" .
                      "Content-Transfer-Encoding: base64'n'n" .
                      $data . "'n'n" ;
        }

**PHP SCRIPT -我已经隔离了以下附加脚本的问题,这是上面显示的脚本的一部分,但我还不明白为什么这是一个问题。通过注释掉$message(附件)或$email_body(仅体),我能够使其中一个或另一个工作。但是如果我把两个变量都留在那里,那么两者都不起作用**

        mail(
            $to, 
            $subject, 
            $message,     // for attachment only
        //  $email_body,  // for body only 
            $headers
            );

通过在我的原始帖子中隔离问题,我能够通过编写two(2)来使其工作。"mail"命令如下:

        // attachment 
        mail($to, $subject, $message, $headers);
        // body
        mail($to, $subject, $email_body, $headers);

我对这个解决方案很满意,但如果有人能找到一种方法来获得相同的电子邮件,包括正文内容并附加一个CSV,那将是理想的。