require ("class.phpmailer.php");
// 下载的文件必须放在该文件所在目录
$mail = new PHPMailer(); //建立邮件发送类
$link = mysql_connect("192.168.0.00", "root", "pass") or die('Could not connect: ' . mysql_error());
// echo 'Connected successfully';
mysql_query("set names 'gb2312'");
mysql_select_db("oaerp") or die('Could not select database');
mysql_query("set character set 'utf8'"); //读库
$sql1 = "select * from sml"; //获取信息列表
echo $sql1;
$result = mysql_query($sql1);
//
while ($row = mysql_fetch_array($result))
{
$mail->ClearAddresses();
$n = $row["Name"];
$mail->CharSet = "UTF-8";
$address = $row["email"];
$mail->IsSMTP(); // 使用SMTP方式发送
$mail->Host = "smtp.mail.com"; // 您的企业邮局域名
$mail->SMTPAuth = true; // 启用SMTP验证功能
$mail->Username = "test@test.com"; // 邮局用户名(请填写完整的email地址)
$mail->Password = "*****"; // 邮局密码
$mail->Port = 25;
$mail->From = "rec@test.com"; //邮件发送者email地址
$mail->FromName = "system"; //发件人名称
$mail->AddAddress("$address", "$n"); //收件人地址,可以替换成任何想要接收邮件的email信箱,格式是AddAddress("收件人email","收件人姓名")
// $mail->AddReplyTo("", "");
// echo $mail;
// $mail->AddReplyTo("", "");
// $mail->AddAttachment("/var/tmp/file.tar.gz"); // 添加附件
// $mail->IsHTML(true); // set email format to HTML //是否使用HTML格式
$mail->Subject = "测试邮件"; //邮件标题
$Body = "$n,你好,这是测试邮件";
$mail->Body = $Body; //邮件内容
$mail->AltBody = "This is the body in plain text for non-HTML mail clients"; //附加信息,可以省略
echo $address;
if (!$mail->Send())
{
echo "邮件发送失败. ";
echo "错误原因.: " . $mail->ErrorInfo;
exit;
}
echo "邮件发送成功
";
}
// 释放结果集
$rc = mysql_affected_rows();
echo "发送条数: " . $rc;
mysql_free_result($result);
// 关闭连接
mysql_close($link);
?>