I have a MySQL database of subscribers for my business. Currently, I am able to filter the database in anyway that I want. For example, I can filter to see only male, or only female, or only "Male above 50".
After filtering the database, I use PHP to print the results on a webpage.
Here is the problem:
I blast SMS to the people in the filtered results. I type the message on my phone manually, and then I type their phone numbers into my phone default SMS app one by one. For each SMS, I send to about 100 people. Every month, I send about 50k SMS.
Constraints:
- My subscribers will be replying to the SMS directly. From there, regular SMS continues.
- I have a SIM Card now that lets me send UNLIMITED SMS for free. It will be good if your solution can let me continue to use this SIM Card so I don't have to worry about the cost per SMS.
Solution Required:
Ideally, I will like to be able to make the process faster. In the best scenario, after I filter the database (either on the phone or browser), I hit 'Send' and it blasts the SMS from my phone to the recipients.
After filtering the database, I use PHP to print the results on a webpage.
Here is the problem:
I blast SMS to the people in the filtered results. I type the message on my phone manually, and then I type their phone numbers into my phone default SMS app one by one. For each SMS, I send to about 100 people. Every month, I send about 50k SMS.
Constraints:
- My subscribers will be replying to the SMS directly. From there, regular SMS continues.
- I have a SIM Card now that lets me send UNLIMITED SMS for free. It will be good if your solution can let me continue to use this SIM Card so I don't have to worry about the cost per SMS.
Solution Required:
Ideally, I will like to be able to make the process faster. In the best scenario, after I filter the database (either on the phone or browser), I hit 'Send' and it blasts the SMS from my phone to the recipients.
