CODEWITHSUNDEEP
phpmysqldatabaseperluser-interface
Mike W
Mike W

Reputation: 747

app that auto-generates CRUD UI for database table

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.

Upvotes: 8

Views: 7667

Answers (5)

powtac
powtac

Reputation: 41050

Use CakeApp.com, it does exactly what you want!

CakeApp.com is a rapid development online tool. It's easy to use, no other software than your browser is needed. Benefit from ER-Diagrams of others and share your visions too.

Upvotes: 0

Audrey
Audrey

Reputation: 148

Use phpGrid. This is all you need. 

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

Outcome:

enter image description here

Upvotes: 4

Mike W
Mike W

Reputation: 747

Thanks for the responses, but none of those exactly fit the bill, so I decided to implement it myself.

The result is a new open source project called DWI, which stands for Database Web Interface. It took me about 3 days to get it working, and I did it in about 600 lines of PHP and javascript.

If you want to check it out, it's located at http://code.google.com/p/dwi.

Upvotes: 0

ankimal
ankimal

Reputation: 925

If you can use groovy then Grails can get you jump started. It will build an ORM of your entire DB, build views and your basic CRUD is all built in.

If you have a real aversion to anything thats Java-based then perl's Catalyst can help build all your mappings but might not get you the whole 9 yards. You will need to write some of your basic CRUD, which is easy and can be accomplished by simple following the Catalyst tutorial.

Upvotes: 0

Zak
Zak

Reputation: 25205

See if Java NakedObejcts is what you want. http://www.nakedobjects.org

Upvotes: 0

Related Questions