- 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
- Asterisk PBX SMS
- SQL SMS Gateway
- 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
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki NG SMS Gateway
SMS content query with PIN code
This is a sample applications for SMS based content delivery with PIN code authentication. The application works the following way: The mobile users sends in an SMS message with a pin code. The software checks to see if the sender phone number and the pin code is in the database. If they are in the database the software returns the appropriate response message.
This solution can be created with the "SMS Autoreply from Database" solution presented at https://www.ozekisms.com/p_2392-ozeki-autoreply-sms-from-database.html
To get this solution working, you need to create this database table in your SQL server:
CREATE TABLE content ( id int IDENTITY (1,1), senderphone varchar(30), pincode varchar(16), responsemessage varchar(160), );
And you have to put the following line into your Autoreply database user script.
n.* SELECT '$sender',responsemessage from content where keyword='$keyword'
More information
- Examples and SMS solutions
- SMS Reminder example
- Autoreply voucher example
- How to connect SMS Gateway to the telephone network for voice calls
- Ozeki Phone Sytem PBX SMS
- Asterisk PBX SMS
- SMS Pin game
- SMS Counter game
- Appendix
- Feature list of the Ozeki NG SMS Gateway
- FAQ of the Ozeki NG SMS Gateway