php - 使用数据库连接通过 phpmailer 发送邮件()的正确方法

Question

我正在尝试修改 phpmailer db 邮件程序以使用 sendmail，下面的代码是否正确？我正在尝试将其实现到一个网站中，向大约 2-300 名联系人的客户群发送电子邮件。谢谢:-)

<?php
require_once('./send/class.phpmailer.php');
//include("class.smtp.php"); // optional, gets called from within class.phpmailer.php     if not already loaded

$mail = new PHPMailer(true); //defaults to using php "mail()"; the true param means it     will throw exceptions on errors, which we need to catch

 $body                = file_get_contents('contents.html');
 $body                = eregi_replace("[\]",'',$body);


$mail->SetFrom('list@mydomain.com', 'List manager');
$mail->AddReplyTo('list@mydomain.com', 'List manager');

$mail->Subject       = "PHPMailer Test Subject via smtp, basic with authentication";

 $query  = "SELECT full_name, email, photo FROM employee WHERE id=$id";
$result = @MYSQL_QUERY($query);

while ($row = mysql_fetch_array ($result)) {
  $mail->AltBody    = "To view the message, please use an HTML compatible email viewer!";     // optional, comment out and test
  $mail->MsgHTML($body);
  $mail->AddAddress($row["email"], $row["full_name"]);
  $mail->AddStringAttachment($row["photo"], "YourPhoto.jpg");

  if(!$mail->Send()) {
    echo "Mailer Error (" . str_replace("@", "&#64;", $row["email"]) . ') ' .         $mail->ErrorInfo . '<br>';
  } else {
    echo "Message sent to :" . $row["full_name"] . ' (' . str_replace("@", "&#64;",     $row["email"]) . ')<br>';
}
// Clear all addresses and attachments for next loop
$mail->ClearAddresses();
$mail->ClearAttachments();
}
?>    

Answer 1

这应该可行，但请确保托管公司支持此功能。