Editable, sortable JS-based table script?

June 6, 2011 10:10 AM

I'm looking for a (mostly) pre-made sortable, editable table script that hooks into a mySQL database.

I'm looking for a JS/PHP-based sortable table script like this or like this that has the added bonus of, when you click on a cell in the table, makes the cell editable so that when you hit "Enter" or click out of it, it updates the mySQL database with the new value that you put in. (Obviously the table values are pulled from a database, via PHP.) Double extra mega super dooper bonus points if you can edit the values, then have to hit a save button or something to apply the changes so that folks get a chance to make sure they want to apply the changes.

I'd rather not have to make this 100% from scratch, so even if there's something out there that's ~75% what I'm looking for, I'll modify it and go from there.

posted by omnipotentq to computers & internet (8 answers total)

Crud. Forgot to add that open source is much preferred. Thanks!
posted by omnipotentq at 10:12 AM on June 6, 2011

Have you already considered phpMyAdmin? I've never installed it, but I have used it as the front-end provided by a hosting company, and it was pretty decent for the types of tasks it sounds like you're interested in. If anything, might be a bit too complex for your needs (and maybe insufficiently "web 2.0-ish"), but in any case, definitely already written.
posted by rkent at 10:21 AM on June 6, 2011

Yeah, this actually needs to be something for regular users to utilize; so something that goes on the frontend of a site. phpMyAdmin is great and I use it nearly every day, but it's in the wrong area of what I'm looking for. Sorry, I should have specified that!
posted by omnipotentq at 10:24 AM on June 6, 2011

I'd recommend building a quick app using CakePHP, ruby on rails, or grails (if you're on tomcat / java). These frameworks all support scaffolding, which gives you these features really easily.
posted by jenkinsEar at 10:31 AM on June 6, 2011

I bet ActiveScaffold is almost exactly what you're looking for, but unfortunately it's Ruby, not PHP. But it's miraculous enough that it may be worth the language crossover. I tried to find you a PHP analog, but it doesn't look like there is such a thing.
posted by Nahum Tate at 11:21 AM on June 6, 2011

I have used the following tool with good results: DHTMLX Grid Object

The fee is nominal, but they have 30 days of support to help you get up and running and I've found it to work pretty well and it is nicely polished.
posted by dgran at 11:29 AM on June 6, 2011

jQuery Datatables can do that, although it requires some custom rendering of input tags, etc.
posted by MMALR at 1:15 PM on June 6, 2011

The Yii php framework is fantastic. I've found it to be highly functional out of the box and it comes with lots of options to add complexity.
posted by talkingmuffin at 1:46 PM on June 6, 2011