Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
optometrists
/
cache
/
.wp-cli
/
wp-content
/
plugins
/
wp-phpmyadmin-extension
/
lib
/
phpMyAdmin
/
libraries
/
classes
/
Controllers
/
Table
/
Structure
:
SpatialController.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php declare(strict_types=1); namespace PhpMyAdmin\Controllers\Table\Structure; use PhpMyAdmin\Controllers\Table\AbstractController; use PhpMyAdmin\Controllers\Table\StructureController; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Message; use PhpMyAdmin\ResponseRenderer; use PhpMyAdmin\Template; use PhpMyAdmin\Util; use function __; use function count; final class SpatialController extends AbstractController { /** @var DatabaseInterface */ private $dbi; /** @var StructureController */ private $structureController; public function __construct( ResponseRenderer $response, Template $template, string $db, string $table, DatabaseInterface $dbi, StructureController $structureController ) { parent::__construct($response, $template, $db, $table); $this->dbi = $dbi; $this->structureController = $structureController; } public function __invoke(): void { global $sql_query, $db, $table, $message; $selected = $_POST['selected_fld'] ?? []; if (empty($selected)) { $this->response->setRequestStatus(false); $this->response->addJSON('message', __('No column selected.')); return; } $i = 1; $selectedCount = count($selected); $sql_query = 'ALTER TABLE ' . Util::backquote($table) . ' ADD SPATIAL('; foreach ($selected as $field) { $sql_query .= Util::backquote($field); $sql_query .= $i++ === $selectedCount ? ');' : ', '; } $this->dbi->selectDb($db); $result = $this->dbi->tryQuery($sql_query); if (! $result) { $message = Message::error($this->dbi->getError()); } if (empty($message)) { $message = Message::success(); } ($this->structureController)(); } }