8

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.

Improve this question
3
  • 2
    @Galen: It might have to do with the fact that Mike W seems to want turnkey solutions to complex problems. @Mike W: What you are looking for requires wiring together a lot of components: Something like DBIx::Class, a template engine and some JavaScript module to provide the UI. Commented Nov 18, 2009 at 21:31
  • Actually, there is a java solution for exactly this problem that very recently came out called naked objects . nakedobjects.org Commented Nov 18, 2009 at 22:39
  • @Sinan-Unur: I just need something really simple. I don't need the UI to support fields that are references to other tables. All I want is to edit the "flat" fields (e.g. ints, varchars, timestamps). Since nothing seems to do exactly what I want , maybe I'll spend a few days and try to roll my own solution and post it back here. Commented Nov 20, 2009 at 6:02

5 Answers 5

Reset to default
4

Use phpGrid. This is all you need. 

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

Outcome:

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

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

Improve this answer

1 Comment

It looks cool, but the server I'm using has Perl, Python and PHP, but no java.
0

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.

Improve this answer

Comments

0

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.

Improve this answer

1 Comment

This link is dead now
0

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.

Improve this answer

1 Comment

HOLLY SMOKES! I likee! Thanks man, I bet you I've across it and had no idea what I was looking at!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.