agan mastah,, ane punya problem PHP... ane bermaksu mengirim email otomatis menggunakn bantuan cron job. skrip ane seperti ini.
Spoiler for my skrip:
<?php
include "../connect/connect.php";
include "../phpmailer/class.phpmailer.php";
$jam=date("h:i");
$a=mysql_query("select * from tbl_remainder where tgl=date(now()) and jam='".$jam."' and pesan='0'");
while($h=mysql_fetch_array($a)){
$b=mysql_query("select * from tbl_email where id_remainder='".$h['id']."'");
$p=mysql_fetch_array(mysql_query("select * from tbl_pesan where id_remainder='".$h['id']."'"));
while($hh=mysql_fetch_array($b)){
$penerima=$hh['alamat_email'];
$nama_pengirim="Endhar Mahaputra";
$letak_file="../file/";
$nama_file=$p['file'];
$mail = new PHPmailer();
$mail->ClearAddresses();
$mail->AddAddress($penerima, $penerima);
$mail->FromName=$nama_pengirim;
$mail->Subject=$h['perihal'];
$mail->Body=$p['pesan'];
$mail->IsHTML(true);
$mail->AddAttachment($letak_file, $nama_file);
if($mail->Send()){
echo "sukses";
mysql_query("update tbl_remainder set pesan='1' where id='".$h['id']."'");
}
else{
echo $mail->ErrorInfo;
}
}
}
?>
skrip ini waktu ane jalanin manual tanpa cron job gak eror gan, dan emailnya bisa terkirim, tapi waktu ane jalanin pake cron job gak jalan gan.. ane buka cron outputnya ada eror. gini katanya
Spoiler for eror:
Warning: include(../connect/connect.php): failed to open stream: No such file or directory in /home/u434153969/public_html/admin/cek_kirim.php on line 2
Warning: include(../connect/connect.php): failed to open stream: No such file or directory in /home/u434153969/public_html/admin/cek_kirim.php on line 2
Warning: include(): Failed opening '../connect/connect.php' for inclusion (include_path='.:/usr/lib/php') in /home/u434153969/public_html/admin/cek_kirim.php on line 2
Warning: include(../phpmailer/class.phpmailer.php): failed to open stream: No such file or directory in /home/u434153969/public_html/admin/cek_kirim.php on line 3
Warning: include(../phpmailer/class.phpmailer.php): failed to open stream: No such file or directory in /home/u434153969/public_html/admin/cek_kirim.php on line 3
Warning: include(): Failed opening '../phpmailer/class.phpmailer.php' for inclusion (include_path='.:/usr/lib/php') in /home/u434153969/public_html/admin/cek_kirim.php on line 3
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/u434153969/public_html/admin/cek_kirim.php on line 7
kira2 itu kenapan agan2 mastah?? cara mengatasinya gimana?? mohon bantuannya...
