How to retrieve user data stored in MySQL DB after a user logs in? 
Author: Bill S.
Visited 986,
Followers 2,
Shared 0
I created a page for a user to register by entering some info, name, address etc. Data is stored in an MSQL DB.
I have Professional 12 and used email form entry but save data to MySQL which works perfectly.
Now, I want the user to be able to login once more and retrieve and update this data
Question: How do I retrieve the data and place it in the same fields that he/she entered originally, then allow he/she to update the data without creating a new row in the DB?
Thank you very much in advance for your help
Bill
Posted on the
Hello Bill,
You can use the database viewer object in the page to show the data where you can enable the function to allow him to modify the data.
I would suggest to add this object only on a password protected page otherwise everyone who has access to the page can change the data.
Many thanks!
Hello Bill
Beware, that when using the database viewer, you will give access to all records in the table. You can not prevent a user from tampering another persons data. You should know this.
You have to make a script that can select records for only the logged-in user, if you want to prevent this.
Kind regards
John S.