如何将电子邮件发送到包含其他数据的从数据库中获取的电子邮件数组 - How do I send email to an array of email fetched from database with other data

How do I send email to an array of email fetched from database with other data

我一直在使用phpmailer发送批量电子邮件时遇到问题，但是单个电子邮件没有问题。

这是我的代码：

$result = mysql_query("select * from $to",$conn) or die("list 
            selected  ($to) does not exist ".mysql_error());
while ($row = mysql_fetch_array($result))
{           
    $email[] = $row['email'];           
    $student[] = $row['name'];
}
foreach ($email as $val => $uemail) {
    $email = $uemail;
    $students= $student[$val] ;
    require("class.phpmailer.php");
        $mail = new PHPMailer(true); 
    try {
           $mail->AddReplyTo('info@bratim.com', 'My Name');
           $mail->AddAddress("$email", "$student");
           $mail->SetFrom('info@me.com', 'MyName');
           $mail->AddReplyTo('info@me.com', 'My nameg');
           $mail->Subject = "$sub";
           $mail->MsgHTML("Dear $student<br> $msg <br>
             <img src='"$path'"> <p>
             $host_upper
            ______________________________________________________
            THIS IS AN AUTOMATED RESPONSE. 
            ***DO NOT RESPOND TO THIS EMAIL****
             ");
            $mail->AddAttachment("$path2");      // attachment
          $mail->Send();
          echo "Message Sent OK to $email  </p>'n";
    } catch (phpmailerException $e) {
        echo $e->errorMessage(); //Pretty error messages from PHPMailer
    } catch (Exception $e) {
        echo $e->getMessage(); //Boring error messages from anything else!
    } 
}

任何帮助，建议将不胜感激。

您可以在 while 循环中发送邮件：

<?php
require_once("class.phpmailer.php");
$result = mysql_query('SELECT `email`, `student`, `data1` FROM `students` ORDER BY `email` ASC;');
while ( $row = mysql_fetch_assoc($result) )
{
    $current_mail = new PHPMailer(true);
    $current_mail->AddReplyTo('info@bratim.com', 'My Name');
    // ....
    $current_mail->Send();
    unset($current_mail);
}
?>

您将$student[$val]分配给foreach内部的$students，但随后您将分配数组$student你的 phpmailer 对象：

$mail->AddAddress("$email", "$student");

不应该是

 $mail->AddAddress("$email", "$students");

除此之外，为

您必须发送的每封电子邮件实例化一个新的 mailer 对象是一个糟糕的做法，您应该只关注像 AddAddress 这样的动态变量，并将所有其他变量保留在外面以避免过载，并记住清除将要更改的变量，例如 AddAddress ，如下所示：

require_once("class.phpmailer.php");
$result = mysql_query("select * from $to",$conn) or die("list selected  ($to) does not exist ".mysql_error());
          while ($row = mysql_fetch_array($result))
    {
        $email[] = $row['email'];
        $student[] = $row['name'];
    }
$mail = new PHPMailer(true); 
try {
            $mail->AddReplyTo('info@bratim.com', 'My Name');
            $mail->SetFrom('info@me.com', 'MyName');
            $mail->AddReplyTo('info@me.com', 'My nameg');
            $mail->Subject = "$sub";
            $mail->AddAttachment("$path2"); 
            foreach ($email as $val => $uemail) {
                $email = $uemail;
                $students= $student[$val] ;
                $mail->AddAddress("$email", "$students");
                $mail->MsgHTML("Dear $student<br> $msg <br>
                <img src='"$path'"> <p>
             $host_upper
            ______________________________________________________
            THIS IS AN AUTOMATED RESPONSE. 
            ***DO NOT RESPOND TO THIS EMAIL****
             ");
              $mail->Send();
              $mail->ClearAddresses();
            echo "Message Sent OK to $email  </p>'n";
              }
            } catch (phpmailerException $e) {
        echo $e->errorMessage(); //Pretty error messages from PHPMailer
           } catch (Exception $e) {
          echo $e->getMessage(); //Boring error messages from anything else!
             } 
            }