Editable, sortable JS-based table script?
June 6, 2011 10:10 AM Subscribe
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.
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.
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
posted by rkent at 10:21 AM on June 6, 2011
Response by poster: 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
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
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
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
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
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
posted by talkingmuffin at 1:46 PM on June 6, 2011
This thread is closed to new comments.
posted by omnipotentq at 10:12 AM on June 6, 2011