$header_colour = '#357EC7';
try {
$pdo = new PDO("pgsql:host={$db_hostname};dbname={$db_database}", $db_user, $db_password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("ERROR: Cannot connect: " . $e->getMessage());
}
$query = "select table_name, column_name, data_type, comment from view_table_details where table_name = '{$table}' order by column_name";
print "<table border=\"1\" cellpadding=\"5\" cellspacing=\"0\" ><tr><td bgcolor=\"{$header_colour}\" colspan=\"20\" align=\"center\">{$table}</td></tr>\n";
print "<tr><td bgcolor=\"{$col_header_colour}\">Column Name</td><td bgcolor=\"{$col_header_colour}\">Data Type</td><td bgcolor=\"{$col_header_colour}\">Description</td></tr>\n";
foreach ($pdo->query($query) as $row) {
$column = $row['column_name'];
$data_type = $row['data_type'];
if ($row['comment'] == '') {
$comment = $column;
} else {
$comment = $row['comment'];
}
print "<tr><td>{$column}</td><td>{$data_type}</td><td>{$comment}</td></tr>\n";
}
print "</table>";
}
describe_table('indicators');
describe_table('moving_averages');
describe_table('standard_deviations_from_mean');
describe_table('exchange_indicators');
describe_table('gaps');
describe_table('gains');
?>
// Copyright (C) GPLv2 2011 Nathan A. Mourey II <*****@*****.**>
include "config/functions.php";
$db_table = $_REQUEST['table'];
$db_name = $_REQUEST['db'];
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>MySQL Database Managment.</title>
<link rel="stylesheet" type="text/css" href="css/db.css" />
</head>
<body>
<div id="title"><h2>MySQL Database Schema Viewing Tool.</h2></div>
<?php
if ($db_table && $db_name) {
/* If user is in db. List there databases. */
$html = describe_table($db_table, $db_name);
print $html;
print "<p/><div><center><h3><a href=\"tables.php?q={$db_name}\">Return list of tables in database {$db_name}</a></h3></center></div>";
} else {
print "<span id=\"desc_error\">Internal Error.</span>";
}
?>
<p id="copyright">Copyright © <a href="http://www.gnu.org/licenses/gpl-2.0.html" target="_top">GPLv2</a> 2011
<a href="mailto:nmoureyii@ne.rr.com">Nathan A. Mourey II</a></p>
</body>
</html>
