Small simple mysql record editor
Posted on 2008-06-16
I have php code that connects to a MySQL database and grabs all the records I need. It then displays those records (one record per line - just text) on browser page. What I would like to do is add an edit button and a print button at the end of each of those records (note: the amount or records could vary from 30 to 200 any month). When the edit button is clicked, it opens a HTML Form, populates it with the data in that single record and only allows the user change a few things, when they are done making the needed changes, they click a save button which updates the MySQL database, and display the list of records again. If they click the print button - it display another html page and formats the record for printing, with another print button, when the print button is clicked, the page is set to a printer, and the original record list is displayed again.
I am not trying to ask that someone else code this (although if the wheel is already out there and offered I certainly would not ignore it!), just the best approach to take. I am familiar with PHP & HTML Forms, have never dove into JScript, or any of the other methods I might be able to use. All inputs are greatly appreciated.
I have tried using phpMyAdmin, and sidu - and the biggest problem I see with them is they have too much functionality for what I was hoping for.