本文整理汇总了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";
}
示例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 . '&table=' . urlencode($table['Name']) . '&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 . '&table=' . urlencode($table['Name']) . '&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(' ', ' ', htmlspecialchars($table['disp_name'])) . '</a>';
$link .= '</li>' . "\n";
$table['line'] = $link;
$tables_response[] = $table;
示例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 {
示例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";
}