Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

Email to SMS feature Contents | SearchBulk SMS Client

Home > Product Manual > Examples and Solutions > Reminder example

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Developers Guide
  Examples and Solutions
  Telephone networks
  SMS Pin game
  E-mail to SMS alert
  2 way SMS to Email gateway
  SMS Order System
  Least Cost Routing
  SMS Load Balancing
  Asterisk PBX SMS
  SQL SMS Gateway
  SMS Service Provider
  Service Provider
  SMS PIN code query
  SMS Counter game
  SMS newsgroup
  Distributed SMS
  SMS Menu
  Google maps
  Forwarding
  Birthday greeting - SQL Express
  Birthday greeting - MySQL
  Birthday greeting - Oracle
  Instant brochure - MMS autoreply
  Alphabet letter game
  SMS sport betting service
  E-mail about outgoing SMS messages
  SMS Information Menu
  Email to SMS feature
  Reminder example
  Bulk SMS Client
  Bulk SMS to a given phone number range
  Filtering phone numbers
  Ozeki Phone Sytem PBX SMS
  Autoreply voucher example
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
  Cookie policy
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

How to introduce SMS reminders in your website with Ozeki NG SMS Gateway

When you use Ozeki NG SMS Gateway software you can introduce various SMS services and solutions. One of these solutions is adding SMS reminder form to your website. This SMS reminder form enables your website visitors to subscribe to your various SMS reminders while browsing your website. Follow the configuration steps below to add the SMS reminder form to your website in minutes!

Download: ozeki_reminder_example.zip

With Ozeki NG SMS Gateway you can easily introduce an SMS reminder form in your website. By following just a few quick steps below you can make the SMS reminder form available for your website visitors.

Then people can subscribe to your SMS reminders while browsing your website. You can specify various events for which people can ask an SMS reminder. For example, they can ask a reminder via SMS before their payment is in due. This solution is convenient and discreet for both sides!

How it works?

For getting SMS reminders, website visitors only need to fill-in the form on your website. They only need to specify their phone number, the exact time and type of the SMS reminder. Finally, just click Create Reminder.

This SMS reminder then will be inserted in the ozekimessageout database table of Ozeki NG SMS Gateway. By default, Ozeki NG SMS Gateway checks ozekimessageout table in every 10 sec. for outgoing messages. When the given SMS reminder is polled, Ozeki NG SMS Gateway sends out the SMS reminder to the recipient. That's simple!

Getting started

For getting started first you need to configure Ozeki NG SMS Gateway for sending SMS messages (if you haven't done it): Follow the Quick Start Guide.

Then you need to configure a database user in Ozeki NG SMS Gateway. In this example, MySQL database is used. For configuration steps on how to create MySQL database user, check MySQL overview page.

When your SMS system is configured, download ozeki_reminder_example.zip and follow the configuration steps below.

Configuration steps

First download and extract ozeki_reminder_example.zip onto your PC (Figure 1).


Figure 1 - Download Ozeki SMS reminder

Open Ozeki Reminder Example file and copy the Ozeki folder in it (Figure 2).


Figure 2 - Copy Ozeki folder

Paste the Ozeki folder into the folder of your webserver (Figure 3).


Figure 3 - Paste Ozeki folder into the webserver folder

Open ozekiDB.class.php in Ozeki folder (Figure 4). Customize the following variables according to your database:

$dbHost
$dbName
$dbUserName
$dbPassword


Figure 4 - Customize database variables

Now a 'sendondate' database column needs to be added to ozekimessageout table. For this purpose execute the following statement (Figure 5):

ALTER TABLE `ozekimessageout` ADD `sendondate` VARCHAR( 20 ) NOT NULL ;


Figure 5 - Add sendondate column

Start Ozeki NG SMS Gateway and go to the configuration panel of the database user. Click on SQL for sending tab (Figure 6). In Polling tab insert the following SQL statement for polling messages:

SELECT `id`,`sender`,`receiver`,`msg`,`msgtype`,`operator` from `ozekimessageout` where ((EXTRACT(YEAR FROM (`sendondate`))) = YEAR( NOW( ))) AND ((EXTRACT(MONTH FROM (`sendondate`))) = MONTH( NOW( ))) AND ((EXTRACT(DAY FROM (`sendondate`))) = DAY( NOW( ))) AND ((EXTRACT(HOUR FROM (`sendondate`))) = HOUR( NOW( ))) AND ((EXTRACT(MINUTE FROM (`sendondate`))) = MINUTE( NOW( )))


Figure 6 - SQL statement for polling messages

After these configuration steps you can open your website to which you have added the SMS reminder form. For testing, fill-in the fields and click on Create Reminder (Figure 7).


Figure 7 - Test

Figure 8 demonstrates that Ozeki NG SMS Gateway have found 1 outgoing message and delivers it on the requested date and time.


Figure 8 - Outgoing message is found and delivered

On Figure 9 you can see the sent SMS reminder message in the Sent folder of Ozeki NG SMS Gateway.


Figure 9 - Sent message

For more information please contact us at info@ozekisms.com!



Next page: Bulk SMS Client
Copyright © 2000 - 2017 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com