server_collations.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7
   8 /**
   9  * requirements
  10  */
  11 require_once 'libraries/common.inc.php';
  12
  13 /**
  14  * Does the common work
  15  */
  16 require 'libraries/server_common.inc.php';
  17
  18
  19 /**
  20  * Displays the links
  21  */
  22 require 'libraries/server_links.inc.php';
  23
  24
  25 /**
  26  * Displays the sub-page heading
  27  */
  28 echo '<h2>' . "\n"
  29    . '    ' .  PMA_getImage('s_asci.png')
  30    . '' . __('Character Sets and Collations') . "\n"
  31    . '</h2>' . "\n";
  32
  33 /**
  34  * Includes the required charset library
  35  */
  36 require_once 'libraries/mysql_charsets.lib.php';
  37
  38
  39 /**
  40  * Outputs the result
  41  */
  42 echo '<div id="div_mysql_charset_collations">' . "\n"
  43    . '<table class="data noclick">' . "\n"
  44    . '<tr><th>' . __('Collation') . '</th>' . "\n"
  45    . '    <th>' . __('Description') . '</th>' . "\n"
  46    . '</tr>' . "\n";
  47
  48 $i = 0;
  49 $table_row_count = count($mysql_charsets) + count($mysql_collations);
  50
  51 foreach ($mysql_charsets as $current_charset) {
  52     if ($i >= $table_row_count / 2) {
  53         $i = 0;
  54         echo '</table>' . "\n"
  55            . '<table class="data noclick">' . "\n"
  56            . '<tr><th>' . __('Collation') . '</th>' . "\n"
  57            . '    <th>' . __('Description') . '</th>' . "\n"
  58            . '</tr>' . "\n";
  59     }
  60     $i++;
  61     echo '<tr><th colspan="2" class="right">' . "\n"
  62        . '        ' . htmlspecialchars($current_charset) . "\n"
  63        . (empty($mysql_charsets_descriptions[$current_charset])
  64             ? ''
  65             : '        (<i>' . htmlspecialchars(
  66                 $mysql_charsets_descriptions[$current_charset]
  67             ) . '</i>)' . "\n")
  68        . '    </th>' . "\n"
  69        . '</tr>' . "\n";
  70     $odd_row = true;
  71     foreach ($mysql_collations[$current_charset] as $current_collation) {
  72         $i++;
  73         echo '<tr class="'
  74            . ($odd_row ? 'odd' : 'even')
  75            . ($mysql_default_collations[$current_charset] == $current_collation
  76                 ? ' marked'
  77                 : '')
  78            . ($mysql_collations_available[$current_collation] ? '' : ' disabled')
  79            . '">' . "\n"
  80            . '    <td>' . htmlspecialchars($current_collation) . '</td>' . "\n"
  81            . '    <td>' . PMA_getCollationDescr($current_collation) . '</td>' . "\n"
  82            . '</tr>' . "\n";
  83         $odd_row = !$odd_row;
  84     }
  85 }
  86 unset($table_row_count);
  87 echo '</table>' . "\n"
  88    . '</div>' . "\n";
  89
  90 require 'libraries/footer.inc.php';
  91
  92 ?>