//get data sms
$sql = "SELECT sms.notifikasi,sms.id ,ap.hp,ap.password,u.username,u.id as iduser\n\t\t\t\t\t\tFROM ak_notifikasi_sms sms\n\t\t\t\t\t\tJOIN ak_pegawai ap \n\t\t\t\t\t\tJOIN users u\n\t\t\t\t\t\tON ap.id_siswa = sms.id_siswa\n\t\t\t\t\t\tAND u.id_pengguna=ap.id\n\t\t\t\t\t\tWHERE date(waktu)='" . date('Y-m-d') . "'";
$q = mysql_query($sql);
echo $sql;
$apikey = '81f6cf2706d2302a33782a6126b16469';
//$nohp = '+6283867139945';
//$pesan = 'cek api';
$this->sms->key = '81f6cf2706d2302a33782a6126b16469';
$this->sms->phone = '2rajasms';
while ($hsl = mysql_fetch_assoc($q)) {
if (strlen($hsl['hp']) > 8 && strlen($hsl['hp']) < 15 && $hsl['notifikasi'] != '') {
//$encode=$hsl['notifikasi'].'. Pantau akademik putra/putri anda di https://studentbook.co/u/'.base64_encode($hsl['iduser']);
$encode = $hsl['notifikasi'];
echo '<pre>';
print_r($hsl['hp']);
echo '</pre>';
echo '<pre>';
print_r($encode);
echo '</pre>';
$this->sms->setTo($hsl['hp']);
$this->sms->setText($encode);
$sts = $this->sms->send();
mysql_query("DELETE FROM `ak_notifikasi_sms` WHERE id=" . $hsl['id'] . "");
//die();
}
}
}
}
$dom = new sms();
$dom->execute_sms();
