db_search.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * searches 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 /**
  12  * Gets some core libraries
  13  */
  14 require_once 'libraries/common.inc.php';
  15
  16 use PMA\libraries\Response;
  17 use PMA\libraries\DbSearch;
  18
  19 $response = Response::getInstance();
  20 $header   = $response->getHeader();
  21 $scripts  = $header->getScripts();
  22 $scripts->addFile('db_search.js');
  23 $scripts->addFile('sql.js');
  24 $scripts->addFile('makegrid.js');
  25 $scripts->addFile('jquery/jquery-ui-timepicker-addon.js');
  26
  27 require 'libraries/db_common.inc.php';
  28
  29 // If config variable $GLOBALS['cfg']['UseDbSearch'] is on false : exit.
  30 if (! $GLOBALS['cfg']['UseDbSearch']) {
  31     PMA\libraries\Util::mysqlDie(
  32         __('Access denied!'), '', false, $err_url
  33     );
  34 } // end if
  35 $url_query .= '&amp;goto=db_search.php';
  36 $url_params['goto'] = 'db_search.php';
  37
  38 // Create a database search instance
  39 $db_search = new DbSearch($GLOBALS['db']);
  40
  41 // Display top links if we are not in an Ajax request
  42 if (! $response->isAjax()) {
  43     list(
  44         $tables,
  45         $num_tables,
  46         $total_num_tables,
  47         $sub_part,
  48         $is_show_stats,
  49         $db_is_system_schema,
  50         $tooltip_truename,
  51         $tooltip_aliasname,
  52         $pos
  53     ) = PMA\libraries\Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
  54 }
  55
  56 // Main search form has been submitted, get results
  57 if (isset($_REQUEST['submit_search'])) {
  58     $response->addHTML($db_search->getSearchResults());
  59 }
  60
  61 // If we are in an Ajax request, we need to exit after displaying all the HTML
  62 if ($response->isAjax() && empty($_REQUEST['ajax_page_request'])) {
  63     exit;
  64 }
  65
  66 // Display the search form
  67 $response->addHTML($db_search->getSelectionForm());
  68 $response->addHTML('<div id="searchresults"></div>');
  69 $response->addHTML(
  70     '<div id="togglesearchresultsdiv"><a id="togglesearchresultlink"></a></div>'
  71 );
  72 $response->addHTML('<br class="clearfloat" />');
  73 $response->addHTML($db_search->getResultDivs());