PHP邮件（）BCC-仅在“收件人”标题中显示最终接收者的地址

Question

PHP邮件（）BCC-仅在“收件人”标题中显示最终接收者的地址

phpemailloopsheader

4

我正在尝试使用PHP邮件（）从数据库向订阅者列表发送BCC。一切正常，但我遇到了一个问题，让我整个早上都感到困扰。我能够发送带有BCC的列表，但无法将接收端电子邮件地址附加到标题“To：”中。

例如，我将列表发送给以下电子邮件地址(test1@example.com, test2@example.com和test3@example.com)。每个电子邮件地址都会收到一封电子邮件，并且由于BCC而隐藏其他电子邮件地址。

我的问题是，在所有接收列表的地方，“To:”标题都显示为空白。我理解并知道标题不会显示，因为我在传出消息中仅具有BCC头。我已经尝试使用for循环该过程，但我在一个循环中收到了所有的电子邮件，以及该地址的一个电子邮件。

这是我的工作代码：工作代码包括我尝试解决To：标题的循环。我能够发送电子邮件，但我收到了所有已发送的电子邮件。

<?php

/*
   Gathers the number of rows within the database. Used for the loop that displays the entire list in the BCC. 
*/

   session_start();
   include_once '../dbconnect.php';
   $result = mysql_query("SELECT * FROM news");
   $num_rows = mysql_num_rows($result);
   $rows = $num_rows;

/*
   Requests the list from the database, please the list in a loop, displays the list only once, and places list in an operator.
*/

   $result = mysql_query("SELECT * FROM `news`");
     while($row = mysql_fetch_array( $result )) {
       for ($x = 1; $x <= 1; $x++) {
         $contacts.= "".$row['email'].",";
       }
     }

/*
   ATTEMPT (It works... sort of): Sends mail to the list using BCC, displays the ONLY receivers email address in the To: header
*/

   $result = mysql_query("SELECT * FROM `news`");
     while($row = mysql_fetch_array( $result )) {
       for ($x = 1; $x <= 1; $x++) {
         $receiver= "".$row['email']."";

         $to = "$receiver";
         $subject = 'Test Email';
         $headers = "From: example@example.com\r\n";
         $headers .= "BCC: $contacts";

         $headers .= "MIME-Version: 1.0\r\n";
         $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
         $message = '<html><body>';
         $message .= '<h1 style="">Test Message</h1>';
         $message .= '</body></html>';
         mail($to,$subject, $message, $headers);
      }
    }
?>

我的一般想法是使用循环，但我找不到一个完全解决这个问题的解决方案，即将BBC添加到列表中，并仅在To:标题中显示接收端电子邮件地址。有什么想法或建议吗？ 使用SMTP服务器更新 我一直在尝试使用在此线程中找到的解决方案并将其应用于SMTP服务器。使用SendGrid发送消息是理想的选择。我想出了以下选项，但该脚本似乎只向数据库中的一个地址发送一条消息，而不是所有地址。

<?php
require_once "Mail.php";

$sub = $_POST['subject'];
$ttl = $_POST['title'];
$img = $_POST['image'];
$bdy = $_POST['body'];
$lk = $_POST['link'];

mysql_connect("", "", "") or die(mysql_error()) ; 
   mysql_select_db("") or die(mysql_error()) ; 

  $result = mysql_query("SELECT `email` FROM news");

  $num_rows = mysql_num_rows($result);

  $receivers = array();
  while ($row = mysql_fetch_array($result)) {
    $receivers[] = $row['email'];
  }

  foreach ($receivers as $receiver) { }

$from = "test@example.com";
$to = $receiver;
$subject = $sub;
$mime = "1.0";
$ctype = "text/html; charset=ISO-8859-1";
$body = '
<html><body>
<p>Test Message!</p>
</body></html>
';

$host = "";
$port = "";
$username = "";
$password = "";

$headers = array ('From' => $from,
  'To' => $to,
  'Subject' => $subject,
  'MIME-Version' => $mime ,
  'Content-Type:' => $ctype);

$smtp = Mail::factory('smtp',
  array ('host' => $host,
    'port' => $port,
    'auth' => true,
    'username' => $username,
    'password' => $password));

$mail = $smtp->send($to, $headers, $body);

if (PEAR::isError($mail)) {
  echo("<p>" . $mail->getMessage() . "</p>");
} else {
  echo("<p>Message successfully sent!</p>");
}
?>

- user5009455

只通过“收件人”发送邮件怎么样？为什么要费事地使用密送（BCC）呢？你的服务器发出的邮件数量有限吗？ - func0der

不，我没有限制。我隐藏了列表中的地址，因为这个脚本是用于客户邮件列表的。 - user5009455

是的，我知道，但让我用代码快速给出我实际想表达的答案。 ;) - func0der

啊，我明白了。谢谢！ - user5009455

2个回答

1

在HTML中添加\r\n：

$headers .= "BCC: $contacts\r\n";

每个标题必须单独成行。

- Thomas Orlita

谢谢！我现在正在尝试。如果它有效，我会告诉你的。 - user5009455

那似乎可以工作，但它只发送一封电子邮件。我认为循环只向操作员附加了一个地址。 - user5009455

如果您想向所有电子邮件地址发送电子邮件，请删除“for”循环。 - Thomas Orlita

它只发送了第一封电子邮件，就像你说的那样。 - Thomas Orlita

网页内容由stack overflow 提供, 点击上面的

可以查看英文原文，
原文链接

- func0der · Accepted Answer

代码包括对您的代码的一些通用改进。我已经添加了内联注释来解释我所做的事情。

<?php

  // General thing: If you do not need a session, do not start one ;)
  session_start();

  include_once '../dbconnect.php';

  // Select only what you really need from the table. This saves you memory
  // and it speeds up the query.
  $result = mysql_query("SELECT `email` FROM news");

  // You are not using these numbers in the script you showed us. I am just
  // leaving them in here to show you, how you can reuse the "$result"
  // variable without querying the database again.
  $num_rows = mysql_num_rows($result);

  // We are reusing the "$result" here without re-querying the database, which
  // speeds the whole process up and takes load away from the database. We are
  // storing all receivers in a dedicated variable, to reuse them later on.
  $receivers = array();
  while ($row = mysql_fetch_array($result)) {
    $receivers[] = $row['email'];
  }

  // Now, instead of querying the database again, we are using our stored mail
  // addresses in "$receivers" to send the emails one by one. We could have
  // done this part in the "while" loop before, but I wanted to stay close to
  // your code, so you would recognize it ;)
  foreach ($receivers as $receiver) {
    // I have removed the "for" loop here, because it runs only once. If a loop
    // only runs once and you control all its input, you really do not need a
    // loop at all (except some exceptions, just in case someone knows one^^).

    // You can actually just put the value of $receiver in $to. PHP is pretty
    // good at typecasting of scalar types (integers, strings etc.), so you do
    // not need to worry about that.
    $to = $receiver;

    $subject = 'Test Email';

    // I am putting the headers into an array and implode them later on. This
    // way we can make sure that we are not forgetting the new line characters
    // somewhere.
    $headers = array(
      "From: example@example.com",
      "MIME-Version: 1.0",
      "Content-Type: text/html; charset=ISO-8859-1",
      // I have removed the "BCC" header here, because this loops send out an
      // email to each user seperately. It is basically me sending an email to
      // you. Afterwards I copy&paste all the content to another new mail and
      // send it to another fella. You would never know that you both got the
      // same mail ;)
    );

    $message = '<html><body>';
    $message .= '<h1 style="">Test Message</h1>';
    $message .= '</body></html>';

    // Imploding the headers.
    $imploded_headers = implode("\r\n", $headers);

    mail($to, $subject, $message, $imploded_headers);
  }

这段代码基本上一次只发送一封电子邮件。接收此类电子邮件的人不知道电子邮件发送到了哪些电子邮件地址。

正如代码中所提到的，此片段可以进一步优化。由于电子邮件发送本身就是一个非常困难的领域，我建议您找到一些PHP库来捆绑整个过程并与之一起工作。在整个电子邮件发送过程中，您可能会犯很多错误，如果您不想很快被标记为垃圾邮件，则不要在生产中运行此类脚本。