TurnKey Linux Virtual Appliance Library

Autoreply SMS from database

 

I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers (based on keywords) from a database and send it back in SMS to the customer’s mobile phone. For example I will use Microsoft SQL Express as the database server. I found a software, OzekiSMS Gateway that can handle SMS receiving and sending. The database connection is the question. How should I organize the data in the database? Is this the best way as they recommend? (http://www.ozekisms.com/index.php?owpn=392&info=users-and-applications/autoreplydatabase-user)

 

For example:

> select * from autoreplymessage;

id          keyword                        msg

----------  ------------------------------ -------------------------------------

 1          default                        There is no data for this keyword.

 2          red                            Red is a good color.

 3          blue                           Blue is not the best option.

 

Please share with me your suggestions.

Bye,

 

Leslie

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)