Postingan lainnya
Gagal mengambil data berulang dengan while
Saya lagi buat program untuk mengirim email ke beberapa alamat email subscriber dengan beberapa syarat. Pada saat mengambil beberapa alamat emailnya dari database sdh berhasil, tapi pada saat mengambil konten yg akan dikirim hanya mengambil 1 (satu) data. Padahal terdapat beberapa record yg mengandung teks like '%lpdp%'. Mohon bantuannya teman-teman.
Ini potongan scriptnya:
//data untuk
$select1 = mysql_query("SELECT * FROM links where title like '%lpdp%' ");
while ($r1 = mysql_fetch_array($select1)) {
//awal ambil alamat email
$select = mysql_query('SELECT * FROM tb_subs ');
while ($r = mysql_fetch_array($select)) {
$mail->addAddress($r['email'], $r['nama']);
//body ambil alamat email
//query update untuk status
//mysql_query("UPDATE links set status='1' where link_id='5'");
//Set the subject line
$mail->Subject ="SI Beasiswa | " .$r1['title'] ;
//deklarasi body email
$body = "<html><body>";
$body .= $r1['title']."<br>";
$body .= $r1['url']."<br><br>";
//$body .= $r1['fulltxt']."<br>";
$body .= "</body></html>";
}//akhir ambil alamat email
} //akhir ambil konten
//Replace the plain text body with one created manually
$mail->Body = $body;
$mail->AltBody = strip_tags($body);
0
3 Jawaban:
//data untuk
$select1 = mysql_query("SELECT * FROM links where title like '%lpdp%' ");
$body = "<html><body>";
while ($r1 = mysql_fetch_array($select1)) {
//awal ambil alamat email
$select = mysql_query('SELECT * FROM tb_subs ');
while ($r = mysql_fetch_array($select)) {
$mail->addAddress($r['email'], $r['nama']);
//body ambil alamat email
//query update untuk status
//mysql_query("UPDATE links set status='1' where link_id='5'");
//Set the subject line
$mail->Subject ="SI Beasiswa | " .$r1['title'] ;
//deklarasi body email
$body .= $r1['title']."<br>";
$body .= $r1['url']."<br><br>";
//$body .= $r1['fulltxt']."<br>";
}//akhir ambil alamat email
} //akhir ambil konten
$body .= "</body></html>";
//Replace the plain text body with one created manually
$mail->Body = $body;
$mail->AltBody = strip_tags($body);
2
makasih responnya bang @QaiserLab. sarannya sdh saya coba, tapi hasilnya tetap sama bang.
0
pindah ke metode MYSQLI proce/oop gan, yg MYSQL udah deprecated. bisa belajar disini : https://www.sekolahkoding.com/kelas/database-php-dan-mysqli-procedural
0