28 lines
956 B
PHP
28 lines
956 B
PHP
<pre>
|
|
<?php
|
|
include "db.php";
|
|
|
|
$tableName = "schools";
|
|
|
|
$pattern = "| %-60s | %-70s |\n";
|
|
$patternH = "| %-130s |\n";
|
|
|
|
printf("+---------------------------------------------------------------------------------------------------------------------------------------+\n");
|
|
printf($patternH, $tableName);
|
|
printf("+--------------------------------------------------------------+------------------------------------------------------------------------+\n");
|
|
|
|
printf($pattern,"Field","Type");
|
|
printf("+--------------------------------------------------------------+------------------------------------------------------------------------+\n");
|
|
|
|
$query = "SHOW columns FROM $tableName";
|
|
$results = db_query($query);
|
|
|
|
while ($row = db_fetch_array($results)) {
|
|
printf($pattern,$row[0],$row[1]);
|
|
}
|
|
|
|
printf("+--------------------------------------------------------------+------------------------------------------------------------------------+\n");
|
|
|
|
?>
|
|
</pre>
|