Q1:中文乱码问题
A1:$mail->CharSet = "UTF-8";
Q2:从数据库中取值然后多发问题
A2:增加一行:$mail->ClearAddresses();
http://phpbeautifier.com/
<?php 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 "邮件发送失败. <p>"; echo "错误原因.: <p> " . $mail->ErrorInfo; exit; } echo "邮件发送成功<p>"; } // 释放结果集 $rc = mysql_affected_rows(); echo "发送条数: " . $rc; mysql_free_result($result); // 关闭连接 mysql_close($link); ?>