Edit MySQL database via HTML-- options?

Question

I have a MySQL database (currently using phpmyadmin to manage) that I would like to display as an HTML table and be able to edit the records/columns directly.

What are my options on implementing this? I'm not sure of the terminology I should be seeking out for more information.

I'm already using php/mysql to display the table with checkboxes for deleting multiple records on the fly, but I need to be able to see the full entries on the page and edit individual values.

Also, anyway to 'sort' via an HTML table? Not necessary, just curious.

have you looked into any grid plug ins? jsGrid, openjs etc ? — Elen
– Elen, Commented May 9, 2012 at 16:53

Ed Manet · Accepted Answer · 2012-05-09 17:12:11Z

3

Take a look at phpGrid http://phpgrid.com/ It's got all the bells and whistles and is pretty easy to implement.

answered May 9, 2012 at 17:12

Ed Manet

3,1783 gold badges23 silver badges23 bronze badges

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

Comments

Shiplu Mokaddim · Accepted Answer · 2012-05-09 16:54:42Z

1

A great tool for this is phpMyAdmin. Programming something like this yourself is difficult.

There might be other "lighter" alternatives. Take a look at this: http://www.google.com/search?q=database+html

edited May 9, 2012 at 16:54

Shiplu Mokaddim

57.5k20 gold badges147 silver badges193 bronze badges

answered May 9, 2012 at 16:52

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

8 Comments

benastan Over a year ago

I prefer sqlbuddy to phpMyAdmin sqlbuddy.com. I'm not sure if OP is looking for a mysql administration panel though.

Shiplu Mokaddim Over a year ago

Simplified your google search URL, A full url exposes a lot of personal information!

Commandrea Over a year ago

I use phpMyAdmin to do simple SQL stuff, but this is a little trickier as the edits I need to make are based on an individual's availability and not 'updates' etc. I'd love some advice on other ways to harness the power of phpmyadmin. I have a schedule of people, some are 'reserves', I need to change them from 'reserve'one by one into 'position x'-- ideas on this via phpmyadmin?

OptimusCrime Over a year ago

Hmm, you might be right. But using a full system like this would make every management much simpler. Auto inc and so on. I'd recommend this.

Commandrea Over a year ago

"Programming something like this yourself is difficult." If that's the case, then I'll stick w/ manual updates via phpmyadmin and my csv files :) I'm spread too thin to take on a big challenge at the moment.

|

Collectives™ on Stack Overflow

Edit MySQL database via HTML-- options?

2 Answers 2

Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related