Autocomplete table/column names in SQL editors

- In DB and Table level SQL editors, console
- Updated CodeMirror addon `sql-hint.js` to newer version

Signed-off-by: Nisarg Jhaveri <nisarg.jhaveri@research.iiit.ac.in>

1 files changed, 22 insertions, 0 deletions

diff --git a/db_sql_autocomplete.php b/db_sql_autocomplete.php
new file mode 100644
index 0000000000..48cf3d884c
--- /dev/null
+++ b/db_sql_autocomplete.php
@@ -0,0 +1,22 @@
+<?php
+/* vim: set expandtab sw=4 ts=4 sts=4: */
+/**
+ * Table/Column autocomplete in SQL editors
+ *
+ * @package PhpMyAdmin
+ */
+
+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']->getColumnNames($db, $tableName);
+    }
+}
+
+$response = PMA_Response::getInstance();
+$response->addJSON("tables", json_encode($sql_autocomplete));