$result = mysql_query("set names 'utf8'");
$totalNumRes = mysql_query("select count(*) as num from `test`");
while ($row = mysql_fetch_assoc($totalNumRes)) {
$totalNum = $row['num'];
}
$page = intval($_POST['page']) ? intval($_POST['page']) : 0;
//这就是最后一封了
if (intval($totalNum) - intval($page) < 2) {
$data['flag'] = 1;
}
$num = 1;
$start = 0 + $num * $page;
$sql = "select `id`,`email`,`name` from `contact` order by id asc limit {$start} , {$num}";
$result = mysql_query($sql);
//导入配置
$configArr = (include dirname(__FILE__) . '/config.php');
$mailmodel = new MailModel($configArr['email'], $configArr['password'], $configArr['name']);
while ($row = mysql_fetch_assoc($result)) {
$email = trim($row['email']);
$data['info'] = '<div> ' . $row['name'] . ' : ' . $email . ' </div>';
if ($configArr['attachment']) {
$mailmodel->send($email, $row['name'], $configArr['title'], $configArr['body'], $configArr['attachment']);
} else {
$mailmodel->send($email, $row['name'], $configArr['title'], $configArr['body']);
}
echo json_encode($data);
//数据库里做标记
//$sql = "INSERT INTO `mark` (`uid`) VALUES (".$row['id'].")";
//mysql_query($sql);
}
mysql_close($con);
