• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Insert SMS message into database

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.
0
theideabulb
Asked:
theideabulb
  • 2
1 Solution
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
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
0
 
theideabulbAuthor Commented:
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.
0
 
Gurpreet Singh RandhawaWeb DeveloperCommented:
ok!

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!

http://www.bennadel.com/blog/1057-Using-CFPOP-And-CFMAIL-For-Bidirectional-SMS-Text-Messaging-In-ColdFusion.htm

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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now