//--> </script> <noscript> <input type="submit" value="<?php echo __('Go'); ?> " /> </noscript> <?php echo implode("\n", $hidden_fields) . "\n"; ?> </div> </form> <?php // display again the table list navigator PMA_listNavigator($total_num_tables, $pos, $_url_params, 'db_structure.php', 'frame_content', $GLOBALS['cfg']['MaxTableList']); ?> </div> <hr /> <?php // Routines //require './libraries/db_routines.inc.php'; // Events if (PMA_MYSQL_INT_VERSION > 50100) { require './libraries/db_events.inc.php'; } /** * Work on the database */ /* DATABASE WORK */
} PMA_displayTableList($table_list, true, '', $GLOBALS['db']); // lower table list paginator if (count($table_list) <= $GLOBALS['cfg']['MaxTableList'] && $table_count > $GLOBALS['cfg']['MaxTableList']) { PMA_listNavigator($table_count, $tpos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxTableList']); } } else { echo $GLOBALS['strNoTablesFound']; } unset($table_list); } elseif ($GLOBALS['cfg']['LeftFrameLight']) { echo '<p>' . $GLOBALS['strSelectADb'] . '</p>' . "\n"; } else { echo '<div id="databaseList">' . "\n"; $_url_params = array('pos' => $pos); PMA_listNavigator(count($GLOBALS['pma']->databases), $pos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxDbList']); echo '</div>' . "\n"; $common_url_query = PMA_generate_common_url(); PMA_displayDbList($GLOBALS['pma']->databases->getGroupedDetails($_SESSION['tmp_user_values']['navi_limit_offset'], $GLOBALS['cfg']['MaxDbList']), $_SESSION['tmp_user_values']['navi_limit_offset'], $GLOBALS['cfg']['MaxDbList']); } /** * displays collapsable db list * * @uses $_REQUEST['dbgroup'] * @uses $GLOBALS['cfg']['DefaultTabDatabase'] * @uses $GLOBALS['strSelectADb'] * @uses strpos() * @uses urlencode() * @uses printf() * @uses htmlspecialchars() * @uses PMA_generate_common_url()
/** * Displays the page */ if ($databases_count > 0) { reset($databases); $first_database = current($databases); // table col order $column_order['DEFAULT_COLLATION_NAME'] = array('disp_name' => $strCollation, 'description_function' => 'PMA_getCollationDescr', 'format' => 'string', 'footer' => PMA_getServerCollation()); $column_order['SCHEMA_TABLES'] = array('disp_name' => $strNumTables, 'format' => 'number', 'footer' => 0); $column_order['SCHEMA_TABLE_ROWS'] = array('disp_name' => $strRows, 'format' => 'number', 'footer' => 0); $column_order['SCHEMA_DATA_LENGTH'] = array('disp_name' => $strData, 'format' => 'byte', 'footer' => 0); $column_order['SCHEMA_INDEX_LENGTH'] = array('disp_name' => $strIndexes, 'format' => 'byte', 'footer' => 0); $column_order['SCHEMA_LENGTH'] = array('disp_name' => $strTotalUC, 'format' => 'byte', 'footer' => 0); $column_order['SCHEMA_DATA_FREE'] = array('disp_name' => $strOverhead, 'format' => 'byte', 'footer' => 0); $_url_params = array('pos' => $pos, 'dbstats' => $dbstats, 'sort_by' => $sort_by, 'sort_order' => $sort_order); PMA_listNavigator($databases_count, $pos, $_url_params, 'server_databases.php', 'frame_content', $GLOBALS['cfg']['MaxDbList']); $_url_params['pos'] = $pos; echo '<form action="./server_databases.php" method="post" name="dbStatsForm" id="dbStatsForm">' . "\n" . PMA_generate_common_hidden_inputs($_url_params); $_url_params['sort_by'] = 'SCHEMA_NAME'; $_url_params['sort_order'] = $sort_by == 'SCHEMA_NAME' && $sort_order == 'asc' ? 'desc' : 'asc'; echo '<table id="tabledatabases" class="data">' . "\n" . '<thead>' . "\n" . '<tr>' . "\n" . ($is_superuser || $cfg['AllowUserDropDatabase'] ? ' <th></th>' . "\n" : '') . ' <th><a href="./server_databases.php' . PMA_generate_common_url($_url_params) . '">' . "\n" . ' ' . $strDatabase . "\n" . ($sort_by == 'SCHEMA_NAME' ? ' <img class="icon" src="' . $pmaThemeImage . 's_' . $sort_order . '.png" width="11" height="9" alt="' . ($sort_order == 'asc' ? $strAscending : $strDescending) . '" />' . "\n" : '') . ' </a></th>' . "\n"; $table_columns = 3; foreach ($column_order as $stat_name => $stat) { if (array_key_exists($stat_name, $first_database)) { if ($stat['format'] === 'byte') { $table_columns += 2; $colspan = ' colspan="2"'; } else { $table_columns++; $colspan = ''; }
} PMA_displayTableList($table_list, true, '', $GLOBALS['db']); // lower table list paginator if (count($table_list) <= $GLOBALS['cfg']['MaxTableList'] && $table_count > $GLOBALS['cfg']['MaxTableList']) { PMA_listNavigator($table_count, $tpos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxTableList']); } } else { echo $GLOBALS['strNoTablesFound']; } unset($table_list); } elseif ($GLOBALS['cfg']['LeftFrameLight']) { echo '<p>' . $GLOBALS['strSelectADb'] . '</p>' . "\n"; } else { echo '<div id="databaseList">' . "\n"; $_url_params = array('pos' => $pos); PMA_listNavigator($GLOBALS['PMA_List_Database']->count(), $pos, $_url_params, 'navigation.php', 'frame_navigation', $GLOBALS['cfg']['MaxDbList']); echo '</div>' . "\n"; $common_url_query = PMA_generate_common_url(); PMA_displayDbList($GLOBALS['PMA_List_Database']->getGroupedDetails($_SESSION['userconf']['navi_limit_offset'], $GLOBALS['cfg']['MaxDbList']), $_SESSION['userconf']['navi_limit_offset'], $GLOBALS['cfg']['MaxDbList']); } /** * displays collapsable db list * * @uses $_REQUEST['dbgroup'] * @uses $GLOBALS['cfg']['DefaultTabDatabase'] * @uses $GLOBALS['strSelectADb'] * @uses strpos() * @uses urlencode() * @uses printf() * @uses htmlspecialchars() * @uses PMA_generate_common_url()