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://ozekisms.com/p_2392-sms-autoreply-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