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