Finally, Automated Forms for MySQL and PHP!

[JLHeidecker]

What's needed:

An automated way of generating record control of a MySQL database, scripted in php.

This should be easy! Simply hand a script the database, and let it do the rest. It would:

1) Determine how many fields in the database, and what they are called, type of data, etc.

2) Generated a display table in HTML based on this information. 1 HTML table column per field in the database.

3) Generated 'edit record' and 'add record' forms. 1 text field in the form per field in the database.

So, after exploring a couple packages at PEAR (DB_Table, HTML_QuickForm), phpForms, etc, I gave up looking for a solution and did it myself.

Was this a waste of time? Do those tools actually do what I want? Is there something else out there? Essentially what I made was a watered down version of phpMyAdmin.

[Shrike]

Some PHP frameworks offer Rails style code scaffolding which does this sort of thing, for example Symphony, Cake PHP. Might be worth looking at if just for comparison.

[JLHeidecker]

OK, thanks, I'll check those out.

Do you have any experience with HTML_forms (pear) or phpForms? I'm wondering if these will do what I want, and I just couldn't figure it out...