libraries/classes/Controllers/Sql/EnumValuesController.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Controllers\Sql;
   6
   7 use PhpMyAdmin\CheckUserPrivileges;
   8 use PhpMyAdmin\Controllers\AbstractController;
   9 use PhpMyAdmin\ResponseRenderer;
  10 use PhpMyAdmin\Sql;
  11 use PhpMyAdmin\Template;
  12
  13 use function __;
  14 use function htmlentities;
  15
  16 use const ENT_COMPAT;
  17
  18 final class EnumValuesController extends AbstractController
  19 {
  20     /** @var Sql */
  21     private $sql;
  22
  23     /** @var CheckUserPrivileges */
  24     private $checkUserPrivileges;
  25
  26     public function __construct(
  27         ResponseRenderer $response,
  28         Template $template,
  29         Sql $sql,
  30         CheckUserPrivileges $checkUserPrivileges
  31     ) {
  32         parent::__construct($response, $template);
  33         $this->sql = $sql;
  34         $this->checkUserPrivileges = $checkUserPrivileges;
  35     }
  36
  37     /**
  38      * Get possible values for enum fields during grid edit.
  39      */
  40     public function __invoke(): void
  41     {
  42         $this->checkUserPrivileges->getPrivileges();
  43
  44         $column = $_POST['column'];
  45         $curr_value = $_POST['curr_value'];
  46         $values = $this->sql->getValuesForColumn($GLOBALS['db'], $GLOBALS['table'], $column);
  47
  48         if ($values === null) {
  49             $this->response->addJSON('message', __('Error in processing request'));
  50             $this->response->setRequestStatus(false);
  51
  52             return;
  53         }
  54
  55         // Converts characters of $curr_value to HTML entities.
  56         $convertedCurrentValue = htmlentities($curr_value, ENT_COMPAT, 'UTF-8');
  57
  58         $dropdown = $this->template->render('sql/enum_column_dropdown', [
  59             'values' => $values,
  60             'selected_values' => [$convertedCurrentValue],
  61         ]);
  62
  63         $this->response->addJSON('dropdown', $dropdown);
  64     }
  65 }