app that auto-generates CRUD UI for database table

Question

I have a MySQL database that has a few very simple tables.

I would like to find an app (implemented in Perl, Python or PHP) that will do the following:

1. Point the app to a database table, and it automatically retrieves the table's schema from the database.
2. It then generates an HTML view of the table's data. The data is displayed as a grid, with all fields being user-editable. If there are a lot of rows, then it automatically provides pagination.
3. Bonus points for allowing the user to click a column heading, which would then sort the data by that column.
4. Bonus points for allowing the data to be filtered by a "where" clause.

I have already looked at a few packages (phpMyAdmin, webmysql), but they do not seem to provide the editable table view. They seem more oriented towards database administrators. What I need is something that's more oriented towards someone who wants to view, enter and modify data.

Answer 1

Use phpGrid. This is all you need.

$dg = new C_DataGrid(“SELECT * FROM orders”, “orderNumber”, “orders”);
$dg -> display(); 

Outcome: