1);
if ($multi_tables) {
if (empty($GLOBALS['is_header_sent'])) {
require_once('./header.inc.php');
}
$tbl_list = '';
foreach ($the_tables AS $key => $table) {
$tbl_list .= (empty($tbl_list) ? '' : ', ')
. PMA_backquote(urldecode($table));
}
echo ''. $strShowTables . ': ' . $tbl_list . '' . "\n";
echo '
' . "\n";
echo '
' . $table . '
' . "\n";
/**
* Gets table informations
*/
$result = PMA_DBI_query('SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($table, TRUE) . '\';');
$showtable = PMA_DBI_fetch_assoc($result);
$num_rows = (isset($showtable['Rows']) ? $showtable['Rows'] : 0);
$show_comment = (isset($showtable['Comment']) ? $showtable['Comment'] : '');
PMA_DBI_free_result($result);
// Gets table keys and store them in arrays
$indexes = array();
$indexes_info = array();
$indexes_data = array();
$ret_keys = PMA_get_indexes($table, $err_url_0);
PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data);
/**
* Gets fields properties
*/
$result = PMA_DBI_query('SHOW FIELDS FROM ' . PMA_backquote($table) . ';', NULL, PMA_DBI_QUERY_STORE);
$fields_cnt = PMA_DBI_num_rows($result);
// Check if we can use Relations (Mike Beck)
if (!empty($cfgRelation['relation'])) {
// Find which tables are related with the current one and write it in
// an array
$res_rel = PMA_getForeigners($db, $table);
if (count($res_rel) > 0) {
$have_rel = TRUE;
} else {
$have_rel = FALSE;
}
}
else {
$have_rel = FALSE;
} // end if
/**
* Displays the comments of the table if MySQL >= 3.23
*/
if (!empty($show_comment)) {
echo $strTableComments . ': ' . $show_comment . '
';
}
/**
* Displays the table structure
*/
?>
|
|
|
|
' . $strLinksTo . '' . "\n";
}
if ($cfgRelation['commwork']) {
echo ' ' . $strComments . ' | ' . "\n";
}
if ($cfgRelation['mimework']) {
echo ' MIME | ' . "\n";
}
?>
NULL';
}
} else {
$row['Default'] = htmlspecialchars($row['Default']);
}
$field_name = htmlspecialchars($row['Field']);
echo "\n";
?>
' . $field_name . ' ' . "\n";
} else {
echo ' ' . $field_name . ' ' . "\n";
}
?>
|
> |
|
|
';
if (isset($res_rel[$field_name])) {
echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field'] );
}
echo ' ' . "\n";
}
if ($cfgRelation['commwork']) {
echo ' ';
$comments = PMA_getComments($db, $table);
if (isset($comments[$field_name])) {
echo htmlspecialchars($comments[$field_name]);
}
echo ' | ' . "\n";
}
if ($cfgRelation['mimework']) {
$mime_map = PMA_getMIME($db, $table, true);
echo ' ';
if (isset($mime_map[$field_name])) {
echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype']));
}
echo ' | ' . "\n";
}
?>
0) {
echo "\n";
?>
0) {
list($free_size, $free_unit) = PMA_formatByteDown($showtable['Data_free']);
list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length'] - $showtable['Data_free']);
} else {
unset($free_size);
unset($free_unit);
list($effect_size, $effect_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']);
}
list($tot_size, $tot_unit) = PMA_formatByteDown($showtable['Data_length'] + $showtable['Index_length']);
if ($num_rows > 0) {
list($avg_size, $avg_unit) = PMA_formatByteDown(($showtable['Data_length'] + $showtable['Index_length']) / $showtable['Rows'], 6, 1);
}
// Displays them
?>
|
|
|
|
|
|
|
|
0) {
$bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
echo "\n";
?>
ø |
|
0 && $mergetable == FALSE) {
$bgcolor = ((++$i%2) ? $cfg['BgcolorTwo'] : $cfg['BgcolorOne']);
echo "\n";
?>
ø |
|
Autoindex |
|
|
|
|
|
|
|
|
' . "\n";
} // end if
echo '
' . "\n";
} // end while
/**
* Displays the footer
*/
echo "\n";
?>