$tables = $GLOBALS['dbi']->getTables($db); $count = 0; foreach ($tables as $table) { $comments = PMA_getComments($db, $table); echo '<div>', "\n"; echo '<h2>', htmlspecialchars($table), '</h2>', "\n"; /** * Gets table information */ $show_comment = $GLOBALS['dbi']->getTable($db, $table)->getStatusInfo('TABLE_COMMENT'); /** * Gets table keys and retains them */ $GLOBALS['dbi']->selectDb($db); $indexes = $GLOBALS['dbi']->getTableIndexes($db, $table); list($primary, $pk_array, $indexes_info, $indexes_data) = PMA\libraries\Util::processIndexData($indexes); /** * Gets columns properties */ $columns = $GLOBALS['dbi']->getColumns($db, $table); // Check if we can use Relations list($res_rel, $have_rel) = PMA_getRelationsAndStatus(!empty($cfgRelation['relation']), $db, $table); /** * Displays the comments of the table if MySQL >= 3.23 */ if (!empty($show_comment)) { echo __('Table comments:'), ' '; echo htmlspecialchars($show_comment), '<br /><br />'; } /** * Displays the table structure