send sms to registered reciever

<?php
/*********************************
// catatan: table-table yg digunakan hanya memuat field2 yg dipakai saja
            (lebih sedikit daripada bawaan Gammu)
//**********************************
USE test; //memakai database 'test'
DROP TABLE IF EXISTS `inbox`;
CREATE TABLE IF NOT EXISTS `inbox` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `TextDecoded` varchar(160) NOT NULL,
  `SenderNumber` varchar(12) NOT NULL,
  `Processed` enum('false','true') DEFAULT 'false',
  PRIMARY KEY(`ID`)
) ENGINE=MyISAM;

INSERT INTO `inbox`(  `ID`,`TextDecoded`,`SenderNumber`,`Processed`) VALUES
(NULL,'test1','628765432106','false'),
(NULL,'test2','628765432100','false'),
(NULL,'test3','628765432108','false');

DROP TABLE IF EXISTS `outbox`;
CREATE TABLE IF NOT EXISTS `outbox` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `TextDecoded` varchar(160) NOT NULL,
  `DestinationNumber` varchar(12) NOT NULL,
  `CreatorID` varchar(30) NOT NULL,
  `Class` tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY(`ID`)
) ENGINE=MyISAM;


DROP TABLE IF EXISTS `tbl_pengirim`;
CREATE TABLE IF NOT EXISTS `tbl_pengirim` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hp` varchar(12) NOT NULL,
  PRIMARY KEY(`ID`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `tbl_penerima`;
CREATE TABLE IF NOT EXISTS `tbl_penerima` (
  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hp` varchar(12) NOT NULL,
  PRIMARY KEY(`ID`)
) ENGINE=MyISAM;

INSERT INTO `tbl_pengirim`(ID,hp) VALUES
(NULL,'628765432106'),
(NULL,'628765432107'),
(NULL,'628765432108'),
(NULL,'628765432109');

INSERT INTO `tbl_penerima`(ID,hp) VALUES
(NULL,'628765432105'),
(NULL,'628765432104'),
(NULL,'628765432103'),
(NULL,'628765432102');
*************************************/
$dbhost="localhost";
$dbuser="root";
$dbpass="";
$dbname="test";
$db=new mysqli($dbhost,$dbuser,$dbpass,$dbname);
$sql = "SELECT a.ID,a.TextDecoded "
      ."FROM inbox a INNER JOIN tbl_pengirim b ON a.SenderNumber=b.hp "
      ."WHERE a.Processed='false'";
$result = $db->query($sql);
while($record=$result->fetch_object()){
  $sql_penerima = "SELECT hp FROM tbl_penerima";
  $penerima=$db->query($sql_penerima);
  while($data_penerima=$penerima->fetch_object()){
    $sql_send = "INSERT INTO outbox(DestinationNumber, TextDecoded, CreatorID, Class) "
               ."VALUES ('".$data_penerima->hp."', '".$record->TextDecoded."', 'Gammu', '0')";
    $send=$db->query($sql_send);
  }
  $penerima->close();
  $sql_update = "UPDATE inbox SET Processed = 'true' WHERE ID = '".$record->ID."' ";
  $update=$db->query($sql_update);
}
$result->close();
$db->close();
?>