Feature Request #1625 Autocomplete Sql

Gives an option to user to toggle autocomplete of table and column
names in config settings

Signed-off-by: Pratik Sethia <pratiksethia1@gmail.com>

1 files changed, 12 insertions, 12 deletions

diff --git a/db_sql_autocomplete.php b/db_sql_autocomplete.php
index 4897f0058a..29f117afcf 100644
--- a/db_sql_autocomplete.php
+++ b/db_sql_autocomplete.php
@@ -8,17 +8,17 @@
 
 require_once 'libraries/common.inc.php';
 
-$db = isset($_POST['db']) ? $_POST['db'] : $GLOBALS['db'];
-$sql_autocomplete = array();
-
-if ($db) {
-    $tableNames = $GLOBALS['dbi']->getTables($db);
-    foreach ($tableNames as $tableName) {
-        $sql_autocomplete[$tableName] = $GLOBALS['dbi']->getColumns(
-            $db, $tableName
-        );
+if ($GLOBALS['cfg']['EnableAutocompleteForTablesAndColumns']) {
+    $db = isset($_POST['db']) ? $_POST['db'] : $GLOBALS['db'];
+    $sql_autocomplete = array();
+    if ($db) {
+        $tableNames = $GLOBALS['dbi']->getTables($db);
+        foreach ($tableNames as $tableName) {
+            $sql_autocomplete[$tableName] = $GLOBALS['dbi']->getColumns(
+                $db, $tableName
+            );
+        }
     }
+    $response = PMA_Response::getInstance();
+    $response->addJSON("tables", json_encode($sql_autocomplete));
 }
-
-$response = PMA_Response::getInstance();
-$response->addJSON("tables", json_encode($sql_autocomplete));