server_variables.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 require_once './libraries/common.inc.php';
  16
  17 /**
  18  * Does the common work
  19  */
  20 require './libraries/server_common.inc.php';
  21
  22
  23 /**
  24  * Displays the links
  25  */
  26 require './libraries/server_links.inc.php';
  27
  28
  29 /**
  30  * Displays the sub-page heading
  31  */
  32 echo '<h2>' . "\n"
  33    . ($cfg['MainPageIconic'] ? '<img class="icon" src="' . $pmaThemeImage . 's_vars.png" width="16" height="16" alt="" />' : '')
  34    . '' . __('Server variables and settings') . "\n"
  35    . PMA_showMySQLDocu('server_system_variables','server_system_variables')
  36    . '</h2>' . "\n";
  37
  38
  39 /**
  40  * Sends the queries and buffers the results
  41  */
  42 $serverVars = PMA_DBI_fetch_result('SHOW SESSION VARIABLES;', 0, 1);
  43 $serverVarsGlobal = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES;', 0, 1);
  44
  45
  46 /**
  47  * Displays the page
  48  */
  49 ?>
  50 <table class="data">
  51 <thead>
  52 <tr><th><?php echo __('Variable'); ?></th>
  53     <th>
  54 <?php
  55 echo __('Session value') . ' / ' . __('Global value');
  56 ?>
  57     </th>
  58 </tr>
  59 </thead>
  60 <tbody>
  61 <?php
  62 $odd_row = true;
  63 foreach ($serverVars as $name => $value) {
  64     ?>
  65 <tr class="<?php
  66     echo $odd_row ? 'odd' : 'even';
  67     if ($serverVarsGlobal[$name] !== $value) {
  68         echo ' marked';
  69     }
  70     ?>">
  71     <th nowrap="nowrap">
  72         <?php echo htmlspecialchars(str_replace('_', ' ', $name)); ?></th>
  73     <td class="value"><?php
  74     if (strlen($value) < 16 && is_numeric($value)) {
  75         echo PMA_formatNumber($value, 0);
  76         $is_numeric = true;
  77     } else {
  78         echo htmlspecialchars($value);
  79         $is_numeric = false;
  80     }
  81     ?></td>
  82     <?php
  83     if ($serverVarsGlobal[$name] !== $value) {
  84         ?>
  85 </tr>
  86 <tr class="<?php
  87     echo $odd_row ? 'odd' : 'even';
  88     ?> marked">
  89     <td>(<?php echo __('Global value'); ?>)</td>
  90     <td class="value"><?php
  91     if ($is_numeric) {
  92         echo PMA_formatNumber($serverVarsGlobal[$name], 0);
  93     } else {
  94         echo htmlspecialchars($serverVarsGlobal[$name]);
  95     }
  96     ?></td>
  97     <?php } ?>
  98 </tr>
  99     <?php
 100     $odd_row = !$odd_row;
 101 }
 102 ?>
 103 </tbody>
 104 </table>
 105 <?php
 106
 107
 108 /**
 109  * Sends the footer
 110  */
 111 require './libraries/footer.inc.php';
 112
 113 ?>