server_collations.php

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