<?php
exec("E:\wamp\bin\php\php5.5.12\php.exe cli_test.php");
?>
<?php
$rootPath=dirname(__FILE__);
require $rootPath.'/PHPMailer/PHPMailerAutoload.php';
function sendMail($host,$fromEmail,$fromPwd,$fromName,$toEmail, $toName,$subject,$content){
$mail = new PHPMailer;
$mail->isSMTP();
$mail->Host = $host;
$mail->SMTPAuth = true;
$mail->Username = $fromEmail;
$mail->CharSet="UTF-8";
$mail->Password = $fromPwd;
$mail->From = $fromEmail;
$mail->FromName = $fromName;
$mail->addAddress($toEmail, $toName);
$mail->Subject = $subject;
$mail->Body = $content;
return $mail->send();
}
$link = mysqli_connect("localhost","root","","test");
mysqli_query($link,"set names utf8");
while(true){
$sql="SELECT *FROM task_list WHERE status = 0 ORDER BY task_id ASC LIMIT 5 ";
$res = mysqli_query($link,$sql);
$mailList=array();
while($row = mysqli_fetch_assoc($res)){
$mailList[]=$row;
}
if(empty($mailList)){
break;
}else{
foreach($mailList as $k=>$v){ if(sendMail("smtp.aliyun.com","shangjiahe@aliyun.com","Shang1994","aliyun",$v['user_email'],'sina',"woaixuexi","xixixixi")) {
mysqli_query($link,"UPDATE task_list SET status = 1 WHERE task_id=".$v['task_id']);
}
sleep(3);
}
}
}
echo "done";