Blame view

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