2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Table/Column autocomplete in SQL editors
8 declare(strict_types
=1);
10 use PhpMyAdmin\DatabaseInterface
;
11 use PhpMyAdmin\Response
;
13 if (! defined('ROOT_PATH')) {
14 define('ROOT_PATH', __DIR__
. DIRECTORY_SEPARATOR
);
17 require_once ROOT_PATH
. 'libraries/common.inc.php';
19 /** @var Response $response */
20 $response = $containerBuilder->get(Response
::class);
22 /** @var DatabaseInterface $dbi */
23 $dbi = $containerBuilder->get(DatabaseInterface
::class);
25 if ($GLOBALS['cfg']['EnableAutocompleteForTablesAndColumns']) {
26 $db = isset($_POST['db']) ?
$_POST['db'] : $GLOBALS['db'];
27 $sql_autocomplete = [];
29 $tableNames = $dbi->getTables($db);
30 foreach ($tableNames as $tableName) {
31 $sql_autocomplete[$tableName] = $dbi->getColumns(
38 $sql_autocomplete = true;
41 $response->addJSON("tables", json_encode($sql_autocomplete));