* Created : 20001101
* Modified : 20001101
*
* Viewer to see all databases and tables in a MySQL database
*************************************************************/
?>
TableViewer
\n";
echo " \n";
echo " | ";
echo " $dbname : ";
echo " $tblname";
echo " | \n";
echo "
\n";
echo " \n";
while ($field = @mysql_fetch_field ($result)) {
if (@mysql_num_rows ($result) > 0) {
echo " | $field->name | \n";
}
}
echo "
\n";
while ($row = mysql_fetch_row ($result)) {
($bgcolor == "#CCCCCC") ? $bgcolor = "#DDDDDD" : $bgcolor = "#CCCCCC";
echo " \n";
for ($i=0; $i < $num_fields; $i++) {
echo " | ".htmlspecialchars($row[$i])." | \n";
}
echo "
\n";
}
echo "\n";
}
/*************************************************************
* show_input_boxes
************************************************************/
function show_input_boxes () {
global $dbname, $tblname, $query, $PHP_SELF;
?>
\n";
echo " | Database: $dbname |
|---|
\n";
echo " \n";
for ($i = 0; $i < @mysql_num_rows ($result); $i++) {
$table = mysql_tablename ($result, $i);
echo "$table
\n";
}
echo " |
\n";
echo "\n";
}
/*************************************************************
* show_dbs
************************************************************/
function show_dbs () {
global $PHP_SELF;
$db_list = mysql_list_dbs();
echo "\n";
echo " | Databases |
|---|
\n";
echo " | \n";
while ($row = mysql_fetch_object ($db_list)) {
echo " Database\">$row->Database\n";
}
echo " |
\n";
echo "
\n";
}
/*************************************************************
* explain_table
************************************************************/
function explain_table ($result) {
global $dbname, $tblname, $PHP_SELF;
echo "[ Browse Table ]\n
";
echo "\n";
echo " \n";
echo " | ";
echo " $dbname : ";
echo " $tblname";
echo " | \n";
echo "
\n";
echo " \n";
echo " | Field | \n";
echo " Type | \n";
echo " maxLength | \n";
echo "
\n";
for ($i = 0; $i < @mysql_num_fields ($result); $i++) {
$field = mysql_fetch_field ($result);
($bgcolor == "#CCCCCC") ? $bgcolor = "#DDDDDD" : $bgcolor = "#CCCCCC";
echo " \n";
echo " | $field->name | \n";
echo " $field->type | \n";
echo " $field->max_length | \n";
echo "
\n";
}
echo "
\n";
}
/*************************************************************
* Start of script execution
************************************************************/
show_input_boxes();
// Connect to database
mysql_connect ("localhost");
mysql_select_db ($dbname);
echo "\n";
if (!$dbname || $dbname == '') {
show_dbs ();
} elseif (!$tblname || $tblname == '') {
show_tables ($dbname);
} elseif ($tblname != '' && $dbname != '') {
$query = "SELECT * FROM " . $tblname;
$result = mysql_query ($query);
if (!$result) {
echo "No database or table found.";
} elseif ($browse == 1 && @mysql_num_rows ($result) > 500) {
echo "Results returned exceeds 500 rows. Sorry.\n";
} elseif ($browse == 1) {
echo "( $query )
\n";
display_table ($result);
} else {
explain_table ($result);
}
}
echo "\n";
mysql_close();
?>