List Database, Table, and Field
Listing every database, table, and field
$db_rows[0]\n";
if ( !@mysql_select_db( $db_rows[0], $link ) ) {
print "- couldn't connect -- " . mysql_error() ."
";
continue;
}
$tab_res = mysql_list_tables( $db_rows[0], $link );
print "\t
- \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
- \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\n";
}
print "\t\n";
}
mysql_close( $link );
?>