List Database, Table, and Field in php

Sun Oct 26, 2008 7:23 pm

Code:: <html> <head> <title>Listing every database, table, and field</title> </head> <body> <?php $user = "user"; $pass = "password"; $db = "dbname"; $link = mysql_connect( "server", $user, $pass ); if ( ! $link ) die( "Couldn't connect to MySQL" ); $db_res = mysql_list_dbs( $link ); while ( $db_rows = mysql_fetch_row( $db_res ) ) { print "$db_rows[0]\n"; if ( !@mysql_select_db( $db_rows[0], $link ) ) { print "<dl><dd>couldn't connect -- " . mysql_error() ." </dl>"; continue; } $tab_res = mysql_list_tables( $db_rows[0], $link ); print "\t<dl><dd>\n"; while ( $tab_rows = mysql_fetch_row( $tab_res ) ){ print "\t$tab_rows[0]\n"; $query_res = mysql_query( "SELECT * from $tab_rows[0]" ); $num_fields = mysql_num_fields( $query_res ); print "\t\t<dl><dd>\n"; for ( $x=0; $x<$num_fields; $x++ ){ print "\t\t"; print mysql_field_type( $query_res, $x ); print " "; print mysql_field_len( $query_res, $x ); print " "; print mysql_field_name( $query_res, $x ); print " "; print mysql_field_flags( $query_res, $x ); print " \n"; } print "\t\t</d1>\n"; } print "\t</d1>\n"; } mysql_close( $link ); ?> </body> </html>