FM / Server

/usr/share/phpmyadmin/libraries/classes/Controllers/Server/

/usr/share/phpmyadmin/libraries/classes/Controllers/Server

Name	Size	Mode	Actions
Status/	-	0755	rm
BinlogController.php	4174	0644	edit dl rm
CollationsController.php	2328	0644	edit dl rm
DatabasesController.php	16734	0644	edit dl rm
EnginesController.php	2225	0644	edit dl rm
ExportController.php	2616	0644	edit dl rm
ImportController.php	3960	0644	edit dl rm
PluginsController.php	1767	0644	edit dl rm
PrivilegesController.php	15959	0644	edit dl rm
ReplicationController.php	3525	0644	edit dl rm
SqlController.php	1450	0644	edit dl rm
UserGroupsController.php	2829	0644	edit dl rm
VariablesController.php	8112	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Controllers/Server/CollationsController.php (2328B)

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Server;

use PhpMyAdmin\Charsets;
use PhpMyAdmin\Charsets\Charset;
use PhpMyAdmin\Charsets\Collation;
use PhpMyAdmin\Controllers\AbstractController;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Response;
use PhpMyAdmin\Template;
use PhpMyAdmin\Url;

/**
 * Handles viewing character sets and collations
 */
class CollationsController extends AbstractController
{
    /** @var array|null */
    private $charsets;

/** @var array|null */
    private $collations;

/** @var DatabaseInterface */
    private $dbi;

/**
     * @param Response          $response
     * @param DatabaseInterface $dbi
     * @param array|null        $charsets   Array of charsets
     * @param array|null        $collations Array of collations
     */
    public function __construct(
        $response,
        Template $template,
        $dbi,
        ?array $charsets = null,
        ?array $collations = null
    ) {
        global $cfg;

parent::__construct($response, $template);
        $this->dbi = $dbi;

$this->charsets = $charsets ?? Charsets::getCharsets($this->dbi, $cfg['Server']['DisableIS']);
        $this->collations = $collations ?? Charsets::getCollations($this->dbi, $cfg['Server']['DisableIS']);
    }

public function index(): void
    {
        global $err_url;

$err_url = Url::getFromRoute('/');

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

$charsets = [];
        /** @var Charset $charset */
        foreach ($this->charsets as $charset) {
            $charsetCollations = [];
            /** @var Collation $collation */
            foreach ($this->collations[$charset->getName()] as $collation) {
                $charsetCollations[] = [
                    'name' => $collation->getName(),
                    'description' => $collation->getDescription(),
                    'is_default' => $collation->isDefault(),
                ];
            }

$charsets[] = [
                'name' => $charset->getName(),
                'description' => $charset->getDescription(),
                'collations' => $charsetCollations,
            ];
        }

$this->render('server/collations/index', ['charsets' => $charsets]);
    }
}

dbi = $dbi; $this->charsets = $charsets ?? Charsets::getCharsets($this->dbi, $cfg['Server']['DisableIS']); $this->collations = $collations ?? Charsets::getCollations($this->dbi, $cfg['Server']['DisableIS']); } public function index(): void { global $err_url; $err_url = Url::getFromRoute('/'); if ($this->dbi->isSuperUser()) { $this->dbi->selectDb('mysql'); } $charsets = []; /** @var Charset $charset */ foreach ($this->charsets as $charset) { $charsetCollations = []; /** @var Collation $collation */ foreach ($this->collations[$charset->getName()] as $collation) { $charsetCollations[] = [ 'name' => $collation->getName(), 'description' => $collation->getDescription(), 'is_default' => $collation->isDefault(), ]; } $charsets[] = [ 'name' => $charset->getName(), 'description' => $charset->getDescription(), 'collations' => $charsetCollations, ]; } $this->render('server/collations/index', ['charsets' => $charsets]); } }