I've FINALLY finished my first PHP & MySQL database website, with NO prior programming experience
BUT.............. It's not hosted yet. I need to write one last program/page to enable editing/maintenance of the data.
The site is designed to allow users to post new records into a database which is later searched upon. They cannot post in all the fields, only some. I need some sort of secure method allowing me to remove/edit/update individual records as required (like you can do in phpMyadmin) when it's stored locally.
While you'd limit the privileges for normal site operation to SELECT & INSERT, I'm guessing you'd create another with ALL if not most privileges.
QUESTION
Is the best method of editing a database by the admin maintenance guy through a Username logon link on the site itself?
OR
Do you use a program specifically for database maintenance to limit the risk of the logon method being hacked?
OR
Are there other database maintenance methods?