db_sql_autocomplete.php 725 B

1234567891011121314151617181920212223242526
  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. require_once 'libraries/common.inc.php';
  9. if ($GLOBALS['cfg']['EnableAutocompleteForTablesAndColumns']) {
  10. $db = isset($_POST['db']) ? $_POST['db'] : $GLOBALS['db'];
  11. $sql_autocomplete = array();
  12. if ($db) {
  13. $tableNames = $GLOBALS['dbi']->getTables($db);
  14. foreach ($tableNames as $tableName) {
  15. $sql_autocomplete[$tableName] = $GLOBALS['dbi']->getColumns(
  16. $db, $tableName
  17. );
  18. }
  19. }
  20. } else {
  21. $sql_autocomplete = true;
  22. }
  23. $response = PMA_Response::getInstance();
  24. $response->addJSON("tables", json_encode($sql_autocomplete));