code for grab text inbox nowsms

 get text from nowsms file and store to mysql inbox data

by aswandi




include "config.inc.php";

$data = file_get_contents("sampah-nixsms/sample_nowsms.txt"); //read the file
$b = explode("\n", $data); //create array separate by new line

for ($i=0;$i{
 // echo "$b[$i]
";
 $baris = $b[$i];
 $abaris = explode(",",$baris);


/*
 if($abaris[3]==""){}
 
 */
 $ReceivingDateTime = $abaris[0];
 $SenderNumber = $abaris[1];
 $TextDecoded = $abaris[3];
 //echo substr('abcdef', 0, 4);  // abcd
  $aTextDecoded = substr($TextDecoded, 0, 3);
 if($aTextDecoded=="id:"){
continue;
 }
 //   print_r($abaris);
 in2inbox($id_fb,$ReceivingDateTime,$Text,$SenderNumber,$Coding,$UDH,$SMSCNumber,$Class,$TextDecoded,$ID,$RecipientID,$Processed);
 echo "in2inbox($id_fb,$ReceivingDateTime,$Text,$SenderNumber,$Coding,$UDH,$SMSCNumber,$Class,$TextDecoded,$ID,$RecipientID,$Processed);
";


}

function in2inbox($id_fb,$ReceivingDateTime,$Text,$SenderNumber,$Coding,$UDH,$SMSCNumber,$Class,$TextDecoded,$ID,$RecipientID,$Processed){

    $sql="insert into inbox

        ( id_fb,ReceivingDateTime,Text,SenderNumber,Coding,UDH,SMSCNumber,Class,TextDecoded,ID,RecipientID,Processed )
        Values
        ( '$id_fb','$ReceivingDateTime','$Text','$SenderNumber','$Coding','$UDH','$SMSCNumber','$Class','$TextDecoded','$ID','$RecipientID','$Processed' )";

    mysql_query($sql);
    $UpdatedInDB=mysql_insert_id();
    return $UpdatedInDB;

}
 
?>