Readers like you help support MUO. When you make a purchase using links on our site, we may earn an affiliate commission. Read More.
I'd like to send different kind of SMS messages to my customers. I need a fully automated system.
For example (birthday greetings): I store dates of my customers' births in MYSQL database. I need a system that sends the: 'We wish you a happy birthday! Have a nice day!' greeting SMS automatically to each customer on his/her birthday. That's just an example. I'd like to send prewritten SMSs at a predefined data and time.
Does anybody have a solution for this purpose?
2014-02-12 14:14:03
Hello,First, you need an SMS gateway. Do you have any? If so, make sure your gateway allows you to send SMSs through a database. I use Ozeki ng SMS gateway, it enables SMS messaging through different kind of databases (including MYSQL as well). It an be used to send automated SMSs.For sending SMS messages by using a MySQL database server, you need to install the MyODBC v5.1 driver to your computer (it can be downloaded from the MySQL website). For configuration details (database connection string, database connection type, database table layout): http://ozekisms.com/index.php?owpn=168&info=database-user/mysqlI hope it was useful
2014-02-13 07:23:40
Simon, it's me again. I don't believe it! I found a video guide about sending greeting SMS messages by using MySQL: http://ozekisms.com/index.php?owpn=576&info=examples-and-solutions/birthday-greeting---mysql Thanks your tip again!