";
echo "TABLE { border-collapse:collapse;border:1px solid gray; } TD {border:1px solid gray}";
echo "";
$results = mysqli_query($base, "SHOW TABLES");
if($results == false) die("Empty database");
$tables = array();
while($arr = mysqli_fetch_array($results))
{
array_push($tables, $arr['0']);
}
echo "Database structure : ".DB_NAME."
";
foreach($tables as $table)
{
$results = mysqli_query($base, "DESCRIBE $table");
echo "TABLE $table
\n";
echo "";
echo "| Name | \n";
while($arr = mysqli_fetch_array($results))
{
echo " ".$arr['0']." | ";
}
mysql_data_seek($results, 0);
echo "
\n";
echo "| Type | \n";
while($arr = mysqli_fetch_array($results))
{
echo " ".$arr['1']." | ";
}
mysql_data_seek($results, 0);
echo "
\n";
echo "| May be NULL | \n";
while($arr = mysqli_fetch_array($results))
{
echo " ".$arr['2']." | ";
}
mysqli_data_seek($results, 0);
echo "
\n";
echo "| PRIMARY KEY | \n";
while($arr = mysqli_fetch_array($results))
{
echo " ".$arr['3']." | ";
}
echo "
\n";
echo "
";
}
echo "
Scriptol.com";
?>