Viewing file:  server_variables.php (2.58 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/* $Id: server_variables.php,v 2.2 2003/11/26 22:52:24 rabus Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* Does the common work
*/
require('./server_common.inc.php');
/**
* Displays the links
*/
require('./server_links.inc.php');
/**
* Displays the sub-page heading
*/
echo '<h2>' . "\n"
. ' ' . $strServerVars . "\n"
. '</h2>' . "\n";
/**
* Checks if the user is allowed to do what he tries to...
*/
if (!$is_superuser && !$cfg['ShowMysqlVars']) {
echo $strNoPrivileges;
require_once('./footer.inc.php');
}
/**
* Sends the queries and buffers the results
*/
if (PMA_MYSQL_INT_VERSION >= 40003) {
$res = @PMA_mysql_query('SHOW SESSION VARIABLES;', $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), 'SHOW SESSION VARIABLES;');
while ($row = PMA_mysql_fetch_row($res)) {
$serverVars[$row[0]] = $row[1];
}
@mysql_free_result($res);
$res = @PMA_mysql_query('SHOW GLOBAL VARIABLES;', $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), 'SHOW GLOBAL VARIABLES;');
while ($row = PMA_mysql_fetch_row($res)) {
$serverVarsGlobal[$row[0]] = $row[1];
}
@mysql_free_result($res);
} else {
$res = @PMA_mysql_query('SHOW VARIABLES;', $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), 'SHOW VARIABLES;');
while ($row = PMA_mysql_fetch_row($res)) {
$serverVars[$row[0]] = $row[1];
}
@mysql_free_result($res);
}
unset($res);
unset($row);
/**
* Displays the page
*/
?>
<table border="0">
<tr>
<th> <?php echo $strVar; ?> </th>
<?php
echo ' <th> ';
if (PMA_MYSQL_INT_VERSION >= 40003) {
echo $strSessionValue . ' </th>' . "\n"
. ' <th> ' . $strGlobalValue;
} else {
echo $strValue;
}
echo ' </th>' . "\n";
?>
</tr>
<?php
$useBgcolorOne = TRUE;
foreach ($serverVars as $name => $value) {
?>
<tr>
<td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>">
<?php echo htmlspecialchars(str_replace('_', ' ', $name)) . "\n"; ?>
</td>
<td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>">
<?php echo htmlspecialchars($value) . "\n"; ?>
</td>
<?php
if (PMA_MYSQL_INT_VERSION >= 40003) {
?>
<td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>">
<?php echo htmlspecialchars($serverVarsGlobal[$name]) . "\n"; ?>
</td>
<?php
}
$useBgcolorOne = !$useBgcolorOne;
?>
</tr>
<?php
}
?>
</table>
<?php
/**
* Sends the footer
*/
require_once('./footer.inc.php');
?>
|