2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * searches the entire database
6 * @todo make use of UNION when searching multiple tables
7 * @todo display executed query, optional?
11 use PhpMyAdmin\Database\Search
;
12 use PhpMyAdmin\Response
;
16 * Gets some core libraries
18 require_once 'libraries/common.inc.php';
20 $response = Response
::getInstance();
21 $header = $response->getHeader();
22 $scripts = $header->getScripts();
23 $scripts->addFile('db_search.js');
24 $scripts->addFile('sql.js');
25 $scripts->addFile('makegrid.js');
26 $scripts->addFile('vendor/jquery/jquery-ui-timepicker-addon.js');
28 require 'libraries/db_common.inc.php';
30 // If config variable $GLOBALS['cfg']['UseDbSearch'] is on false : exit.
31 if (! $GLOBALS['cfg']['UseDbSearch']) {
33 __('Access denied!'), '', false, $err_url
36 $url_query .= '&goto=db_search.php';
37 $url_params['goto'] = 'db_search.php';
39 // Create a database search instance
40 $db_search = new Search($GLOBALS['db']);
42 // Display top links if we are not in an Ajax request
43 if (! $response->isAjax()) {
54 ) = Util
::getDbInfo($db, isset($sub_part) ?
$sub_part : '');
57 // Main search form has been submitted, get results
58 if (isset($_REQUEST['submit_search'])) {
59 $response->addHTML($db_search->getSearchResults());
62 // If we are in an Ajax request, we need to exit after displaying all the HTML
63 if ($response->isAjax() && empty($_REQUEST['ajax_page_request'])) {
67 // Display the search form
68 $response->addHTML($db_search->getSelectionForm());
69 $response->addHTML('<div id="searchresults"></div>');
71 '<div id="togglesearchresultsdiv"><a id="togglesearchresultlink"></a></div>'
73 $response->addHTML('<br class="clearfloat" />');
74 $response->addHTML($db_search->getResultDivs());