So, basically I have an SQL database and want to be able to display an entire table on a web page (already done this part, not hard I know)...In addition to that, I would like for all of the results to be in text boxes or something similar so I can edit anything and just hit a save or update button of some kind and it'll update all the records in the database accordingly. I've found tons of places showing how to do the first part and haven't had a problem with that. I can't find a page that shows how to do the last part though and I don't really have the time to learn all I'd need to know to write this myself for only one page...

Anyways, I've googled this to death and haven't found what I'm looking for but maybe you guys can help? I've done something similar in an ASP page one that was used to update a company's employee directory but it's been a few years since I did that, and it was in VB not php...

Any help to some already written code would be appreciated... Thanks.

11/16/2006 3:50:56 PM

message_topic.aspx?topic=440899

11/16/2006 3:52:28 PM

I'm just looking for a very simple to write universal page. all it has to do is instead of putting everything as text in a table, is put it in text boxes so i can change each field very easily and quickly, much like having direct access like you could in Access or something except..well, through a web page and thus obviously from anywhere w/internet.

Ah well I guess I'll just code the damn thing tomorrow at work... hehe

11/17/2006 3:34:25 AM

phpmyadmin

11/17/2006 4:22:13 AM

should take 5 minutes to code this.

11/17/2006 8:22:53 AM

you want all the fields to always be editable, or do you want to be able to click an edit button on the right of each row that turns the fields into textboxes without reloading the page...

That seems like the cleanest implementation, but I guess if you are looking to do ALOT of editing of fields during a short period, then that would be too much overkill...

There are some *ajax* apps out there that you can just install for the field editing that I mentioned above, although you could probably code it yourself pretty quickly.

11/17/2006 10:26:18 AM

Quote :

"phpmyadmin"

11/17/2006 11:32:47 AM

i just found this - http://www.turboajax.com/turbodbadmin/
looks pretty slick. for simple edits, could be much faster than phpmyadmin

edit:
this looks pretty awesome, actually. if you want to build something yourself, you can use their TurboWidgets too http://www.turboajax.com/turbowidgets/

[Edited on November 17, 2006 at 11:43 AM. Reason : .]

11/17/2006 11:39:09 AM

i already have phpmyadmin..it isn't the interface i want. it's too slow and takes too long to get to where i want. i don't care if it's clean or not because it's just for me to use and not. i'll just code it.. shouldn't be too bad.

or i'll pay one of you like $40 via paypal to do it for me any takers?

11/17/2006 11:46:10 AM

i could do this for you. do you need me to code it on my own system and send it to you or can i work directly on your server?

11/17/2006 5:31:05 PM

would be easier to just work from ur own computer for something small like this.. I can send you the code I found that basically lists everything in the table if that helps... Let me know whacha wanna do.

11/17/2006 8:06:45 PM