Ozeki PHP Plugin

<?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);
?>
Share

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’)

Share