Would this idea work, how easy/hard would it be? (form entry to sms alert)

[DJMK4]

I was thinking of idea's to put on my website that I am planning as mentioned in my other thread, and one feature I would like to look into would be the ability to create some sort of form (like a PHP form) which would then attach to an SQL database table.

The use of the form would be to input reminders or appointments, this would then be stored in an the SQL database, I would then like a reminder sent to either an e-mail address or if is possible (without too much hassle) to my phone in the form of a text message when the date approaches (I got a feeling it could be quite abit of hassle, and probably something that will cost from a provider as im assuming you would need an SMS gateway).

Could anybody shine some light on this?

 

[malef!c]

The form to database is easy enough and PHP.net will give you the SQL queries you need to run to get stuff into the database (don't forget to sanatise the entries so no SQL injections will reveal all your appointments online!!).

Then, at a guess, run a cron every 5 minutes that checks for appointments in the next 5 minutes and then start to email (PHP mail command is easy enough) or send via SMS gateway (I use Clickatell which means you go a HTTPS request to send the SMS).

Thats the very basics - not sure if you just wanted ideas or the actual code