db_sql_autocomplete.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Table/Column autocomplete in SQL editors
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 require_once 'libraries/common.inc.php';
  10
  11 $db = isset($_POST['db']) ? $_POST['db'] : $GLOBALS['db'];
  12 $sql_autocomplete = array();
  13
  14 if ($db) {
  15     $tableNames = $GLOBALS['dbi']->getTables($db);
  16     foreach ($tableNames as $tableName) {
  17         $sql_autocomplete[$tableName] = $GLOBALS['dbi']->getColumnNames(
  18             $db, $tableName
  19         );
  20     }
  21 }
  22
  23 $response = PMA_Response::getInstance();
  24 $response->addJSON("tables", json_encode($sql_autocomplete));