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 declare(strict_types=1);
  11
  12 use PhpMyAdmin\Database\Search;
  13 use PhpMyAdmin\DatabaseInterface;
  14 use PhpMyAdmin\Response;
  15 use PhpMyAdmin\Template;
  16 use PhpMyAdmin\Util;
  17
  18 if (! defined('ROOT_PATH')) {
  19     define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
  20 }
  21
  22 global $db, $url_query;
  23
  24 require_once ROOT_PATH . 'libraries/common.inc.php';
  25
  26 /** @var Response $response */
  27 $response = $containerBuilder->get(Response::class);
  28
  29 /** @var DatabaseInterface $dbi */
  30 $dbi = $containerBuilder->get(DatabaseInterface::class);
  31
  32 /** @var Template $template */
  33 $template = $containerBuilder->get('template');
  34
  35 $header = $response->getHeader();
  36 $scripts = $header->getScripts();
  37 $scripts->addFile('database/search.js');
  38 $scripts->addFile('sql.js');
  39 $scripts->addFile('makegrid.js');
  40
  41 require ROOT_PATH . 'libraries/db_common.inc.php';
  42
  43 // If config variable $GLOBALS['cfg']['UseDbSearch'] is on false : exit.
  44 if (! $GLOBALS['cfg']['UseDbSearch']) {
  45     Util::mysqlDie(
  46         __('Access denied!'),
  47         '',
  48         false,
  49         $err_url
  50     );
  51 } // end if
  52 $url_query .= '&amp;goto=db_search.php';
  53 $url_params['goto'] = 'db_search.php';
  54
  55 // Create a database search instance
  56 $db_search = new Search($dbi, $db, $template);
  57
  58 // Display top links if we are not in an Ajax request
  59 if (! $response->isAjax()) {
  60     list(
  61         $tables,
  62         $num_tables,
  63         $total_num_tables,
  64         $sub_part,
  65         $is_show_stats,
  66         $db_is_system_schema,
  67         $tooltip_truename,
  68         $tooltip_aliasname,
  69         $pos
  70     ) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
  71 }
  72
  73 // Main search form has been submitted, get results
  74 if (isset($_POST['submit_search'])) {
  75     $response->addHTML($db_search->getSearchResults());
  76 }
  77
  78 // If we are in an Ajax request, we need to exit after displaying all the HTML
  79 if ($response->isAjax() && empty($_REQUEST['ajax_page_request'])) {
  80     exit;
  81 }
  82
  83 // Display the search form
  84 $response->addHTML($db_search->getMainHtml());