Na}{

File Content: `SqlAutoCompleteController.php`

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Controllers\Database;

use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\ResponseRenderer;
use PhpMyAdmin\Template;

use function json_encode;

/**
 * Table/Column autocomplete in SQL editors.
 */
class SqlAutoCompleteController extends AbstractController
{
    /** @var DatabaseInterface */
    private $dbi;

    public function __construct(ResponseRenderer $response, Template $template, string $db, DatabaseInterface $dbi)
    {
        parent::__construct($response, $template, $db);
        $this->dbi = $dbi;
    }

    public function __invoke(): void
    {
        global $cfg, $db, $sql_autocomplete;

        $sql_autocomplete = true;
        if ($cfg['EnableAutocompleteForTablesAndColumns']) {
            $db = $_POST['db'] ?? $db;
            $sql_autocomplete = [];
            if ($db) {
                $tableNames = $this->dbi->getTables($db);
                foreach ($tableNames as $tableName) {
                    $sql_autocomplete[$tableName] = $this->dbi->getColumns($db, $tableName);
                }
            }
        }

        $this->response->addJSON(['tables' => json_encode($sql_autocomplete)]);
    }
}

Name	Size	Permission
CentralColumns	---	0755
MultiTableQuery	---	0755
Operations	---	0755
Structure	---	0755
AbstractController.php	477 bytes	0644
CentralColumnsController.php	8711 bytes	0644
DataDictionaryController.php	4250 bytes	0644
DesignerController.php	9765 bytes	0644
EventsController.php	2361 bytes	0644
ExportController.php	5263 bytes	0644
ImportController.php	4840 bytes	0644
MultiTableQueryController.php	922 bytes	0644
OperationsController.php	12134 bytes	0644
PrivilegesController.php	1851 bytes	0644
QueryByExampleController.php	5875 bytes	0644
RoutinesController.php	3622 bytes	0644
SearchController.php	2509 bytes	0644
SqlAutoCompleteController.php	1194 bytes	0644
SqlController.php	1751 bytes	0644
SqlFormatController.php	487 bytes	0644
StructureController.php	33075 bytes	0644
TrackingController.php	5030 bytes	0644
TriggersController.php	2523 bytes	0644

Name

Size

Permission

Action

CentralColumns

---

0755