[SOLVED] PHP Framework that works with Existing Data

[senorpuerco]

I've got a fairly large MySQL database (about 20 tables, couple million records).  The table relationships are not too complicated, just some foreign keys, but all the tables intersect somehow with other tables. 

 

I was wondering if anyone knows of a PHP framework or something that will help me skip past the drudgery of creating a million pages for adding new records, editing records, deleting records, etc, for all 20 tables.  Something that could read my schema and create appropriate content management.  Any ideas?  Or does anyone know of any sort of shortcut for this problem?  Thanks for any help.

 

Also, if anyone knows of a good library for creating tables and charts from existing data, again, that would save me a lot of time.  Thanks.

[Mchl]

www.doctrine-project.org/

[gizmola]

Take a look at symfony.  Symfony was designed to be a clone of ruby on rails, and in fact has crud generation.  You may have to do some mapping of the tables if you are using mysql with myISAM tables, because myisam doesn't support constraints, and there is no way for the object/relational mapping engine to infer your relationships. 

 

With that said, symfony has the capability to do exactly what you want --- generate a whole usable system based on existing tables.

 

http://www.symfony-project.org/

 

Watch their demo screencast to see this all in action.

[senorpuerco]

That Doctrine project looks cool, but not quite what I'm looking for.  Symfony looks very cool, I've never used that framework before.  I had forgotten that all my foreign keys were inferred because I am using myisam.  The best part of your post, gizmola, was the phrase "crud generation".  That was the magic I needed to google.  Now I have a bunch of options.  Thanks.