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 \'' . addslashes($tmp[0]) . '\';'); $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 $strNoTablesFound; } // 2. Shows table informations on mysql >= 3.23.03 - staybyte - 11 June 2001 else { ?> ' . $strSize . ''; } ?>
' . 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; ?>
--