libraries/classes/Controllers/Database/MultiTableQueryController.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Controllers\Database;
   6
   7 use PhpMyAdmin\Database\MultiTableQuery;
   8 use PhpMyAdmin\DatabaseInterface;
   9 use PhpMyAdmin\Response;
  10 use PhpMyAdmin\Template;
  11
  12 /**
  13  * Handles database multi-table querying
  14  */
  15 class MultiTableQueryController extends AbstractController
  16 {
  17     /** @var DatabaseInterface */
  18     private $dbi;
  19
  20     /**
  21      * @param Response          $response
  22      * @param string            $db       Database name.
  23      * @param DatabaseInterface $dbi
  24      */
  25     public function __construct($response, Template $template, $db, $dbi)
  26     {
  27         parent::__construct($response, $template, $db);
  28         $this->dbi = $dbi;
  29     }
  30
  31     public function index(): void
  32     {
  33         $this->addScriptFiles([
  34             'vendor/jquery/jquery.md5.js',
  35             'database/multi_table_query.js',
  36             'database/query_generator.js',
  37         ]);
  38
  39         $queryInstance = new MultiTableQuery($this->dbi, $this->template, $this->db);
  40
  41         $this->response->addHTML($queryInstance->getFormHtml());
  42     }
  43
  44     public function displayResults(): void
  45     {
  46         global $PMA_Theme;
  47
  48         $params = [
  49             'sql_query' => $_POST['sql_query'],
  50             'db' => $_POST['db'] ?? $_GET['db'] ?? null,
  51         ];
  52
  53         $this->response->addHTML(MultiTableQuery::displayResults(
  54             $params['sql_query'],
  55             $params['db'],
  56             $PMA_Theme->getImgPath()
  57         ));
  58     }
  59
  60     public function table(): void
  61     {
  62         $params = [
  63             'tables' => $_GET['tables'],
  64             'db' => $_GET['db'] ?? null,
  65         ];
  66         $constrains = $this->dbi->getForeignKeyConstrains(
  67             $params['db'],
  68             $params['tables']
  69         );
  70         $this->response->addJSON(['foreignKeyConstrains' => $constrains]);
  71     }
  72 }