[Solved] Send SMS to mysql contact using php pdo [closed]

Question

As several mentioned in comments above, you need do do this with PHP, as you tagged in your question already.

For some projects, I use Plivo which has API documentation for PHP here. I have no connection to this company other than being a (small) client and there are certainly others that might be better.

But ultimately, if you have selected the group ‘Youth’ and have a message ‘There will be youth service tonight’, you could (after subscribing to and configuring the API) query the database for the SMS numbers that are have Fellowship = 'Youth' like:

SELECT
    `Phone`
FROM
    Table
WHERE
    `Fellowship` = 'Youth';

Then create a delimited string of phone numbers and send it to the API. The details of your form, database and API connection would need to be considered when building your final solution.

The other option would be to send them via email, and use the SMS gateways, though this doesn’t tend to have the ‘true SMS’ feel given that they come from email addresses. CodeTuts has a tutorial here.

This should get you started, but ultimately, you will need PHP (or other server-side language of your choice) to handle this.

Accepted Answer