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

Question

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

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

Answer 2

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.