homepage Welcome to WebmasterWorld Guest from 54.197.19.35
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe to WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Integrating SMS Replies with database
Need major help figuring this one out
BennyBlanco




msg:3452789
 2:17 pm on Sep 17, 2007 (gmt 0)

Hey everyone,

I posted this in mobile computing and there doesn't seem to be many eyeballs over there. We've developed a site that gathers leads for our clients and distributes them to the client's reps. Currently, the reps need to log in to the site to either accept or reject the leads because if they don't accept them within a few hours, the leads get passed on to the next rep. Because of the time sensitive nature of the leads, we want to integrate an SMS system that would send them an SMS alert along with the ability to reply with a simple "1" to accept the lead or "2" to reject it. Then we need to accept those responses and gather them into our dbase (MySQL) and interpret them accordingly.

I know one of you geniuses out there must have done something similar. Please help me out on this one as I am slamming my head into a wall looking at gateways.

Benny

 

jatar_k




msg:3452853
 3:19 pm on Sep 17, 2007 (gmt 0)

I have done similar types of things with email

- store leads in db
- send email and check a column as sent
- id in subject of email
- person replies with appropriate response
- email is sent to a processing address which uses [procmail.org...]
- procmail sends it through a script that will process the response
- set column to confirm or resend to next person

BennyBlanco




msg:3452867
 3:27 pm on Sep 17, 2007 (gmt 0)

But have you done this with SMS ever? Responses with email is something we have done in the past as well, but never with SMS. Thanks

jatar_k




msg:3452868
 3:30 pm on Sep 17, 2007 (gmt 0)

it isn't that different, you need to send a message to a phone and you you need the message sent back to where a script can get at it and process it

BennyBlanco




msg:3452877
 3:41 pm on Sep 17, 2007 (gmt 0)

Exactly. Just wondering if anyone can help with a recommended SMS gateway or an existing script that may help.

BennyBlanco




msg:3454026
 5:10 pm on Sep 18, 2007 (gmt 0)

Anyone else able to lend some knowledge?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved