Viewing file:  server_variables.php (2.39 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/* $Id: server_variables.php,v 2.13 2005/12/07 12:57:07 cybot_tm Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
if ( ! defined( 'PMA_NO_VARIABLES_IMPORT' ) ) {
define( 'PMA_NO_VARIABLES_IMPORT', true );
}
require_once('./libraries/common.lib.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"
. ($cfg['MainPageIconic'] ? '<img class="icon" src="' . $pmaThemeImage . 's_vars.png" width="16" height="16" alt="" />' : '' )
. '' . $strServerVars . "\n"
. '</h2>' . "\n";
/**
* Sends the queries and buffers the results
*/
if (PMA_MYSQL_INT_VERSION >= 40003) {
$serverVars = PMA_DBI_fetch_result('SHOW SESSION VARIABLES;', 0, 1);
$serverVarsGlobal = PMA_DBI_fetch_result('SHOW GLOBAL VARIABLES;', 0, 1);
} else {
$serverVars = PMA_DBI_fetch_result('SHOW VARIABLES;', 0, 1);
}
/**
* Displays the page
*/
?>
<table class="data">
<thead>
<tr><th><?php echo $strVar; ?></th>
<th>
<?php
if (PMA_MYSQL_INT_VERSION >= 40003) {
echo $strSessionValue . ' / ' . $strGlobalValue;
} else {
echo $strValue;
}
?>
</th>
</tr>
</thead>
<tbody>
<?php
$odd_row = true;
$useBgcolorOne = TRUE;
foreach ($serverVars as $name => $value) {
?>
<tr class="<?php
echo $odd_row ? 'odd' : 'even';
if (PMA_MYSQL_INT_VERSION >= 40003
&& $serverVarsGlobal[$name] !== $value ) {
echo ' marked';
}
?>">
<th nowrap="nowrap">
<?php echo htmlspecialchars(str_replace('_', ' ', $name)); ?></th>
<td class="value"><?php
if ( is_numeric($value) ) {
echo PMA_formatNumber($value, 0);
$is_numeric = true;
} else {
echo htmlspecialchars($value);
$is_numeric = false;
}
?></td>
<?php
if (PMA_MYSQL_INT_VERSION >= 40003
&& $serverVarsGlobal[$name] !== $value ) {
?>
</tr>
<tr class="<?php
echo $odd_row ? 'odd' : 'even';
?> marked">
<td>(<?php echo $strGlobalValue; ?>)</td>
<td class="value"><?php
if ( $is_numeric ) {
echo PMA_formatNumber($serverVarsGlobal[$name], 0);
} else {
echo htmlspecialchars($serverVarsGlobal[$name]);
}
?></td>
<?php } ?>
</tr>
<?php
$odd_row = !$odd_row;
}
?>
</tbody>
</table>
<?php
/**
* Sends the footer
*/
require_once('./libraries/footer.inc.php');
?>
|