//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();