http://www.vbulletin.org/forum/showthread.php?t=33223
كود PHP:
<html>
<head>
<title> MYSQL Database</title>
</head>
<body>
<?
// Change the information below
$host = "localhost";
$user = "crooks";
$pass = "crooks*JJn";
$dbase = "crooksdb";
//connect en selecteer DB;
$databaseconnectie = mysql_pconnect($host, $user, $pass);
mysql_select_db($dbase, $databaseconnectie);
//Tel tabellen;
$result_handle = mysql_list_tables ($dbase,$databaseconnectie)
or die ("mysql_list_tables () failed with this error message: '"
.mysql_error () ."'");
$number_tables = mysql_num_rows ($result_handle);
echo "Database <b>$dbase</b> contains $number_tables tabels:";
echo "<br>Each <b>tabel</b> has their own <i>type</i>, lengte & <b> colomname</b>.<br><br>";
//Noem tabellen;
for ($index=0; $index < $number_tables; ++$index) {
$tnaam = mysql_result ($result_handle, $index, 0);
$query = mysql_list_fields ($dbase, mysql_result ($result_handle, $index, 0))
or die ("mysql_list_fields () failed with this error message:'"
.mysql_error() . "'");
//Tel kolommen en aantal regels;
?>
<table width="100%" border="0">
<?
$number_fields = mysql_num_fields ($query);
$test = "SELECT * FROM $tnaam";
$result = @ mysql_query ($test);
$aantal = mysql_num_rows($result);
echo "<tr><td>","Tabel <b>$tnaam</b> contains $number_fields colum(s), with $aantal rule(s):<br></td></tr>";
?>
</table><br><table width="100" border="2">
<?
//Noem types,lengte en kolommen;
for ($index2=0; $index2 < $number_fields; ++$index2){
$dtype = mysql_field_type($query, $index2);
$knaam = mysql_field_name($query, $index2);
$lengte = mysql_field_len($query, $index2);
echo "<tr><td><i>$dtype</i></td>";
echo "<td>$lengte</td>";
echo "<td><b>$knaam</b></td></tr>";
}
?></table><br><?
}
?>
(c) Lesane
</body>
</html>