Insert SMS message into database

Posted on 2011-10-23
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
    LVL 15

    Expert Comment

    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

    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 15

    Accepted Solution


    1. Are you using any third Party Service like 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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
    Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now