require_once '../class.phpmailer-lite.php';
$mail = new PHPMailerLite();
// defaults to using php "Sendmail" (or Qmail, depending on availability)
$body = file_get_contents('contents.html');
$body = eregi_replace("[\\]", '', $body);
$mail->SetFrom('*****@*****.**', 'List manager');
$mail->Subject = "PHPMailer Test Subject via Sendmail";
@MYSQL_CONNECT("localhost", "root", "password");
@mysql_select_db("my_company");
$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("@", "@", $row["email"]) . ') ' . $mail->ErrorInfo . '<br />';
} else {
echo "Message sent to :" . $row["full_name"] . ' (' . str_replace("@", "@", $row["email"]) . ')<br />';
}
// Clear all addresses and attachments for next loop
$mail->ClearAddresses();
$mail->ClearAttachments();
}
?>
</body>
</html>
