Allowing an end-user to UPDATE MySQL db
Posted: Fri Aug 22, 2008 11:06 am
I can't find anything in the tutorial that addresses this issue.
We have no trouble submitting and INSERTING data into MySQL.
But how can I allow an end-user to UPDATE existing personal information in the MySQL db?
We don't want to create additional users, just UPDATE the existing data.
Scenario #1 Outbound:
Let's say there are 3 end-users in our MySQL db.
And there are 3 columns "first_name", "last_name" & "phone".
They are populated as follows:
Chris, Jones, 111-111-1000
Pat, McNally, 222-222-2000
Sally, Wallace, 333-333-3000
In a call out to Chris at 111-111-1000,
Chris decides to UPDATE the phone number to 555-555-5000,
But makes NO CHANGES to either "first_name" or "last_name".
In a call out to Pat at 222-222-2000,
Pat wants to UPDATE her name to PATRICIA,
and makes NO CHANGES to "last_name" or "phone".
Sally makes no UPDATES at all.
But we need to give her and everyone else the ability to UPDATE their info.
The opportunity for end-users to UPDATE data will be made over several different vxml documents.
They are not bunched up in one vxml file.
Scenario #2 Inbound:
Sally Wallace calls in to our 800 number with the intention of changing her last name to "Smith".
She enters her 4 digit PIN number, and her phone number to gain access to her individual MySQL data to UPDATE her info.
How do we set that up so that Sally can UPDATE her info ("last_name" only) without changing anyone else's data.
Got any suggestions? Help?
We have no trouble submitting and INSERTING data into MySQL.
But how can I allow an end-user to UPDATE existing personal information in the MySQL db?
We don't want to create additional users, just UPDATE the existing data.
Scenario #1 Outbound:
Let's say there are 3 end-users in our MySQL db.
And there are 3 columns "first_name", "last_name" & "phone".
They are populated as follows:
Chris, Jones, 111-111-1000
Pat, McNally, 222-222-2000
Sally, Wallace, 333-333-3000
In a call out to Chris at 111-111-1000,
Chris decides to UPDATE the phone number to 555-555-5000,
But makes NO CHANGES to either "first_name" or "last_name".
In a call out to Pat at 222-222-2000,
Pat wants to UPDATE her name to PATRICIA,
and makes NO CHANGES to "last_name" or "phone".
Sally makes no UPDATES at all.
But we need to give her and everyone else the ability to UPDATE their info.
The opportunity for end-users to UPDATE data will be made over several different vxml documents.
They are not bunched up in one vxml file.
Scenario #2 Inbound:
Sally Wallace calls in to our 800 number with the intention of changing her last name to "Smith".
She enters her 4 digit PIN number, and her phone number to gain access to her individual MySQL data to UPDATE her info.
How do we set that up so that Sally can UPDATE her info ("last_name" only) without changing anyone else's data.
Got any suggestions? Help?