01.
$sql
=
"SELECT member_id "
02.
.
"FROM member "
03.
.
"WHERE email !='' "
04.
.
"AND $to "
05.
.
""
;
06.
$result
= mysql_query(
$sql
);
07.
08.
09.
$totalpage
=
ceil
(
$totalrecords
/
$pagelen
);
10.
$goto
= (
$page
- 1) *
$pagelen
;
11.
12.
$mail
=
new
PHPMailer;
13.
$mail
->isSMTP();
14.
$mail
->CharSet =
'UTF-8'
;
15.
$mail
->Host =
'smtp.gmail.com'
;
16.
$mail
->SMTPAuth = true;
17.
$mail
->Username = trim(
$_SESSION
[
'usernameSendTo'
]);
18.
$mail
->Password = trim(
$_SESSION
[
'passwdSendTo'
]);
19.
$mail
->SMTPSecure =
'tls'
;
20.
$mail
->Port = 587;
21.
22.
$mail
->From = trim(
$_SESSION
[
'from_email'
]);
23.
$mail
->FromName = trim(
$_SESSION
[
'emailing'
]);
24.
25.
$mail
->isHTML(true);
26.
$mail
->Subject = trim(
$_SESSION
[
'headline'
]);
27.
$mail
->Body = trim(
$mail_html
);
28.
29.
$sql2
=
"SELECT email,name_th,lastname_th,student_id,alumni_year "
30.
.
"FROM member WHERE email !='' "
31.
.
"AND $to "
32.
.
"LIMIT $goto,$pagelen "
33.
.
""
;
34.
$rs_mail
= mysql_query(
$sql2
)
or
die
(mysql_error());
35.
$row_rs_mail
= mysql_fetch_assoc(
$rs_mail
);
36.
$totalRows_rs_mail
= mysql_num_rows(
$rs_mail
) .
'<br/>'
;
37.
38.
$result2
= mysql_query(
$sql2
);
39.
40.
41.
42.
43.
44.
for
(
$i
= 1;
$i
<=
$totalRows_rs_mail
;
$i
++) {
45.
$row
= mysql_fetch_array(
$result2
);
46.
$emailSendMail
=
$row
[
'email'
];
47.
$FirstNameSendMail
=
$row
[
'name_th'
];
48.
$LastNameSendMail
=
$row
[
'lastname_th'
];
49.
$fullnameall
=
$FirstNameSendMail
.
" "
.
$LastNameSendMail
;
50.
$new_data
= split(
","
,
$emailSendMail
);
51.
foreach
(
$new_data
as
$id
=>
$value
) {
52.
$mail
->addAddress(
$value
,
$fullnameall
);
53.
54.
}
55.
}
56.
$page
+=1;
57.
58.
if
(!
$mail
->send()) {
59.
echo
"<center><h2>. . . ส่งเมล์ไม่สำเร็จ แจ้งผู้ดูแลระบบ. . .</h2></center>"
;
60.
echo
"<center><p>Mailer Error: ' . $mail->ErrorInfo . '</p></center>"
;
61.
echo
"</TD></TR></TABLE>"
;
62.
exit
();
63.
64.
}
else
{
65.
if
(
$page
<
$totalpage
) {
66.
echo
"<center>รอสักครู่ กำลังส่งเมล์.............</center>"
;
67.
}
68.
}
69.
70.
if
(
$page
>
$totalpage
) {
71.
echo
'<center><h2>การส่งจดเสร็จสิ้น.....รอสักครู่ กำลังเปลี่ยนหน้า</h2></center>'
;
72.
print
"<meta http-equiv='refresh' content='4; url=mail_form.php?id=$id'>"
;
73.
echo
"</TD></TR></TABLE>"
;
74.
exit
();
75.
}