Sending an SMS to a mySQL database

Sending an SMS to a mySQL database SearchSearch
Author Message
tom barnes
New member
Username: Tombarnes

Post Number: 1
Registered: 06-2006
Posted on Thursday, June 01, 2006 - 10:56 pm:   

We have a black box of electronic tricks (a GSM modem) that sends an SMS text, we want to INSERT this SMS into mySQL database. From there we can interogate the data.

We though of a sms to email gateway to get it into an email, wots the best way?? anyone??
Camille
New member
Username: Chashem

Post Number: 1
Registered: 06-2006
Posted on Tuesday, June 06, 2006 - 03:21 pm:   

I have used php to do just what you are asking. The sms triggers a php script, the script inserts the sms message into the database.
Kingsley Duru
New member
Username: Igwe4life

Post Number: 1
Registered: 06-2006
Posted on Friday, June 16, 2006 - 12:49 pm:   

hi @Camille,

Pls post the php script you used to acchieve this feat.
Bryce Norwood - NowSMS Support
Board Administrator
Username: Bryce

Post Number: 6046
Registered: 10-2002
Posted on Friday, June 16, 2006 - 07:55 pm:   

In NowSMS, we refer to this type of application as a "2-way SMS" application.

Basically, you can configure NowSMS so that when it receives an SMS message, it calls a script running on a web server ... passing details about the received message to the script. The script can then take whatever action it wants to take on the message ... sending a reply ... adding the message to or updating a database ... triggering some other type of activity ... etc.

For more details on configuring 2-way SMS, see:

http://www.nowsms.com/documentation/ProductDocumentation/2_way_sms_support.htm

The following thread also has more information and links to some simple 2-way SMS examples:

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

-bn