0) { while ($tmp = PMA_DBI_fetch_row($result)) { // if in use memorize tablename if (preg_match('@in_use=[1-9]+@i', $tmp[0])) { $sot_cache[$tmp[0]] = true; } } PMA_DBI_free_result($result); if (isset($sot_cache)) { $result = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE); if ($result != false && PMA_DBI_num_rows($result) > 0) { while ($tmp = PMA_DBI_fetch_row($result)) { if (! isset($sot_cache[$tmp[0]])) { $sts_result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . PMA_sqlAddSlashes($tmp[0], true) . '\';'); $sts_tmp = PMA_DBI_fetch_assoc($sts_result); $tables[] = $sts_tmp; } else { // table in use $tables[] = array('Name' => $tmp[0]); } } PMA_DBI_free_result($result); $sot_ready = true; } } unset($tmp, $result); } } if (! isset($sot_ready)) { $result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ';'); if (PMA_DBI_num_rows($result) > 0) { while ($sts_tmp = PMA_DBI_fetch_assoc($result)) { $tables[] = $sts_tmp; } PMA_DBI_free_result($result); unset($res); } } */ /** * If there is at least one table, displays the printer friendly view, else * an error message */ $tables = PMA_DBI_get_tables_full($db); $num_tables = count($tables); echo '
'; // 1. No table if ($num_tables == 0) { echo __('No tables found in database.'); } else { // 2. Shows table information ?> ' . __('Size') . ''; } ?>
' . PMA_formatNumber($sts_data['TABLE_ROWS'], 0) . '' . "\n"; } else { echo PMA_formatNumber($sts_data['TABLE_ROWS'], 0) . "\n"; } ?> '; } else { $needs_break = ''; } if (! empty($sts_data['Create_time']) || ! empty($sts_data['Update_time']) || ! empty($sts_data['Check_time']) ) { echo $needs_break; ?>
--
\n"; require 'libraries/footer.inc.php'; ?>