FM / Database

/usr/share/phpmyadmin/libraries/classes/Controllers/Database/

/usr/share/phpmyadmin/libraries/classes/Controllers/Database

Name	Size	Mode	Actions
AbstractController.php	541	0644	edit dl rm
CentralColumnsController.php	9297	0644	edit dl rm
DataDictionaryController.php	4670	0644	edit dl rm
DesignerController.php	10050	0644	edit dl rm
EventsController.php	2526	0644	edit dl rm
ExportController.php	5778	0644	edit dl rm
ImportController.php	4487	0644	edit dl rm
MultiTableQueryController.php	1823	0644	edit dl rm
OperationsController.php	15144	0644	edit dl rm
PrivilegesController.php	1802	0644	edit dl rm
QueryByExampleController.php	5966	0644	edit dl rm
RoutinesController.php	3744	0644	edit dl rm
SearchController.php	2674	0644	edit dl rm
SqlAutoCompleteController.php	1361	0644	edit dl rm
SqlController.php	1862	0644	edit dl rm
SqlFormatController.php	483	0644	edit dl rm
StructureController.php	55970	0644	edit dl rm
TrackingController.php	5195	0644	edit dl rm
TriggersController.php	2561	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Controllers/Database/MultiTableQueryController.php (1823B)

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Database;

use PhpMyAdmin\Database\MultiTableQuery;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Response;
use PhpMyAdmin\Template;

/**
 * Handles database multi-table querying
 */
class MultiTableQueryController extends AbstractController
{
    /** @var DatabaseInterface */
    private $dbi;

/**
     * @param Response          $response
     * @param string            $db       Database name.
     * @param DatabaseInterface $dbi
     */
    public function __construct($response, Template $template, $db, $dbi)
    {
        parent::__construct($response, $template, $db);
        $this->dbi = $dbi;
    }

public function index(): void
    {
        $this->addScriptFiles([
            'vendor/jquery/jquery.md5.js',
            'database/multi_table_query.js',
            'database/query_generator.js',
        ]);

$queryInstance = new MultiTableQuery($this->dbi, $this->template, $this->db);

$this->response->addHTML($queryInstance->getFormHtml());
    }

public function displayResults(): void
    {
        global $PMA_Theme;

$params = [
            'sql_query' => $_POST['sql_query'],
            'db' => $_POST['db'] ?? $_GET['db'] ?? null,
        ];

$this->response->addHTML(MultiTableQuery::displayResults(
            $params['sql_query'],
            $params['db'],
            $PMA_Theme->getImgPath()
        ));
    }

public function table(): void
    {
        $params = [
            'tables' => $_GET['tables'],
            'db' => $_GET['db'] ?? null,
        ];
        $constrains = $this->dbi->getForeignKeyConstrains(
            $params['db'],
            $params['tables']
        );
        $this->response->addJSON(['foreignKeyConstrains' => $constrains]);
    }
}

dbi = $dbi; } public function index(): void { $this->addScriptFiles([ 'vendor/jquery/jquery.md5.js', 'database/multi_table_query.js', 'database/query_generator.js', ]); $queryInstance = new MultiTableQuery($this->dbi, $this->template, $this->db); $this->response->addHTML($queryInstance->getFormHtml()); } public function displayResults(): void { global $PMA_Theme; $params = [ 'sql_query' => $_POST['sql_query'], 'db' => $_POST['db'] ?? $_GET['db'] ?? null, ]; $this->response->addHTML(MultiTableQuery::displayResults( $params['sql_query'], $params['db'], $PMA_Theme->getImgPath() )); } public function table(): void { $params = [ 'tables' => $_GET['tables'], 'db' => $_GET['db'] ?? null, ]; $constrains = $this->dbi->getForeignKeyConstrains( $params['db'], $params['tables'] ); $this->response->addJSON(['foreignKeyConstrains' => $constrains]); } }