BLUE

Edit File Size: 4.29 KB

/usr/share/phpmyadmin/libraries/classes/Controllers/Server/VariablesController.php

Text Base64

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Server;

use PhpMyAdmin\Controllers\AbstractController;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Html\Generator;
use PhpMyAdmin\Providers\ServerVariables\ServerVariablesProvider;
use PhpMyAdmin\ResponseRenderer;
use PhpMyAdmin\Template;
use PhpMyAdmin\Url;
use PhpMyAdmin\Util;

use function implode;
use function in_array;
use function is_numeric;
use function str_replace;
use function strtolower;
use function trim;

/**
 * Handles viewing and editing server variables
 */
class VariablesController extends AbstractController
{
    /** @var DatabaseInterface */
    private $dbi;

public function __construct(ResponseRenderer $response, Template $template, DatabaseInterface $dbi)
    {
        parent::__construct($response, $template);
        $this->dbi = $dbi;
    }

public function __invoke(): void
    {
        global $errorUrl;

$params = ['filter' => $_GET['filter'] ?? null];
        $errorUrl = Url::getFromRoute('/');

if ($this->dbi->isSuperUser()) {
            $this->dbi->selectDb('mysql');
        }

$filterValue = ! empty($params['filter']) ? $params['filter'] : '';

$this->addScriptFiles(['server/variables.js']);

$variables = [];
        $serverVarsResult = $this->dbi->tryQuery('SHOW SESSION VARIABLES;');
        if ($serverVarsResult !== false) {
            $serverVarsSession = $serverVarsResult->fetchAllKeyPair();

unset($serverVarsResult);

$serverVars = $this->dbi->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1);

// list of static (i.e. non-editable) system variables
            $staticVariables = ServerVariablesProvider::getImplementation()->getStaticVariables();

foreach ($serverVars as $name => $value) {
                $hasSessionValue = isset($serverVarsSession[$name])
                    && $serverVarsSession[$name] !== $value;
                $docLink = Generator::linkToVarDocumentation(
                    $name,
                    $this->dbi->isMariaDB(),
                    str_replace('_', '&nbsp;', $name)
                );

[$formattedValue, $isEscaped] = $this->formatVariable($name, $value);
                if ($hasSessionValue) {
                    [$sessionFormattedValue] = $this->formatVariable($name, $serverVarsSession[$name]);
                }

$variables[] = [
                    'name' => $name,
                    'is_editable' => ! in_array(strtolower($name), $staticVariables),
                    'doc_link' => $docLink,
                    'value' => $formattedValue,
                    'is_escaped' => $isEscaped,
                    'has_session_value' => $hasSessionValue,
                    'session_value' => $sessionFormattedValue ?? null,
                ];
            }
        }

$this->render('server/variables/index', [
            'variables' => $variables,
            'filter_value' => $filterValue,
            'is_superuser' => $this->dbi->isSuperUser(),
            'is_mariadb' => $this->dbi->isMariaDB(),
        ]);
    }

/**
     * Format Variable
     *
     * @param string     $name  variable name
     * @param int|string $value variable value
     *
     * @return array formatted string and bool if string is HTML formatted
     */
    private function formatVariable($name, $value): array
    {
        $isHtmlFormatted = false;
        $formattedValue = $value;

if (is_numeric($value)) {
            $variableType = ServerVariablesProvider::getImplementation()->getVariableType($name);

if ($variableType === 'byte') {
                $isHtmlFormatted = true;
                /** @var string[] $bytes */
                $bytes = Util::formatByteDown($value, 3, 3);
                $formattedValue = trim(
                    $this->template->render(
                        'server/variables/format_variable',
                        [
                            'valueTitle' => Util::formatNumber($value, 0),
                            'value' => implode(' ', $bytes),
                        ]
                    )
                );
            } else {
                $formattedValue = Util::formatNumber($value, 0);
            }
        }

return [
            $formattedValue,
            $isHtmlFormatted,
        ];
    }
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
Databases DIR	-	drwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
Privileges DIR	-	drwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
Status DIR	-	drwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
Variables DIR	-	drwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
BinlogController.php	3.64 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
CollationsController.php	2.22 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
DatabasesController.php	10.96 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
EnginesController.php	955 B	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
ExportController.php	2.53 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
ImportController.php	4.26 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
PluginsController.php	1.71 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
PrivilegesController.php	15.59 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
ReplicationController.php	3.52 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
ShowEngineController.php	1.87 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
SqlController.php	1.32 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
UserGroupsController.php	3.11 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
UserGroupsFormController.php	3.29 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive
VariablesController.php	4.29 KB	lrwxr-xr-x	2023-02-07 16:26:36	Edit Download recursive recursive

Directory Contents