Simple MySQL site using SMS

Simple MySQL site using SMS SearchSearch
Author Message
Oliver Hammond
Unregistered guest
Posted on Thursday, July 22, 2004 - 03:45 pm:   

Would NowSMS be of benefit to a MySQL database driven website requiring the sending of time-sensitive SMS messages? Basically, the site features an appointments system and SMS will be used to send confirmations and reminders of appointments to users' mobile phones. I understand that NowSMS is a software product but ideally we want to integrate an SMS system that doesn't involve the installing of software on any particular PC or network of PCs. The sending of images will not be required so I assume this will negate the need for MMS, so SMS will suffice?

If anyone can give some advice on what setup is required to integrate Push and Pull SMS messages with a MySQL database that would be very helpful, as would info on UK SMSCs that we can look at.

Many thanks in advance,

Oliver
oliver.hammond@orchestrand.com
http://www.orchestrand.com
Saeed Paksima
New member
Username: Paksima

Post Number: 3
Registered: 07-2004
Posted on Saturday, July 24, 2004 - 04:49 am:   

I have a smiliar application under developement which uses NowSMS gateway interoperated with a backend RDBMS processing engine. I don't have a clear picture of your case but definitely it IS feasible & you do not have to install NowSMS on very PC. If you could send me some more details on your intended project I may be able to help more.

HTH

Saeed Paksima
Oliver Hammond
Unregistered guest
Posted on Saturday, July 24, 2004 - 02:28 pm:   

Thanks for your reply, Saeed. Basically, we are developing an appointments system for an opticians surgery. Patients can make an appointment online, the appointment is then recorded in the MySQL database and we then want the patient to receive a confirmation of the appointment to their cell phone via SMS. No record of the SMS having been sent needs to be made in the database. The other thing we want is for appointment reminders to be sent by SMS, 2 days before the day of their appointment. I assume what we are aiming to achieve is simple but we haven't worked with SMS before. In general terms, what do we need to get this kind of system working? Database, SMS gateway and...?

Thanks again,

Oliver
Saeed Paksima
New member
Username: Paksima

Post Number: 4
Registered: 07-2004
Posted on Sunday, July 25, 2004 - 04:28 am:   

For such a small scale application you would certainly be looking for the most economical SMS solution. So the ingredients apart from you current DBMS are : NowSMS Gateway + a GSM Modem.
As for the coding, you need to add a component in your current application to simply send an HTTP Request with a certian synatx to the gateway. But you can be MUCH more creative with NowSMS gateway !
Let me know if I can be of any help.

Regards,

Saeed
saeed@kishwood.com
Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 3145
Registered: 10-2002
Posted on Wednesday, July 28, 2004 - 08:46 pm:   

Hi Oliver,

Basically when you want to send an SMS, you generate an HTTP request to NowSMS. The HTTP request format for a plain text SMS is pretty simple:

http://www.nowsms.com/documentation/ProductDocumentation/sending_messages/sendin g_text_messages.htm

http://www.nowsms.com/documentation/ProductDocumentation/sending_messages/url_pa rameters_for_sending_messages.htm

Dandjinou
New member
Username: Dbrice

Post Number: 11
Registered: 06-2004
Posted on Monday, September 27, 2004 - 03:18 pm:   

Hi,
I want to know if it'll possible to give me an example for sending binary message (operator logo, ringtone) with HTTP request format ?
Tx in advance
best regards
Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 3516
Registered: 10-2002
Posted on Thursday, September 30, 2004 - 06:57 pm:   

http://support.nowsms.com/discus/messages/1/6583.html