Miffed with PHPMyAdmin, writing replacement

@Mr_Initial_ManNov 24.2007

I’ve had problems with PHPMyAdmin on my website’s server, so I figured I’d set out on a rather ambitious project: write my own database manager.

So, first question: how can I use PHP to get a list of table names and column names from MySQL?

to post a comment

PHP

@NogDogNov 24.2007 — #http://dev.mysql.com/doc/refman/5.0/en/show.html

@Mr_Initial_ManauthorNov 25.2007 — #Okay, more help with form needed...

here's the code for one of the pages:

[code=html]<?xml version="1.0" encoding="utf-8"?>
 <!DOCTYPE html PUBLIC "-/W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
 <html xml:lang="en" xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8" />
 <meta http-equiv="Content-Style-Type" content="text/css" />
 <meta http-equiv="Content-Script-Type" content="application/javascript" />
 <link type="text/css" rel="stylesheet" href="" />
 <title>MySQL Manager Index</title>
 </head>
 
  <body>
   <h1>MySQL Manager</h1>
   <h2>Viewing Tables in Database "coachrandom"</h2>
   <form action="view_table.php" method="get">
   <fieldset>
   <legend>Choose Table</legend>
   <div>
 
   <select name="database=coachrandom&amp;table">
 
   <option value="characters">characters</option>
   <option value="comchars">comchars</option>
   <option value="comics">comics</option>
   <option value="keywords">keywords</option>
   <option value="storylines">storylines</option>
 
   <option value="subjects">subjects</option>
   </select>
   <input type="submit" value="Open Table" />
   </div>
   </fieldset>
   </form>
   <script type="application/javascript" src="" />
  </body>
 
 </html>[/code]

Here's where I'm having trouble: [b]<select name="database=coachrandom&table">[/b]

I want the final result to be something like [i][u]url.php?database=my_database&table=my_table[/u][/i]

@Mr_Initial_ManauthorNov 25.2007 — #EDIT: I got it to work through a hidden control.

@chazzyNov 25.2007 — #ah... but my wheel has two times more rolling power!

@Mr_Initial_ManauthorNov 25.2007 — #Say what?

@afigueroaNov 25.2007 — #ah... but my wheel has two times more rolling power![/QUOTE]

goodyear ?

@Mr_Initial_ManauthorNov 26.2007 — #How'd we get onto the topic of wheels?

@NogDogNov 26.2007 — #Perhaps Chazzy was referring to the phrase "reinventing the wheel" with reference to recreating your own version of phpMyAdmin? (Just speculation on my part...I don't want to put words in his mouth...errr...keyboard.)

@Mr_Initial_ManauthorNov 26.2007 — #Well, I figured out what was going on with PHPmyAdmin, but it's still a good exercise!

Miffed with PHPMyAdmin, writing replacement

9 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Miffed with PHPMyAdmin, writing replacement

9 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

9 Comments(s) _↴

Also in #PHP _↴