\n"; echo "

omega MySQL Databases

"; $host = "omega"; $user = "sel_only"; $pw = "not-bad"; $conn_id = mysql_connect ($host,$user,$pw) or die("Unable to connect to $host as $user"); $result = mysql_query("SHOW DATABASES"); $db_array = array(); while ( $row = mysql_fetch_assoc($result) ) { $db_name = $row['Database']; $db_array[$db_name]['DB_Name'] = $db_name; $db_array[$db_name]['entry'] = "no"; } mysql_free_result($result); $db = "00_Database_Doc"; $table = "db_info"; mysql_select_db ($db) or die("Unable to select $db"); $sql = "SELECT * FROM $table ORDER BY DB_Name"; $result = mysql_query($sql) or die("Command failed: $sql"); while ( $row = mysql_fetch_assoc($result) ) { $db_name = $row['DB_Name']; if ( isset($db_array[$db_name]['DB_Name']) ) { foreach ( $row as $fn => $value ) { $db_array[$db_name][$fn] = $value; } $db_array[$db_name]['entry'] = "yes"; } } $colheads = ""; $i = 0; $iminus1 = mysql_num_fields($result) - 1; while ( $i < mysql_num_fields($result) ) // column headings { $meta = mysql_fetch_field($result, $i); $colheads .= "" . $meta->name . ""; $i++; } $colheads .= "\n"; mysql_free_result($result); echo "\n"; echo $colheads; $i = 0; foreach ( $db_array as $db_name ) { $i++; if ( $i > 10 ) { $i = 0; echo $colheads; } echo ""; if ( $db_name['entry'] == "yes" ) { foreach ( $db_name as $fn => $value ) { if ( $fn != "entry" ) { if ( !$value ) { $value = " "; } echo ""; } } } else { echo ""; echo ""; } echo "\n"; } echo "
$value" . $db_name['DB_Name'] . "no documentation
"; ?>