PHP PMA_getCollationDescr函数代码示例

/**
 * Returns the html for Collations of Current Charset.
 *
 * @param String $currCharset        Current Charset
 * @param Array  $mysqlColl          Collations list
 * @param Array  $mysqlDefaultColl   Default Collations list
 * @param Array  $mysqlCollAvailable Available Collations list
 *
 * @return string
 */
function PMA_getHtmlForCollationCurrentCharset($currCharset, $mysqlColl, $mysqlDefaultColl, $mysqlCollAvailable)
{
    $odd_row = true;
    $html = '';
    foreach ($mysqlColl[$currCharset] as $current_collation) {
        $html .= '<tr class="' . ($odd_row ? 'odd' : 'even') . ($mysqlDefaultColl[$currCharset] == $current_collation ? ' marked' : '') . ($mysqlCollAvailable[$current_collation] ? '' : ' disabled') . '">' . "\n" . '    <td>' . htmlspecialchars($current_collation) . '</td>' . "\n" . '    <td>' . PMA_getCollationDescr($current_collation) . '</td>' . "\n" . '</tr>' . "\n";
        $odd_row = !$odd_row;
    }
    return $html;
}

 function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION, $name = null, $id = null, $default = null, $label = TRUE, $indent = 0, $submitOnChange = FALSE, $displayUnavailable = FALSE)
 {
     global $mysql_charsets, $mysql_charsets_descriptions, $mysql_charsets_available, $mysql_collations, $mysql_collations_available;
     if (empty($name)) {
         if ($type == PMA_CSDROPDOWN_COLLATION) {
             $name = 'collation';
         } else {
             $name = 'character_set';
         }
     }
     $spacer = '';
     for ($i = 1; $i <= $indent; $i++) {
         $spacer .= '    ';
     }
     $return_str = $spacer . '<select xml:lang="en" dir="ltr" name="' . htmlspecialchars($name) . '"' . (empty($id) ? '' : ' id="' . htmlspecialchars($id) . '"') . ($submitOnChange ? ' onchange="this.form.submit();"' : '') . '>' . "\n";
     if ($label) {
         $return_str .= $spacer . '    <option value="">' . ($type == PMA_CSDROPDOWN_COLLATION ? $GLOBALS['strCollation'] : $GLOBALS['strCharset']) . '</option>' . "\n";
     }
     $return_str .= $spacer . '    <option value="">&nbsp;</option>' . "\n";
     foreach ($mysql_charsets as $current_charset) {
         if (!$mysql_charsets_available[$current_charset]) {
             continue;
         }
         $current_cs_descr = empty($mysql_charsets_descriptions[$current_charset]) ? $current_charset : $mysql_charsets_descriptions[$current_charset];
         if ($type == PMA_CSDROPDOWN_COLLATION) {
             $return_str .= $spacer . '    <optgroup label="' . $current_charset . '" title="' . $current_cs_descr . '">' . "\n";
             foreach ($mysql_collations[$current_charset] as $current_collation) {
                 if (!$mysql_collations_available[$current_collation]) {
                     continue;
                 }
                 $return_str .= $spacer . '        <option value="' . $current_collation . '" title="' . PMA_getCollationDescr($current_collation) . '"' . ($default == $current_collation ? ' selected="selected"' : '') . '>' . $current_collation . '</option>' . "\n";
             }
             $return_str .= $spacer . '    </optgroup>' . "\n";
         } else {
             $return_str .= $spacer . '    <option value="' . $current_charset . '" title="' . $current_cs_descr . '"' . ($default == $current_charset ? ' selected="selected"' : '') . '>' . $current_charset . '</option>' . "\n";
         }
     }
     $return_str .= $spacer . '</select>' . "\n";
     return $return_str;
 }

/**
 * Generate charset dropdown box
 *
 * @param int         $type           Type
 * @param string      $name           Element name
 * @param string      $id             Element id
 * @param null|string $default        Default value
 * @param bool        $label          Label
 * @param bool        $submitOnChange Submit on change
 *
 * @return string
 */
function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION, $name = null, $id = null, $default = null, $label = true, $submitOnChange = false)
{
    global $mysql_charsets, $mysql_charsets_descriptions, $mysql_charsets_available, $mysql_collations, $mysql_collations_available;
    if (empty($name)) {
        if ($type == PMA_CSDROPDOWN_COLLATION) {
            $name = 'collation';
        } else {
            $name = 'character_set';
        }
    }
    $return_str = '<select lang="en" dir="ltr" name="' . htmlspecialchars($name) . '"' . (empty($id) ? '' : ' id="' . htmlspecialchars($id) . '"') . ($submitOnChange ? ' class="autosubmit"' : '') . '>' . "\n";
    if ($label) {
        $return_str .= '<option value="">' . ($type == PMA_CSDROPDOWN_COLLATION ? __('Collation') : __('Charset')) . '</option>' . "\n";
    }
    $return_str .= '<option value=""></option>' . "\n";
    foreach ($mysql_charsets as $current_charset) {
        if (!$mysql_charsets_available[$current_charset]) {
            continue;
        }
        $current_cs_descr = empty($mysql_charsets_descriptions[$current_charset]) ? $current_charset : $mysql_charsets_descriptions[$current_charset];
        if ($type == PMA_CSDROPDOWN_COLLATION) {
            $return_str .= '<optgroup label="' . $current_charset . '" title="' . $current_cs_descr . '">' . "\n";
            foreach ($mysql_collations[$current_charset] as $current_collation) {
                if (!$mysql_collations_available[$current_collation]) {
                    continue;
                }
                $return_str .= '<option value="' . $current_collation . '" title="' . PMA_getCollationDescr($current_collation) . '"' . ($default == $current_collation ? ' selected="selected"' : '') . '>' . $current_collation . '</option>' . "\n";
            }
            $return_str .= '</optgroup>' . "\n";
        } else {
            $return_str .= '<option value="' . $current_charset . '" title="' . $current_cs_descr . '"' . ($default == $current_charset ? ' selected="selected"' : '') . '>' . $current_charset . '</option>' . "\n";
        }
    }
    $return_str .= '</select>' . "\n";
    return $return_str;
}

/**
 * Get HTML snippet for display Row statistics table
 *
 * @param array   $showtable     show table array
 * @param string  $tbl_collation table collation
 * @param boolean $is_innodb     whether table is innob or not
 * @param boolean $mergetable    Checks if current table is a merge table
 * @param integer $avg_size      average size
 * @param string  $avg_unit      average unit
 *
 * @return string $html_output
 */
function getHtmlForRowStatsTable($showtable, $tbl_collation, $is_innodb, $mergetable, $avg_size, $avg_unit)
{
    $odd_row = false;
    $html_output = '<table id="tablerowstats" class="data">';
    $html_output .= '<caption class="tblHeaders">' . __('Row statistics') . '</caption>';
    $html_output .= '<tbody>';
    if (isset($showtable['Row_format'])) {
        if ($showtable['Row_format'] == 'Fixed') {
            $value = __('static');
        } elseif ($showtable['Row_format'] == 'Dynamic') {
            $value = __('dynamic');
        } else {
            $value = $showtable['Row_format'];
        }
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Format'), $value);
        $odd_row = !$odd_row;
    }
    if (!empty($showtable['Create_options'])) {
        if ($showtable['Create_options'] == 'partitioned') {
            $value = __('partitioned');
        } else {
            $value = $showtable['Create_options'];
        }
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Options'), $value);
        $odd_row = !$odd_row;
    }
    if (!empty($tbl_collation)) {
        $value = '<dfn title="' . PMA_getCollationDescr($tbl_collation) . '">' . $tbl_collation . '</dfn>';
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Collation'), $value);
        $odd_row = !$odd_row;
    }
    if (!$is_innodb && isset($showtable['Rows'])) {
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Rows'), PMA_Util::formatNumber($showtable['Rows'], 0));
        $odd_row = !$odd_row;
    }
    if (!$is_innodb && isset($showtable['Avg_row_length']) && $showtable['Avg_row_length'] > 0) {
        list($avg_row_length_value, $avg_row_length_unit) = PMA_Util::formatByteDown($showtable['Avg_row_length'], 6, 1);
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Row length'), $avg_row_length_value . ' ' . $avg_row_length_unit);
        unset($avg_row_length_value, $avg_row_length_unit);
        $odd_row = !$odd_row;
    }
    if (!$is_innodb && isset($showtable['Data_length']) && $showtable['Rows'] > 0 && $mergetable == false) {
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Row size'), $avg_size . ' ' . $avg_unit);
        $odd_row = !$odd_row;
    }
    if (isset($showtable['Auto_increment'])) {
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Next autoindex'), PMA_Util::formatNumber($showtable['Auto_increment'], 0));
        $odd_row = !$odd_row;
    }
    if (isset($showtable['Create_time'])) {
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Creation'), PMA_Util::localisedDate(strtotime($showtable['Create_time'])));
        $odd_row = !$odd_row;
    }
    if (isset($showtable['Update_time'])) {
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Last update'), PMA_Util::localisedDate(strtotime($showtable['Update_time'])));
        $odd_row = !$odd_row;
    }
    if (isset($showtable['Check_time'])) {
        $html_output .= PMA_getHtmlForRowStatsTableRow($odd_row, __('Last check'), PMA_Util::localisedDate(strtotime($showtable['Check_time'])));
    }
    $html_output .= '</tbody>' . '</table>';
    return $html_output;
}

         unset($truename);
     }
     $new_table_string .= '</th>' . "\n";
     $new_table_string .= '<td>' . $titles['NoBrowse'] . '</td>' . "\n";
     $new_table_string .= '<td><a href="tbl_structure.php' . PMA_generate_common_url($tbl_url_params) . '">' . $titles['Structure'] . '</a></td>' . "\n";
     $new_table_string .= '<td>' . $titles['NoSearch'] . '</td>' . "\n";
     $new_table_string .= '<td><a href="tbl_change.php' . PMA_generate_common_url($tbl_url_params) . '">' . $titles['Insert'] . '</a></td>' . "\n";
     $new_table_string .= '<td>' . $titles['NoEmpty'] . '</td>' . "\n";
     $new_table_string .= '<td><a class="drop_table_anchor" href="sql.php' . PMA_generate_common_url($tbl_url_params) . '&amp;sql_query=';
     $new_table_string .= urlencode('DROP TABLE ' . PMA_backquote($table));
     $new_table_string .= '">';
     $new_table_string .= $titles['Drop'];
     $new_table_string .= '</a></td>' . "\n";
     $new_table_string .= '<td class="value">' . $tbl_stats['Rows'] . '</td>' . "\n";
     $new_table_string .= '<td nowrap="nowrap">' . $tbl_stats['Engine'] . '</td>' . "\n";
     $new_table_string .= '<td> <dfn title="' . PMA_getCollationDescr($tbl_stats['Collation']) . '">' . $tbl_stats['Collation'] . '</dfn></td>' . "\n";
     if ($is_show_stats) {
         $new_table_string .= '<td class="value"> <a href="tbl_structure.php' . PMA_generate_common_url($tbl_url_params) . '#showusage" >' . $formatted_size . ' ' . $unit . '</a> </td>' . "\n";
         $new_table_string .= '<td class="value">' . $overhead . '</td>' . "\n";
     }
     $new_table_string .= '</tr>' . "\n";
     $extra_data['new_table_string'] = $new_table_string;
     PMA_ajaxResponse($message, $message->isSuccess(), $extra_data);
 }
 $display_query = $sql_query;
 $sql_query = '';
 // read table info on this newly created table, in case
 // the next page is Structure
 $reread_info = true;
 require './libraries/tbl_info.inc.php';
 // do not switch to sql.php - as there is no row to be displayed on a new table

 */
if (PMA_MYSQL_INT_VERSION < 40100) {
    require_once './libs/footer.inc.php';
}
/**
 * Includes the required charset library
 */
require_once './libs/mysql_charsets.lib.php';
/**
 * Outputs the result
 */
echo '<div id="div_mysql_charset_collations">' . "\n" . '<table class="data">' . "\n" . '<tr><th>' . $strCollation . '</th>' . "\n" . '    <th>' . $strDescription . '</th>' . "\n" . '</tr>' . "\n";
$i = 0;
$table_row_count = count($mysql_charsets) + $mysql_collations_count;
foreach ($mysql_charsets as $current_charset) {
    if ($i >= $table_row_count / 2) {
        $i = 0;
        echo '</table>' . "\n" . '<table class="data">' . "\n" . '<tr><th>' . $strCollation . '</th>' . "\n" . '    <th>' . $strDescription . '</th>' . "\n" . '</tr>' . "\n";
    }
    $i++;
    echo '<tr><th colspan="2" align="right">' . "\n" . '        ' . htmlspecialchars($current_charset) . "\n" . (empty($mysql_charsets_descriptions[$current_charset]) ? '' : '        (<i>' . htmlspecialchars($mysql_charsets_descriptions[$current_charset]) . '</i>)' . "\n") . '    </th>' . "\n" . '</tr>' . "\n";
    $odd_row = true;
    foreach ($mysql_collations[$current_charset] as $current_collation) {
        $i++;
        echo '<tr class="' . ($odd_row ? 'odd' : 'even') . ($mysql_default_collations[$current_charset] == $current_collation ? ' marked' : '') . ($mysql_collations_available[$current_collation] ? '' : ' disabled') . '">' . "\n" . '    <td>' . htmlspecialchars($current_collation) . '</td>' . "\n" . '    <td>' . PMA_getCollationDescr($current_collation) . '</td>' . "\n" . '</tr>' . "\n";
        $odd_row = !$odd_row;
    }
}
unset($table_row_count);
echo '</table>' . "\n" . '</div>' . "\n";
require_once './libs/footer.inc.php';

                . PMA_generate_common_url($tbl_url_params) . '&sql_query='
                . urlencode('DROP TABLE ' . PMA_Util::backquote($table)) . '">'
                . $titles['Drop']
                . '</a>'
                . '</td>' . "\n";

            $new_table_string .= '<td class="value">'
                . $tbl_stats['Rows']
                . '</td>' . "\n";

            $new_table_string .= '<td class="nowrap">'
                . $tbl_stats['Engine']
                . '</td>' . "\n";

            $new_table_string .= '<td>'
                . '<dfn title="' . PMA_getCollationDescr($tbl_stats['Collation']) . '">'
                . $tbl_stats['Collation']
                .'</dfn>'
                . '</td>' . "\n";

            if ($is_show_stats) {
                $new_table_string .= '<td class="value tbl_size">'
                    . '<a href="tbl_structure.php'
                    . PMA_generate_common_url($tbl_url_params) . '#showusage" >'
                    . '<span>' . $formatted_size . '</span>'
                    . '<span class="unit">' . $unit . '</span>'
                    . '</a>'
                    . '</td>' . "\n" ;

                $new_table_string .= '<td class="value tbl_overhead">'
                    . $overhead

        <?php 
echo __('Sum');
?>
</th>
    <th class="value tbl_rows"><?php 
echo $sum_row_count_pre . PMA_formatNumber($sum_entries, 0);
?>
</th>
<?php 
if (!($cfg['PropertiesNumColumns'] > 1)) {
    $default_engine = PMA_DBI_get_default_engine();
    echo '    <th align="center">' . "\n" . '        <dfn title="' . sprintf(__('%s is the default storage engine on this MySQL server.'), $default_engine) . '">' . $default_engine . '</dfn></th>' . "\n";
    // we got a case where $db_collation was empty
    echo '    <th align="center">' . "\n";
    if (!empty($db_collation)) {
        echo '        <dfn title="' . PMA_getCollationDescr($db_collation) . ' (' . __('Default') . ')">' . $db_collation . '</dfn>';
    }
    echo '</th>';
}
if ($is_show_stats) {
    ?>
    <th class="value tbl_size"><?php 
    echo $sum_formatted . ' ' . $unit;
    ?>
</th>
    <th class="value"><?php 
    echo $overhead_formatted . ' ' . $overhead_unit;
    ?>
</th>
    <?php 
}

foreach ($tables as $keyname => $current_table) {
    // Get valid statistics whatever is the table type
    $drop_query = '';
    $drop_message = '';
    $overhead = '';
    $table_is_view = false;
    $table_encoded = urlencode($current_table['TABLE_NAME']);
    // Sets parameters for links
    $tbl_url_query = $url_query . '&table=' . $table_encoded;
    // do not list the previous table's size info for a view
    list($current_table, $formatted_size, $unit, $formatted_overhead, $overhead_unit, $overhead_size, $table_is_view, $sum_size) = PMA_getStuffForEngineTypeTable($current_table, $db_is_information_schema, $is_show_stats, $table_is_view, $sum_size, $overhead_size);
    if (!PMA_Table::isMerge($db, $current_table['TABLE_NAME'])) {
        $sum_entries += $current_table['TABLE_ROWS'];
    }
    if (isset($current_table['Collation'])) {
        $collation = '<dfn title="' . PMA_getCollationDescr($current_table['Collation']) . '">' . $current_table['Collation'] . '</dfn>';
    } else {
        $collation = '---';
    }
    if ($is_show_stats) {
        if ($formatted_overhead != '') {
            $overhead = '<a href="tbl_structure.php?' . $tbl_url_query . '#showusage">' . '<span>' . $formatted_overhead . '</span>' . '<span class="unit">' . $overhead_unit . '</span>' . '</a>' . "\n";
            $overhead_check .= "markAllRows('row_tbl_" . ($i + 1) . "');";
        } else {
            $overhead = '-';
        }
    }
    // end if
    unset($showtable);
    if ($GLOBALS['cfg']['ShowDbStructureCreation']) {
        list($create_time, $create_time_all) = PMA_getTimeForCreateUpdateCheck($current_table, 'Create_time', $create_time_all);

 /**
  * Test case for PMA_getCollationDescr()
  *
  * @param string $collation Collation for which description is reqd
  * @param string $desc      Expected Description
  *
  * @return void
  * @test
  * @dataProvider collationDescr
  */
 public function testGetCollationDescr($collation, $desc)
 {
     $this->assertEquals($desc, PMA_getCollationDescr($collation));
 }

if (PMA_MYSQL_INT_VERSION < 40100) {
    // TODO: Some nice Message :-)
    require_once './footer.inc.php';
}
/**
 * Includes the required charset library
 */
require_once './libraries/mysql_charsets.lib.php';
/**
 * Outputs the result
 */
echo '<table border="0">' . "\n" . '    <tr>' . "\n" . '        <td valign="top">' . "\n" . '            <table border="0" cellpadding="2" cellspacing="1">' . "\n" . '                <tr>' . "\n" . '                <th>' . "\n" . '                    ' . $strCollation . "\n" . '                </th>' . "\n" . '                <th>' . "\n" . '                    ' . $strDescription . "\n" . '                </th>' . "\n" . '            </tr>' . "\n";
$i = 0;
$table_row_count = count($mysql_charsets) + $mysql_collations_count;
foreach ($mysql_charsets as $current_charset) {
    if ($i >= $table_row_count / 2) {
        $i = 0;
        echo '            </table>' . "\n" . '        </td>' . "\n" . '        <td valign="top">' . "\n" . '            <table border="0" cellpadding="2" cellspacing="1">' . "\n" . '                <tr>' . "\n" . '                <th>' . "\n" . '                    ' . $strCollation . "\n" . '                </th>' . "\n" . '                <th>' . "\n" . '                    ' . $strDescription . "\n" . '                </th>' . "\n" . '            </tr>' . "\n";
    }
    $i++;
    echo '            <tr>' . "\n" . '                <td colspan="2" bgcolor="' . $cfg['ThBgcolor'] . '" align="right">' . "\n" . '                    &nbsp;<b>' . htmlspecialchars($current_charset) . '</b>' . "\n" . (empty($mysql_charsets_descriptions[$current_charset]) ? '' : '                    (<i>' . htmlspecialchars($mysql_charsets_descriptions[$current_charset]) . '</i>)&nbsp;' . "\n") . '                </td>' . "\n" . '            </tr>' . "\n";
    $useBgcolorOne = TRUE;
    foreach ($mysql_collations[$current_charset] as $current_collation) {
        $i++;
        echo '            <tr>' . "\n" . '                <td bgcolor="' . ($mysql_default_collations[$current_charset] == $current_collation ? $cfg['BrowseMarkerColor'] : ($useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo'])) . '">' . "\n" . '                    &nbsp;' . htmlspecialchars($current_collation) . '&nbsp;' . "\n" . '                </td>' . "\n" . '                <td bgcolor="' . ($useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']) . '">' . "\n" . '                    &nbsp;' . PMA_getCollationDescr($current_collation) . '&nbsp;' . "\n" . '                </td>' . "\n" . '            </tr>' . "\n";
        $useBgcolorOne = !$useBgcolorOne;
    }
}
unset($table_row_count);
echo '            </table>' . "\n" . '        </td>' . "\n" . '    </tr>' . "\n" . '</table>' . "\n";
require_once './footer.inc.php';

                    <b><?php 
    echo $strSum;
    ?>
</b>
                </th>
                <th align="right" nowrap="nowrap">
                    <b><?php 
    echo number_format($sum_entries, 0, $number_decimal_separator, $number_thousands_separator);
    ?>
</b>
                </th>
    <?php 
    if (!($cfg['PropertiesNumColumns'] > 1)) {
        echo '                <th align="center">' . "\n" . '                    <b>--</b>' . "\n" . '                </th>' . "\n";
        if (PMA_MYSQL_INT_VERSION >= 40101) {
            echo '                <th align="center">' . "\n" . '                    &nbsp;<b><dfn title="' . PMA_getCollationDescr($db_collation) . '">' . $db_collation . '</dfn></b>&nbsp;' . "\n" . '                </th>' . "\n";
        }
    }
    if ($cfg['ShowStats']) {
        echo "\n";
        ?>
                <th align="right" nowrap="nowrap">
                    &nbsp;
                    <b><?php 
        echo $sum_formated . ' ' . $unit;
        ?>
</b>
                </th>
                <th align="right" nowrap="nowrap">
                    &nbsp;
                    <b><?php 

        ?>
    </th>
    <th colspan="<?php echo ($db_is_information_schema ? 3 : 6) ?>" align="center">
        <?php echo $strSum; ?></th>
    <th class="value"><?php echo $sum_row_count_pre . PMA_formatNumber($sum_entries, 0); ?></th>
<?php
if (!($cfg['PropertiesNumColumns'] > 1)) {
    $default_engine = PMA_DBI_get_default_engine();
    echo '    <th align="center">' . "\n"
       . '        <dfn title="'
       . sprintf($strDefaultEngine, $default_engine) . '">' .$default_engine . '</dfn></th>' . "\n";
    // we got a case where $db_collation was empty
    echo '    <th align="center">' . "\n";
    if (! empty($db_collation)) {
        echo '        <dfn title="'
            . PMA_getCollationDescr($db_collation) . ' (' . $strDefault . ')">' . $db_collation
            . '</dfn>';
    }
    echo '</th>';
}

if ($is_show_stats) {
    ?>
    <th class="value"><?php echo $sum_formatted . ' ' . $unit; ?></th>
    <th class="value"><?php echo $overhead_formatted . ' ' . $overhead_unit; ?></th>
    <?php
}
?>
</tr>
</tbody>
</table>

       . (empty($mysql_charsets_descriptions[$current_charset])
            ? ''
            : '        (<i>' . htmlspecialchars(
                $mysql_charsets_descriptions[$current_charset]
            ) . '</i>)' . "\n")
       . '    </th>' . "\n"
       . '</tr>' . "\n";
    $odd_row = true;
    foreach ($mysql_collations[$current_charset] as $current_collation) {
        $i++;
        echo '<tr class="'
           . ($odd_row ? 'odd' : 'even')
           . ($mysql_default_collations[$current_charset] == $current_collation
                ? ' marked'
                : '')
           . ($mysql_collations_available[$current_collation] ? '' : ' disabled')
           . '">' . "\n"
           . '    <td>' . htmlspecialchars($current_collation) . '</td>' . "\n"
           . '    <td>' . PMA_getCollationDescr($current_collation) . '</td>' . "\n"
           . '</tr>' . "\n";
        $odd_row = !$odd_row;
    }
}
unset($table_row_count);
echo '</table>' . "\n"
   . '</div>' . "\n";

require 'libraries/footer.inc.php';

?>

</td>
    </tr>
        <?php 
    }
    if (!empty($tbl_collation)) {
        ?>
    <tr class="<?php 
        echo ($odd_row = !$odd_row) ? 'odd' : 'even';
        ?>
">
        <th class="name"><?php 
        echo $strCollation;
        ?>
</th>
        <td class="value"><?php 
        echo '<dfn title="' . PMA_getCollationDescr($tbl_collation) . '">' . $tbl_collation . '</dfn>';
        ?>
</td>
    </tr>
        <?php 
    }
    if (!$is_innodb && isset($showtable['Rows'])) {
        ?>
    <tr class="<?php 
        echo ($odd_row = !$odd_row) ? 'odd' : 'even';
        ?>
">
        <th class="name"><?php 
        echo $strRows;
        ?>
</th>