Hello All,

My first post, yippee! First, a little background ... I've been using PHP/MySQL since about 2000 and Perl since about 1997 (although Perl isn't used as much now). I've always created my PHP/MySQL web apps from scratch. However, I've recently been searching for a PHP generator that will produce insert, update, delete, view one, and view all code for MySQL tables. I've found several online (one by SQLMaestro which was ok) but the problem is that none of them account for the different relationships of tables and fields. Let's say you have a child table, tblchild(my_id, my_loc), which has a foreign key, my_id, which is simply a number that references the parent table, tblparent(my_id, my_name). When editing and viewing tblchild you want to see the my_name associated with my_id because just showing the number is useless. All generators I've tried simply do not handle these situations and just assume all fields are entered with simple text boxes. Basically, I should be able to specify how a field is displayed and stored (which may be two different values). So the $64,000 question is: does anyone know of such a generator? Thanks

-Tom

I've coded a function to generate MySQL query's from Arrays and various strings of data. I'm sure you can find a class or something via google.

Hi Mike, I should have been more specific. I have my own database class that handles all the generation of insert/updates/deletes when given an array of fieldnames and values. What I would like is a program to automagically generate the form and program flow using parent/child relations. In other words right now I just create my forms manually from a base form, then modify it to suite the table (I need a combobox here with these values and associate it with this field, I need a checkbox here, etc.). I want to tell a program what input type should represent a specific field (combobox, checkbox, date, etc) and then it would generate all the form and flow.

Although it certainly could be a PHP web app, I was looking for a windows app (or java) that would generate the code. Thanks!

-Tom

Query the information schemata when you generate the queries. All of the object, including key relationships, expose their meta data through system tables.

Take a look at the code behind PHPMyAdmin, it's a MySQL manager and it basically does what your describing above, i'm sure you could easily rip the code.