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

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 "c开发者_开发技巧ustomers", 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

You may try Medoo. It`s very easy to use and learn, and importantly it is super-lightweight with only around 100KB only.

• Less than 100 KB, portable with only one file
• Extremely easy to learn and use, friendly construction
• Supports various common and complex SQL queries, data mapping, and prevent SQL injection
• Supports all SQL databases, including MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle and more
• Works well with every PHP frameworks, like Laravel, Codeigniter, Yii, Slim, and framework which supports singleton extension or composer
• Free Under MIT license

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.

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

The ezSQL library is also an option.

The WordPress wpdb class is a forked version of an early version of ezSQL.

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)

In some projects I have succesfully used MySQL Ajax Table Editor (MATE) http://www.mysqlajaxtableeditor.com/

It has it's limitations, but you do get all basic data management operations for an SQL table quick and easy by writing just one configuration file.

I think this is best suited for admin interfaces, I would not use MATE for open-to-whole-internet type of pages.

you can use yii curd generator (3rd video here here) for this , very easy to use and implement. if you like to know latest php frameworks check this out http://codepappa.com/php-frameworks/

Try this MWEB Database API my own made PHP Database API