向从mysqli数据库检索到的多个收件人发送一封电子邮件


Send single email to multiple recipients retrieved from the mysqli database

我正在尝试创建一个php页面,一旦数据库中的某个项目更新,它就会向链接到该项目的任何用户发送电子邮件。我的代码检索电子邮件地址,并将它们放在数组中。问题是电子邮件没有发送,我哪里出了问题?

<?php
require_once 'config/init.php';
$id = $_GET['id'];
$mysqli_conn = new mysqli($db['hostname'],$db['username'],$db['password'], $db['database']);
        if ($mysqli_conn -> connect_errno) {//check the connection
            print "Failed to connect to MySQL: (" . $mysqli_conn -> connect_errno . ") " . $mysqli_conn -> connect_error;
        }
$result = $mysqli_conn->query("SELECT * From Logins")
$headers.= "'r'n";
$headers.= "Content-type: text/html'r'n";
$to = '';
$headers.="Bcc: ";
while ($row = $result->fetch_array()) {
    $headers.=$row['Email'].", ";
    //$to.=$row['Email'].", ";
}
$subject = "Subject";
$headers.="'r'n";
$mailbody = "Body of email";
$mailResult = @mail($to, $subject, $mailbody, $headers);

print $to;
print $subject;
print $mailbody;
print $headers;

?>

我大胆地猜测,这是因为您的to字段为空,尽管正在填充BCC标头。(希望如此——大概你已经用打印报表仔细检查过了?)电子邮件无法发送,因为它没有人发送to

例如,尝试为to字段no-reply@your-domain.com放入一个伪电子邮件,这可能会修复它。