diff --git a/htdocs/sql/db_printview.php b/htdocs/sql/db_printview.php new file mode 100755 --- /dev/null +++ b/htdocs/sql/db_printview.php @@ -0,0 +1,269 @@ + 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; + ?> + + + + + + + + + + + + + + + + + +
+ +
+ + + + + -- + + +  
+ + + +

+ + + +