<?php
$yestoday = strtotime(date('Y-m-d'));
$nextday = strtotime(date('Y-m-d 23:59:59'));
$sql ="select * from emailsend_list where addtime>=$yestoday AND addtime<=$nextday and status=0 limit 1";
$results = fetch_arrays($sql);
$s ="select * from emailsend_list where addtime>=$yestoday AND addtime<=$nextday and status=0";
$c = fetch_arrays($s);
$count = count($c);
$i = $_GET['action'];
foreach($results as $key=> $value){
$i++;
$email = username($value['user_id']);
echo "共{$count}邮件..正在发送第{$i}份邮件....";
$sql = "update dw_emailsend_list set status=1 where id='{$value['id']}'";
$mysql->db_query($sql);
sends($value['title'],$value['content'],array($email));
redirect("?action=$i");
}
function username($user_id){
global $mysql;
$sql = "select * from user where user_id=$user_id";
$result = fetch_array($sql);
return $result['email'];
}
function sends($subject, $body, $to) {
$msgs = '';
$mail = new PHPMailer();
$body = eregi_replace("[\]",'',$body);
$mail->CharSet = 'gbk';
$mail->IsSMTP();
$mail->SMTPAuth = ture;
$mail->Host =
-->
转载请注明:谷谷点程序 » php邮件定时发送