libraries/server_collations.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3
   4 /**
   5  * functions for displaying server Character Sets and Collations
   6  *
   7  * @usedby  server_collations.php
   8  *
   9  * @package PhpMyAdmin
  10  */
  11 if (! defined('PHPMYADMIN')) {
  12     exit;
  13 }
  14
  15 /**
  16  * Returns the html for server Character Sets and Collations.
  17  *
  18  * @param Array $mysql_charsets              Mysql Charsets list
  19  * @param Array $mysql_collations            Mysql Collations list
  20  * @param Array $mysql_charsets_descriptions Charsets descriptions
  21  * @param Array $mysql_default_collations    Default Collations list
  22  * @param Array $mysql_collations_available  Available Collations list
  23  *
  24  * @return string
  25  */
  26 function PMA_getHtmlForCharsets($mysql_charsets, $mysql_collations,
  27     $mysql_charsets_descriptions, $mysql_default_collations,
  28     $mysql_collations_available
  29 ) {
  30     /**
  31      * Outputs the result
  32      */
  33     $html = '<div id="div_mysql_charset_collations">' . "\n"
  34         . '<table class="data noclick">' . "\n"
  35         . '<tr><th>' . __('Collation') . '</th>' . "\n"
  36         . '    <th>' . __('Description') . '</th>' . "\n"
  37         . '</tr>' . "\n";
  38
  39     $i = 0;
  40     $table_row_count = count($mysql_charsets) + count($mysql_collations);
  41
  42     foreach ($mysql_charsets as $current_charset) {
  43         if ($i >= $table_row_count / 2) {
  44             $i = 0;
  45             $html .= '</table>' . "\n"
  46                 . '<table class="data noclick">' . "\n"
  47                 . '<tr><th>' . __('Collation') . '</th>' . "\n"
  48                 . '    <th>' . __('Description') . '</th>' . "\n"
  49                 . '</tr>' . "\n";
  50         }
  51         $i++;
  52         $html .= '<tr><th colspan="2" class="right">' . "\n"
  53             . '        ' . htmlspecialchars($current_charset) . "\n"
  54             . (empty($mysql_charsets_descriptions[$current_charset])
  55                 ? ''
  56                 : '        (<i>' . htmlspecialchars(
  57                     $mysql_charsets_descriptions[$current_charset]
  58                 ) . '</i>)' . "\n")
  59             . '    </th>' . "\n"
  60             . '</tr>' . "\n";
  61
  62         $html .= PMA_getHtmlForCollationCurrentCharset(
  63             $current_charset,
  64             $mysql_collations,
  65             $i,
  66             $mysql_default_collations,
  67             $mysql_collations_available
  68         );
  69     }
  70     unset($table_row_count);
  71     $html .= '</table>' . "\n"
  72         . '</div>' . "\n";
  73
  74     return $html;
  75 }
  76
  77 /**
  78  * Returns the html for Collations of Current Charset.
  79  *
  80  * @param String $current_charset            Current Charset
  81  * @param Array  $mysql_collations           Collations list
  82  * @param int    &$i                         Display Index
  83  * @param Array  $mysql_default_collations   Default Collations list
  84  * @param Array  $mysql_collations_available Available Collations list
  85  *
  86  * @return string
  87  */
  88 function PMA_getHtmlForCollationCurrentCharset(
  89     $current_charset, $mysql_collations, &$i,
  90     $mysql_default_collations, $mysql_collations_available
  91 ) {
  92     $odd_row = true;
  93     $html = '';
  94     foreach ($mysql_collations[$current_charset] as $current_collation) {
  95         $i++;
  96         $html .= '<tr class="'
  97             . ($odd_row ? 'odd' : 'even')
  98             . ($mysql_default_collations[$current_charset] == $current_collation
  99                 ? ' marked'
 100                 : '')
 101             . ($mysql_collations_available[$current_collation] ? '' : ' disabled')
 102             . '">' . "\n"
 103             . '    <td>' . htmlspecialchars($current_collation) . '</td>' . "\n"
 104             . '    <td>' . PMA_getCollationDescr($current_collation) . '</td>' . "\n"
 105             . '</tr>' . "\n";
 106         $odd_row = !$odd_row;
 107     }
 108     return $html;
 109 }
 110 ?>