当前位置: 首页>>代码示例>>PHP>>正文


PHP PMA_getTableList函数代码示例

本文整理汇总了PHP中PMA_getTableList函数的典型用法代码示例。如果您正苦于以下问题:PHP PMA_getTableList函数的具体用法?PHP PMA_getTableList怎么用?PHP PMA_getTableList使用的例子?那么, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了PMA_getTableList函数的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: PMA_displayDbList


//.........这里部分代码省略.........
                    id="<?php 
                echo htmlspecialchars($db['name']);
                ?>
"
                    href="index.php?<?php 
                echo $common_url_query;
                ?>
"
                    target="_parent"
                    title="<?php 
                echo htmlspecialchars($db['comment']);
                ?>
"
                    onclick="
                        if (! toggle('<?php 
                echo $element_counter;
                ?>
', true))
                            window.parent.goTo('./navigation.php?<?php 
                echo $common_url_query;
                ?>
');
                        window.parent.goTo('./<?php 
                echo $GLOBALS['cfg']['DefaultTabDatabase'] . '?' . $common_url_query;
                ?>
', 'main');
                        return false;">
                    <?php 
                if ($GLOBALS['text_dir'] === 'rtl') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                echo htmlspecialchars($db['disp_name']);
                if ($GLOBALS['text_dir'] === 'ltr') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                ?>
                </a>
                <?php 
            } else {
                // with only 1 db available we dont need to refresh left frame
                // on db selection, only phpmain
                ?>
                <a href="<?php 
                echo $GLOBALS['cfg']['DefaultTabDatabase'] . '?' . $common_url_query;
                ?>
"
                    id="<?php 
                echo htmlspecialchars($db['name']);
                ?>
"
                    title="<?php 
                echo htmlspecialchars($db['comment']);
                ?>
">
                    <?php 
                if ($GLOBALS['text_dir'] === 'rtl') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                echo htmlspecialchars($db['disp_name']);
                if ($GLOBALS['text_dir'] === 'ltr') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                ?>
                </a>
                <?php 
            }
            if ($db['num_tables']) {
                if (isset($tables_full[$db['name']])) {
                    $tables = PMA_getTableList($db['name'], $tables_full[$db['name']]);
                } elseif (isset($tables_full[strtolower($db['name'])])) {
                    // on windows with lower_case_table_names = 1
                    // MySQL returns
                    // with SHOW DATABASES or information_schema.SCHEMATA: `Test`
                    // but information_schema.TABLES gives `test`
                    // bug #1436171
                    // sf.net/tracker/?func=detail&aid=1436171&group_id=23067&atid=377408
                    $tables = PMA_getTableList($db['name'], $tables_full[strtolower($db['name'])]);
                } else {
                    $tables = PMA_getTableList($db['name']);
                }
                $child_visible = (bool) ($GLOBALS['PMA_List_Database']->count() === 1 || $db_start == $db['name']);
                PMA_displayTableList($tables, $child_visible, '', $db['name']);
            } elseif ($GLOBALS['cfg']['LeftFrameLight']) {
                // no tables and LeftFrameLight:
                // display message no tables in selected db
                echo '<p>' . $GLOBALS['strSelectADb'] . '</p>' . "\n";
            }
            echo '</li>' . "\n";
        }
        // end foreach db
    }
    // end foreach group
    if ($close_db_group) {
        $url_dbgroup = '';
        echo '</ul>';
        echo '</li>';
        $close_db_group = false;
    }
    echo '</ul>' . "\n";
}
开发者ID:JakubMarden,项目名称:eshop,代码行数:101,代码来源:navigation.php

示例2: PMA_generate_common_url

<?php

/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * DB search optimisation
 *
 * @package PhpMyAdmin
 */
require_once 'libraries/common.inc.php';
require_once 'libraries/common.lib.php';
$db = $_GET['db'];
$table_term = $_GET['table'];
$common_url_query = PMA_generate_common_url($GLOBALS['db']);
$tables_full = PMA_getTableList($db);
$tables_response = array();
foreach ($tables_full as $key => $table) {
    if (strpos($key, $table_term) !== false) {
        $link = '<li class="ajax_table"><a class="tableicon" title="' . htmlspecialchars($link_title) . ': ' . htmlspecialchars($table['Comment']) . ' (' . PMA_formatNumber($table['Rows'], 0) . ' ' . __('Rows') . ')"' . ' id="quick_' . htmlspecialchars($table_db . '.' . $table['Name']) . '"' . ' href="' . $GLOBALS['cfg']['LeftDefaultTabTable'] . '?' . $common_url_query . '&amp;table=' . urlencode($table['Name']) . '&amp;goto=' . $GLOBALS['cfg']['LeftDefaultTabTable'] . '" >';
        $attr = array('id' => 'icon_' . htmlspecialchars($table_db . '.' . $table['Name']));
        if (PMA_Table::isView($table_db, $table['Name'])) {
            $link .= PMA_getImage('s_views.png', htmlspecialchars($link_title), $attr);
        } else {
            $link .= PMA_getImage('b_browse.png', htmlspecialchars($link_title), $attr);
        }
        $link .= '</a>';
        // link for the table name itself
        $href = $GLOBALS['cfg']['DefaultTabTable'] . '?' . $common_url_query . '&amp;table=' . urlencode($table['Name']) . '&amp;pos=0';
        $link .= '<a href="' . $href . '" title="' . htmlspecialchars(PMA_getTitleForTarget($GLOBALS['cfg']['DefaultTabTable']) . ': ' . $table['Comment'] . ' (' . PMA_formatNumber($table['Rows'], 0) . ' ' . __('Rows') . ')') . '" id="' . htmlspecialchars($table_db . '.' . $table['Name']) . '">' . str_replace(' ', '&nbsp;', htmlspecialchars($table['disp_name'])) . '</a>';
        $link .= '</li>' . "\n";
        $table['line'] = $link;
        $tables_response[] = $table;
开发者ID:nicokaiser,项目名称:phpmyadmin,代码行数:31,代码来源:db_tables_search.php

示例3: unset

        <?php 
        if ($style == 'even') {
            $style = 'odd';
        } else {
            $style = 'even';
        }
    }
    unset($tmp_link);
    ?>
    </tbody>
    </table>
<?php 
}
$sep = $GLOBALS['cfg']['LeftFrameTableSeparator'];
// Get list of tables
$table_list = PMA_getTableList($GLOBALS['db']);
// For each table try to get the tracking version
foreach ($table_list as $key => $value) {
    // If $value is a table group.
    if (array_key_exists('is' . $sep . 'group', $value) && $value['is' . $sep . 'group']) {
        foreach ($value as $temp_table) {
            // If $temp_table is a table with the value for 'Name' is set,
            // rather than a propery of the table group.
            if (is_array($temp_table) && array_key_exists('Name', $temp_table)) {
                if (PMA_Tracker::getVersion($GLOBALS['db'], $temp_table['Name']) == -1) {
                    $my_tables[] = $temp_table['Name'];
                }
            }
        }
        // If $value is a table.
    } else {
开发者ID:hackersforcharity,项目名称:rachelpiOS,代码行数:31,代码来源:db_tracking.php

示例4: PMA_displayDbList


//.........这里部分代码省略.........
                } else {
                    printf($href_left, $element_counter, PMA_generate_common_url() . $url_dbgroup);
                    printf($img_minus, $element_counter);
                }
                echo '</a>';
                // ... and we need to refresh both frames on db selection
                ?>
 
                <a class="item"
                    id="<?php 
                echo htmlspecialchars($db['name']);
                ?>
"
                    href="index.php?<?php 
                echo $common_url_query;
                ?>
"
                    target="_parent" 
                    title="<?php 
                echo htmlspecialchars($db['comment']);
                ?>
" 
                    onclick="
                        if ( ! toggle('<?php 
                echo $element_counter;
                ?>
', true) )
                            window.parent.goTo( './left.php?<?php 
                echo $common_url_query;
                ?>
' );
                        window.parent.goTo( './<?php 
                echo $GLOBALS['cfg']['DefaultTabDatabase'] . '?' . $common_url_query;
                ?>
', 'main' );
                        return false;">
                    <?php 
                if ($GLOBALS['text_dir'] === 'rtl') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                echo htmlspecialchars($db['disp_name']);
                if ($GLOBALS['text_dir'] === 'ltr') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                ?>
 
                </a>
                <?php 
            } else {
                // with only 1 db available we dont need to refresh left frame
                // on db selection, only phpmain
                ?>
 
                <a href="<?php 
                echo $GLOBALS['cfg']['DefaultTabDatabase'] . '?' . $common_url_query;
                ?>
"
                    id="<?php 
                echo htmlspecialchars($db['name']);
                ?>
"
                    title="<?php 
                echo htmlspecialchars($db['comment']);
                ?>
">
                    <?php 
                if ($GLOBALS['text_dir'] === 'rtl') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                echo htmlspecialchars($db['disp_name']);
                if ($GLOBALS['text_dir'] === 'ltr') {
                    echo ' <bdo dir="ltr">(' . $db['num_tables'] . ')</bdo> ';
                }
                ?>
 
                </a>
                <?php 
            }
            if ($db['num_tables']) {
                $tables = PMA_getTableList($db['name']);
                $child_visible = (bool) ($num_dbs === 1 || $db_start == $db['name']);
                PMA_displayTableList($tables, $child_visible, '', $db['name']);
            } elseif ($GLOBALS['cfg']['LeftFrameLight']) {
                // no tables and LeftFrameLight:
                // display message no tables in selected db
                echo '<p>' . $GLOBALS['strSelectADb'] . '</p>' . "\n";
            }
            echo '</li>' . "\n";
        }
        // end foreach db
    }
    // end foreach group
    if ($close_db_group) {
        $url_dbgroup = '';
        echo '</ul>';
        echo '</li>';
        $close_db_group = false;
    }
    echo '</ul>' . "\n";
}
开发者ID:BackupTheBerlios,项目名称:vhcs-svn,代码行数:101,代码来源:left.php


注:本文中的PMA_getTableList函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。