$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>