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    . '</h2>' . "\n";
  36
  37
  38 /**
  39  * Sends the queries and buffers the results
  40  */
  41 $serverVars = PMA_DBI_fetch_result('SHOW SESSION VARIABLES;', 0, 1);
  42 $serverVarsGlobal = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES;', 0, 1);
  43
  44
  45 /**
  46  * Displays the page
  47  */
  48 ?>
  49 <table class="data">
  50 <thead>
  51 <tr><th><?php echo __('Variable'); ?></th>
  52     <th>
  53 <?php
  54 echo __('Session value') . ' / ' . __('Global value');
  55 ?>
  56     </th>
  57 </tr>
  58 </thead>
  59 <tbody>
  60 <?php
  61 $odd_row = true;
  62 foreach ($serverVars as $name => $value) {
  63     ?>
  64 <tr class="<?php
  65     echo $odd_row ? 'odd' : 'even';
  66     if ($serverVarsGlobal[$name] !== $value) {
  67         echo ' marked';
  68     }
  69     ?>">
  70     <th nowrap="nowrap">
  71         <?php echo htmlspecialchars(str_replace('_', ' ', $name)); ?></th>
  72     <td class="value"><?php
  73     if (strlen($value) < 16 && is_numeric($value)) {
  74         echo PMA_formatNumber($value, 0);
  75         $is_numeric = true;
  76     } else {
  77         echo htmlspecialchars($value);
  78         $is_numeric = false;
  79     }
  80     ?></td>
  81     <?php
  82     if ($serverVarsGlobal[$name] !== $value) {
  83         ?>
  84 </tr>
  85 <tr class="<?php
  86     echo $odd_row ? 'odd' : 'even';
  87     ?> marked">
  88     <td>(<?php echo __('Global value'); ?>)</td>
  89     <td class="value"><?php
  90     if ($is_numeric) {
  91         echo PMA_formatNumber($serverVarsGlobal[$name], 0);
  92     } else {
  93         echo htmlspecialchars($serverVarsGlobal[$name]);
  94     }
  95     ?></td>
  96     <?php } ?>
  97 </tr>
  98     <?php
  99     $odd_row = !$odd_row;
 100 }
 101 ?>
 102 </tbody>
 103 </table>
 104 <?php
 105
 106
 107 /**
 108  * Sends the footer
 109  */
 110 require './libraries/footer.inc.php';
 111
 112 ?>