<?php $gatewayURL = 'http://192.168.1.100:9333/ozeki?'; $request = 'login=sendmail'; $request .= '&password=mypassword'; $request .= '&action=sendMessage'; $request .= '&messageType=SMS:TEXT'; $request .= '&recepient='.urlencode('01711673093'); $request .= '&messageData='.urlencode("PHP Hello World"); $url = $gatewayURL . $request; //Open the URL to send the message file($url); ?>
Tag Archives: Ozeki
Ozeki NG MySQL Connectivity Parameters
Databse connection
===========================
Driver={mySQL ODBC 5.1 Driver};Server=192.168.0.100;Port=3306;Option=4;Database=mydb;Uid=userdb;Pwd=putmypwd;
Sending-Polling
============
SELECT id,sender,receiver,msg,msgtype,operator FROM ozekimessageout WHERE status=’send’
Sending-sending
=============
UPDATE ozekimessageout SET status=’sending’ WHERE id=’$id’
Sending-Sent
==============
UPDATE ozekimessageout SET status=’sent’, senttime=’$senttime’ WHERE id=’$id’
Sending-Not sent
===========
UPDATE ozekimessageout SET status=’notsent’ WHERE id=’$id’
SQL for receiving
==============
INSERT INTO ozekimessagein (sender, receiver, msg, senttime, receivedtime, msgtype, operator) VALUES (‘$originator’,’$recipient’,’$messagedata’,’$senttime’,’$receivedtime’,’$messagetype’,’$operatornames’)