Database Admin
This PHP class makes it very easy to manage simple data stored in a MySQL database. At this time I'm currently just releasing the source code, examples and better documentation should follow. I've been using this code for over a year now on a number of projects, some fairly important. I can ensure that I haven't had any problems and all the data has been managed properly. At the same time, I can't be responsible if this trashes your database.
This code is released under the LGPL.
Releases:
-
11/11/2007 1.11
New auto_output function. Creating interfaces is never easier now. Literally no HTML is required now. Added delete button to edit pages. Corrected bug in 1.10 that broke the 'No' button when confirming deletions. -
07/31/2007 1.10
Added support to connect to database through class allowing easily switching between multiple databases and no need for your own connection code. Also added the subdispcol info. Added support for a password field that will store passwords using a hash. -
07/02/2007 1.09
Added populate function to replace the populate select function. populate takes an additional value to populate both radio or select inputs. populateRadio function was also added as an alias to the populate function, added $id variable so any column can be used for IDs. Added 'where' SQL ability to the populate functions. -
06/25/2007 1.08
Added ability to control whether items could be editted -
07/09/2006 1.07
Added radio inputs and added label tags in proper places -
07/01/2006 1.06
Added populateSelect function to pull data in from other tables -
06/11/2006 1.05
Fixed a bug with the categories involving text encoding and a bug with saving checkbox inputs -
06/10/2006 1.04
Added pagination system to item display -
05/29/2006 1.03
Fixed some issues with HTML encoding of the inputs and an issue with the form ids -
05/27/2006 1.02
Added support for sorting columns either ascending or descending -
05/22/2006 1.01
Added support for sorting data by certain columns -
05/19/2006 1.0
Inital release