32 lines
1.1 KiB
PHP
32 lines
1.1 KiB
PHP
<?php
|
|
ini_set('display_errors', 1);
|
|
include "db.php";
|
|
|
|
$tableName = "schools";
|
|
if ($argc > 1) $tableName = $argv[1];
|
|
else {
|
|
$table = readline("Table (schools): ");
|
|
if (strlen(trim($table))) $tableName = $table;
|
|
}
|
|
|
|
$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");
|
|
|
|
?>
|