MySQL – Dynamically Insert and Update Values In a MySQL Database Using OOP: Good stuff, because I hate writing admin interfaces. Just hate it.
We will make a class that goes out and looks for the values for us and builds a SQL statement on the fly. All we have to do is make sure the column names in the database correspond with the field names in the HTML form. Believe me when I say it saves TONS of time. I never write applications that don’t use it.
The default admin interface for personal sites I work on is phpMyAdmin.