Log in

View Full Version : php/html mySQL Database Table Editor



Strangeplant
06-26-2006, 01:48 PM
Hi all,

Now that I have my password database up and running perfectly, I want to Edit/Add through a web interface. Searching around, I found one that seems to be good, only that I see it as overly complicated and therefore something I probably couldn't error-solve on my own and I'm sure there will be issues with my using php 4.4.2 and mySQl 5.0. Isn't there something simple that I can use? I only want to Add/Edit/Del from one table `users`, their name and password. I'll tackle this if I have to, but there have been many revisions to the three files mentioned below, and error reports, fixes and many updates, so to get it to work the first time is like buying one ticket to the New Jersey Lottery: It'll be won by someone from Connecticut.

The Table Editor I found is at: http://www.phpguru.org/downloads/TableEditor/TableEditor.phps

And it uses two include files, the first is Pager/Sliding.php and found at: http://cvs.php.net/viewvc.cgi/pear/Pager/Sliding.php?revision=1.11&view=markup

The second is Net/URL.php and found at: http://de.tikiwiki.org/xref-BRANCH-1-9/nav.html?lib/pear/Net/URL.php.source.html

Please advise, and thanks for reading this.

Twey
06-26-2006, 02:03 PM
Check out phpMyAdmin (http://www.phpmyadmin.net/).
I recommend using the default mysql command-line client, though. You'll get a much better feel for the language that way.

Strangeplant
06-26-2006, 03:16 PM
Well, I think this is even a bigger problem because I have to get the server admin involved. I need to avoid him because it will never get done (he's a grad student who is leaving sometime in the near future and only works ever-so-slowly part time.) Isn't there a simple stand-alone page I can use somewhere?

Twey
06-26-2006, 03:25 PM
Neither client has to be installed on the server in question; the machine on which the client is running merely needs access to the database.

Strangeplant
06-26-2006, 05:52 PM
Ah, I found another one, small, efficient, easy to install around mySPL Admin priviledges too. Works fine, called phpMyEdit. Found it at:http://platon.sk/projects/doc.php/phpMyEdit/html/index.html if anyone else is interested. It generates a html/php page to use to access and modify the database, and I can customize it if I need to later.

Solved my problem.

Strangeplant
06-26-2006, 07:10 PM
My last post. BTW, included are configuration files for many, many lauguages.