PHP database framework (easy insert, edit, search...)? Something like phpMyAdmin

Question

Hello I'm trying to find some kind of PHP framework that allows me to do some "database oriented programming". I mean something like Clipper and MS Access (I never used them, just heard about, so I might be a bit off).

Basically, the idea is that I create a database with a table "customers", for instance, containing ID, Name, Address and Telephone. Then the framework would connect to this database and easily allow me to create a form with (some of) those fields, set which ones should be searchable (using AJAX? :)) and so on. That would take my job of doing the database insert/edit/listing/search functions, just leaving me with the relationship of the tables (maybe it can understand foreing keys for some other cool features) and logic.

I don't know if I'm asking too much, but I don't think that's very specific (ie, many programmers would like to start with something like that). It's something similar to what phpMyAdmin, but it would be to the end-user, not to the admin.

Thanks

Answer 1

I know the symfony framework provides an "Admin generator", that generates some stuff like this -- not sure how close it is to what you're asking (it'll probably not do everything you need), but it might be a start.

For more informations, you can take a look at, for instance, day 12 of the jobeet tutorial.

Answer 2

You could look into something like Cake, or CodeIgniter both of which do much of the tedious work for you.

Answer 3

The closest frameworks to want you require are Symfony, Yii & CakePHP, they all have a console (command line) tool so quickly generte basic crud for them (symfony probably has the most complete functionity with it's admin generator, but also as a steeper learning curve than the other two)