コード例 #1
0
ファイル: db_datadict.php プロジェクト: flash1452/phpmyadmin
$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