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 $serverVarsDetails = PMA_DBI_fetch_result('SELECT * from phpmyadmin.pma_server_variables;', 'var_name');
  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
  73         <?php
  74             $hasDetail=isset($serverVarsDetails[$name]);
  75             echo $hasDetail?
  76                 "<a target=\"_blank\" href=\"{$serverVarsDetails[$name]["var_link"]}\"title=\"{$serverVarsDetails[$name]["var_desc"]}\">":
  77                 "";
  78             echo htmlspecialchars(str_replace('_', ' ', $name));
  79             echo $hasDetail?"</a>":"";
  80         ?>
  81
  82     </th>
  83     <td class="value"><?php
  84     if (strlen($value) < 16 && is_numeric($value)) {
  85         echo PMA_formatNumber($value, 0);
  86         $is_numeric = true;
  87     } else {
  88         echo htmlspecialchars($value);
  89         $is_numeric = false;
  90     }
  91     ?></td>
  92     <?php
  93     if ($serverVarsGlobal[$name] !== $value) {
  94         ?>
  95 </tr>
  96 <tr class="<?php
  97     echo $odd_row ? 'odd' : 'even';
  98     ?> marked">
  99     <td>(<?php echo __('Global value'); ?>)</td>
 100     <td class="value"><?php
 101     if ($is_numeric) {
 102         echo PMA_formatNumber($serverVarsGlobal[$name], 0);
 103     } else {
 104         echo htmlspecialchars($serverVarsGlobal[$name]);
 105     }
 106     ?></td>
 107     <?php } ?>
 108 </tr>
 109     <?php
 110     $odd_row = !$odd_row;
 111 }
 112 ?>
 113 </tbody>
 114 </table>
 115 <script>
 116     $("table.data a[title]").qtip({ style: { name: 'cream', tip: true } });
 117 </script>
 118 <?php
 119
 120
 121 /**
 122  * Sends the footer
 123  */
 124 require './libraries/footer.inc.php';
 125
 126 ?>