FM / Table

/usr/share/phpmyadmin/libraries/classes/Controllers/Table/

/usr/share/phpmyadmin/libraries/classes/Controllers/Table

Name	Size	Mode	Actions
AbstractController.php	667	0644	edit dl rm
AddFieldController.php	5869	0644	edit dl rm
ChangeController.php	10368	0644	edit dl rm
ChartController.php	7362	0644	edit dl rm
CreateController.php	5514	0644	edit dl rm
DeleteController.php	4032	0644	edit dl rm
ExportController.php	5436	0644	edit dl rm
FindReplaceController.php	12430	0644	edit dl rm
GetFieldController.php	2680	0644	edit dl rm
GisVisualizationController.php	6625	0644	edit dl rm
ImportController.php	4416	0644	edit dl rm
IndexesController.php	8984	0644	edit dl rm
MaintenanceController.php	6019	0644	edit dl rm
OperationsController.php	18857	0644	edit dl rm
PartitionController.php	5463	0644	edit dl rm
PrivilegesController.php	1975	0644	edit dl rm
RecentFavoriteController.php	793	0644	edit dl rm
RelationController.php	12084	0644	edit dl rm
ReplaceController.php	23698	0644	edit dl rm
SearchController.php	13317	0644	edit dl rm
SqlController.php	2028	0644	edit dl rm
StructureController.php	60724	0644	edit dl rm
TrackingController.php	8098	0644	edit dl rm
TriggersController.php	2628	0644	edit dl rm
ZoomSearchController.php	16750	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Controllers/Table/MaintenanceController.php (6019B)

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Table;

use PhpMyAdmin\Html\Generator;
use PhpMyAdmin\Response;
use PhpMyAdmin\Table\Maintenance;
use PhpMyAdmin\Template;
use function count;
use function is_array;

final class MaintenanceController extends AbstractController
{
    /** @var Maintenance */
    private $model;

/**
     * @param Response $response
     * @param string   $db
     * @param string   $table
     */
    public function __construct(
        $response,
        Template $template,
        $db,
        $table,
        Maintenance $model
    ) {
        parent::__construct($response, $template, $db, $table);
        $this->model = $model;
    }

public function analyze(): void
    {
        global $cfg;

/** @var string[] $selected */
        $selected = $_POST['selected_tbl'] ?? [];

if (empty($selected) || ! is_array($selected)) {
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', __('No table selected.'));

return;
        }

if ($cfg['DisableMultiTableMaintenance'] && count($selected) > 1) {
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.'));

return;
        }

[$rows, $query] = $this->model->getAnalyzeTableRows($this->db, $selected);

$message = Generator::getMessage(
            __('Your SQL query has been executed successfully.'),
            $query,
            'success'
        );

$this->render('table/maintenance/analyze', [
            'message' => $message,
            'rows' => $rows,
        ]);
    }

public function check(): void
    {
        global $cfg;

/** @var string[] $selected */
        $selected = $_POST['selected_tbl'] ?? [];

if (empty($selected) || ! is_array($selected)) {
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', __('No table selected.'));

return;
        }

[$rows, $query] = $this->model->getCheckTableRows($this->db, $selected);

$message = Generator::getMessage(
            __('Your SQL query has been executed successfully.'),
            $query,
            'success'
        );

$indexesProblems = $this->model->getIndexesProblems($this->db, $selected);

$this->render('table/maintenance/check', [
            'message' => $message,
            'rows' => $rows,
            'indexes_problems' => $indexesProblems,
        ]);
    }

public function checksum(): void
    {
        global $cfg;

/** @var string[] $selected */
        $selected = $_POST['selected_tbl'] ?? [];

if (empty($selected) || ! is_array($selected)) {
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', __('No table selected.'));

return;
        }

[$rows, $query, $warnings] = $this->model->getChecksumTableRows($this->db, $selected);

$message = Generator::getMessage(
            __('Your SQL query has been executed successfully.'),
            $query,
            'success'
        );

$this->render('table/maintenance/checksum', [
            'message' => $message,
            'rows' => $rows,
            'warnings' => $warnings,
        ]);
    }

public function optimize(): void
    {
        global $cfg;

/** @var string[] $selected */
        $selected = $_POST['selected_tbl'] ?? [];

if (empty($selected) || ! is_array($selected)) {
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', __('No table selected.'));

return;
        }

[$rows, $query] = $this->model->getOptimizeTableRows($this->db, $selected);

$message = Generator::getMessage(
            __('Your SQL query has been executed successfully.'),
            $query,
            'success'
        );

$this->render('table/maintenance/optimize', [
            'message' => $message,
            'rows' => $rows,
        ]);
    }

public function repair(): void
    {
        global $cfg;

/** @var string[] $selected */
        $selected = $_POST['selected_tbl'] ?? [];

if (empty($selected) || ! is_array($selected)) {
            $this->response->setRequestStatus(false);
            $this->response->addJSON('message', __('No table selected.'));

return;
        }

[$rows, $query] = $this->model->getRepairTableRows($this->db, $selected);

$message = Generator::getMessage(
            __('Your SQL query has been executed successfully.'),
            $query,
            'success'
        );

$this->render('table/maintenance/repair', [
            'message' => $message,
            'rows' => $rows,
        ]);
    }
}

model = $model; } public function analyze(): void { global $cfg; /** @var string[] $selected */ $selected = $_POST['selected_tbl'] ?? []; if (empty($selected) || ! is_array($selected)) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('No table selected.')); return; } if ($cfg['DisableMultiTableMaintenance'] && count($selected) > 1) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.')); return; } [$rows, $query] = $this->model->getAnalyzeTableRows($this->db, $selected); $message = Generator::getMessage( __('Your SQL query has been executed successfully.'), $query, 'success' ); $this->render('table/maintenance/analyze', [ 'message' => $message, 'rows' => $rows, ]); } public function check(): void { global $cfg; /** @var string[] $selected */ $selected = $_POST['selected_tbl'] ?? []; if (empty($selected) || ! is_array($selected)) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('No table selected.')); return; } if ($cfg['DisableMultiTableMaintenance'] && count($selected) > 1) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.')); return; } [$rows, $query] = $this->model->getCheckTableRows($this->db, $selected); $message = Generator::getMessage( __('Your SQL query has been executed successfully.'), $query, 'success' ); $indexesProblems = $this->model->getIndexesProblems($this->db, $selected); $this->render('table/maintenance/check', [ 'message' => $message, 'rows' => $rows, 'indexes_problems' => $indexesProblems, ]); } public function checksum(): void { global $cfg; /** @var string[] $selected */ $selected = $_POST['selected_tbl'] ?? []; if (empty($selected) || ! is_array($selected)) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('No table selected.')); return; } if ($cfg['DisableMultiTableMaintenance'] && count($selected) > 1) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.')); return; } [$rows, $query, $warnings] = $this->model->getChecksumTableRows($this->db, $selected); $message = Generator::getMessage( __('Your SQL query has been executed successfully.'), $query, 'success' ); $this->render('table/maintenance/checksum', [ 'message' => $message, 'rows' => $rows, 'warnings' => $warnings, ]); } public function optimize(): void { global $cfg; /** @var string[] $selected */ $selected = $_POST['selected_tbl'] ?? []; if (empty($selected) || ! is_array($selected)) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('No table selected.')); return; } if ($cfg['DisableMultiTableMaintenance'] && count($selected) > 1) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.')); return; } [$rows, $query] = $this->model->getOptimizeTableRows($this->db, $selected); $message = Generator::getMessage( __('Your SQL query has been executed successfully.'), $query, 'success' ); $this->render('table/maintenance/optimize', [ 'message' => $message, 'rows' => $rows, ]); } public function repair(): void { global $cfg; /** @var string[] $selected */ $selected = $_POST['selected_tbl'] ?? []; if (empty($selected) || ! is_array($selected)) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('No table selected.')); return; } if ($cfg['DisableMultiTableMaintenance'] && count($selected) > 1) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('Maintenance operations on multiple tables are disabled.')); return; } [$rows, $query] = $this->model->getRepairTableRows($this->db, $selected); $message = Generator::getMessage( __('Your SQL query has been executed successfully.'), $query, 'success' ); $this->render('table/maintenance/repair', [ 'message' => $message, 'rows' => $rows, ]); } }