db_search.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4. * searchs the entire database
  5. *
  6. * @todo make use of UNION when searching multiple tables
  7. * @todo display executed query, optional?
  8. * @package PhpMyAdmin
  9. */
  10. /**
  11. * Gets some core libraries
  12. */
  13. require_once 'libraries/common.inc.php';
  14. require_once 'libraries/DbSearch.class.php';
  15. $response = PMA_Response::getInstance();
  16. $header = $response->getHeader();
  17. $scripts = $header->getScripts();
  18. $scripts->addFile('db_search.js');
  19. $scripts->addFile('sql.js');
  20. $scripts->addFile('makegrid.js');
  21. $scripts->addFile('jquery/jquery-ui-timepicker-addon.js');
  22. require 'libraries/db_common.inc.php';
  23. // If config variable $GLOBALS['cfg']['Usedbsearch'] is on false : exit.
  24. if (! $GLOBALS['cfg']['UseDbSearch']) {
  25. PMA_Util::mysqlDie(
  26. __('Access denied!'), '', false, $err_url
  27. );
  28. } // end if
  29. $url_query .= '&amp;goto=db_search.php';
  30. $url_params['goto'] = 'db_search.php';
  31. // Create a database search instance
  32. $db_search = new PMA_DbSearch($GLOBALS['db']);
  33. // Display top links if we are not in an Ajax request
  34. if ( $GLOBALS['is_ajax_request'] != true) {
  35. include 'libraries/db_info.inc.php';
  36. }
  37. // Main search form has been submitted, get results
  38. if (isset($_REQUEST['submit_search'])) {
  39. $response->addHTML($db_search->getSearchResults());
  40. } else {
  41. $response->addHTML('<div id="searchresults"></div>');
  42. }
  43. // If we are in an Ajax request, we need to exit after displaying all the HTML
  44. if ($GLOBALS['is_ajax_request'] == true && empty($_REQUEST['ajax_page_request'])) {
  45. exit;
  46. }
  47. // Display the search form
  48. $response->addHTML(
  49. '<div id="togglesearchresultsdiv"><a id="togglesearchresultlink"></a></div>'
  50. . '<br class="clearfloat" />'
  51. );
  52. $response->addHTML($db_search->getSelectionForm($url_params));
  53. $response->addHTML($db_search->getResultDivs());
  54. ?>