php - 使用PHP脚本、MySQL数据库发送群发邮件

Question

我想使用 PHP 邮件功能发送大量电子邮件。电子邮件地址存储在 MySQL 数据库中。有近 30k 个电子邮件地址。我一次发送一封电子邮件。

60 封电子邮件已正确发送，接下来的所有电子邮件都将被跳过。我正在使用 godaddy 主机发送电子邮件。以下是我正在使用的代码

<?php 

$con1=mysqli_connect("subscibe","subscibe","pw","subscibe");

$subject = $_POST['subject'];        
$message = $_POST['message'];

$getusers = mysql_query("SELECT * FROM subscibe.emaillist");
$email_from = "email@gmail.com";
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();

while($result = mysql_fetch_array($getusers)) {

$emailaddress = $result['Emailaddresses'];

mail($emailaddress,$subject,$message,$headers);

//Add email address to temp table
$sqlq="INSERT INTO subscibe.temp VALUES ('$emailaddress')";

if (!mysqli_query($con1,$sqlq)) {
die('Error: ' . mysqli_error($con1));
}
}

echo "Emails are sent"

?>

Answer 1

您可能希望使用 foreach 循环将电子邮件发送到数据库中的每条记录。像这样的东西:

$getusers = mysql_query("SELECT * FROM subscibe.emaillist");
foreach ($getusers as $maillist) {
$mail->to($mailist['email_address']);
$mail->send()