php - 如何通过 phpmailer 在 PHP 和 MySQL 中发送多封电子邮件

Question

我有一个问题。当我点击发送按钮时，只有 zxc@hotmail.com 收到邮件。

如何改变呢？我正在使用 Gmail SMTP 发送。

数据库中有2条记录:

这是我的代码:

include "phpmailer/class.phpmailer.php";
$host = "localhost";
$user = "root";
$pass = "root";
$db = "mailTest";

mysql_connect($host, $user, $pass);
mysql_select_db($db);

$query = "SELECT email FROM list";

$recordset = mysql_query($query);
$row_recordset = mysql_fetch_assoc($recordset);
$tota_row_recordset = mysql_num_rows($recordset);
$msg = strip_tags($_POST['msg']);
$mail= new PHPMailer(); //建立新物件 
while($row = mysql_fetch_array($recordset))
{
    $to = $row['email'];
    $mail->AddAddress($to, "Test Message"); 
}      
$mail->IsSMTP();    
$mail->SMTPAuth = true;
$mail->SMTPSecure = "ssl";
$mail->Host = "smtp.gmail.com";     
$mail->Port = 465;      
$mail->CharSet = "big5";
$mail->Subject = "Test Message";     
$mail->Username = "xxxxxx";    
$mail->Password = "xxxxxx";   
$mail->Body = "$msg";
$mail->IsHTML(true);           
if(!$mail->Send()) {      
echo "Mailer Error: " . $mail->ErrorInfo;       
} else {      
header('Location: index.php');
}

Answer 1

在这个循环中，每次迭代都会覆盖收件人，因此只有最后一个人会留下来接收电子邮件:

while($row = mysql_fetch_array($recordset))
{
    $to = $row['email'];
}
$mail = new PHPMailer(); 

将您的代码更改为

$mail = new PHPMailer(); // create object FIRST
while($row = mysql_fetch_array($recordset))
{
    $to = $row['email'];
    $mail->AddAddress($to, "Test Message"); // add each DB entry to list of recipients
}