Insert SMS message into database

Posted on 2011-10-23
Medium Priority
Last Modified: 2012-08-14
I am looking for a tutorial, or find out more on what's needed to have users send information via text message to my server and I take that data and insert it into my database.  I have never done this before and not sure what is needed to do this.  I am using CF9, mysql 5, not sure if that makes a difference or not.
Question by:theideabulb
  • 2
LVL 16

Expert Comment

by:Gurpreet Singh Randhawa
ID: 37014991
well i did not understood ur question what you want to do

1. Do you want to read the message and store in thedatabase
2. are you fetching the message from external source and want to store in database
3. any other

Author Comment

ID: 37015498
basically your #1 is what i am looking to do.  I have seen some sites use text messaging to store data into that users account.  So what i am looking to learn more about is what is needed to read text messages that coldfusion can interpret and store into a database for that user.

So for instance John Smith signs up at my site and is given a user_id.  I guess some sort of cell phone number registering would have to happen so that i can tell where the data is coming from.  then if John Smith texts "Hello World" to my site phone number, I can stick "Hello World" into the database and have their user_id recorded along with that for use.

I would like to know what services, software, etc i need to receive text messages at my server and work with that data.
LVL 16

Accepted Solution

Gurpreet Singh Randhawa earned 2000 total points
ID: 37017165

1. Are you using any third Party Service like SMSlane.com who gives their API to use the service
2. Or you want to use Coldfusion's SMS Gateway to make the Messages Work.

In both above, you need the Phone Number of the Guy and Send the message through the cfmail also. Use can check Ben nadel's Link here!


Also use their Phone number as a Registration and once they recieve it and send it show in the the outbox/inbox you created as create two tables wit the name of msgInbox and msgOutbox, and after reading or sending make a cfquery to store the message in the database and then after the cfquery use the actual cfmail or external API to send the message to the user

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
This is an updated version of a post made on my blog over 3 years ago. It is unfortunately, still very relevant as we continue to see both SQLi (SQL injection) and XSS (cross site scripting) attacks hitting some of the most recognizable website and …
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses
Course of the Month14 days, 11 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question