$dbname="test";$loginname="user";$loginpass="password";$dbhost="localhost";
echo('
');echo('
echo("Database $dbname");$id_link= @mysql_connect($dbhost,$loginname,$loginpass);$tables=mysql_list_tables($dbname,$id_link);$num_tables=mysql_num_rows($tables);// store table names in an array$arr_tablenames[] ='';// store number of fields per table(index 0,1,2..) in an array$arr_num_fields[] ='';
for ($i=0;$i
}// store field names in a multidimensional array:
// [i] == table number, [ii] == field number for that tablefor ($i=0;$i
for ($ii=0;$ii
}
}
for ($i=0;$i
echo("
Table $arr_tablenames[$i]
echo('
for ($ii=0;$ii
echo("
");echo$hash_field_names[$i][$ii];
echo("
");}
echo("
");$number_of_rows= @mysql_num_rows($result);for ($iii=0;$iii
for ($ii=0;$ii
echo("
");echo$record[$ii];
echo("
");}
echo("
");}
echo("
");}
echo('');?>