Newbie! Allow member to edit mysql database

php mysql edit database

[cakey]

I'm new to using Mysql and php basically out of neccessity as our programmer has no time to sort our probs!

We need to let people who have registered on our site to be able to edit their details. I guess they would log in using their email address and password then the form would return the details we have about them on the database e.g dob, email, name and address. They would then be able to update these details.

I am sure this is very simple and probably a dumb question but any help would be much appreciated.

[RonPK]

Hello cakey, welcome to the board!

What you want is not that hard to build - for a moderately experienced programmer. Some knowledge of handling sessions, connecting to a database, and validating the user's input is essential.

Your task is too non-trivial for me to simply give an example. No offence, but I must suggest that you read through a PHP tutorial; there are quite many on the web. There also are tons of books which will give you more insight into building web applications with PHP and MySQL.

[henry0]

Please also consider another possible problem.
You might open a Pandora box by allowing editing
Which as RonPk mentioned can be self-tought via tutorials
But you main worry should not only be the editing
BUT how secure it will be in order to thwart any hacking attempt.
What do you need to look for?
Authentication script
Connecting, reading, editing a DB
Making you data secured

Check our library many of your questions might be already answered in there.

<edit>Added link</edit>
Here you go [webmasterworld.com]