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?
12 * Gets some core libraries
14 require_once 'libraries/common.inc.php';
16 use PMA\libraries\DbSearch
;
18 $response = PMA\libraries\Response
::getInstance();
19 $header = $response->getHeader();
20 $scripts = $header->getScripts();
21 $scripts->addFile('db_search.js');
22 $scripts->addFile('sql.js');
23 $scripts->addFile('makegrid.js');
24 $scripts->addFile('jquery/jquery-ui-timepicker-addon.js');
26 require 'libraries/db_common.inc.php';
28 // If config variable $GLOBALS['cfg']['UseDbSearch'] is on false : exit.
29 if (! $GLOBALS['cfg']['UseDbSearch']) {
30 PMA\libraries\Util
::mysqlDie(
31 __('Access denied!'), '', false, $err_url
34 $url_query .= '&goto=db_search.php';
35 $url_params['goto'] = 'db_search.php';
37 // Create a database search instance
38 $db_search = new DbSearch($GLOBALS['db']);
40 // Display top links if we are not in an Ajax request
41 if ($GLOBALS['is_ajax_request'] != true) {
52 ) = PMA\libraries\Util
::getDbInfo($db, isset($sub_part) ?
$sub_part : '');
55 // Main search form has been submitted, get results
56 if (isset($_REQUEST['submit_search'])) {
57 $response->addHTML($db_search->getSearchResults());
59 $response->addHTML('<div id="searchresults"></div>');
62 // If we are in an Ajax request, we need to exit after displaying all the HTML
63 if ($GLOBALS['is_ajax_request'] == true && empty($_REQUEST['ajax_page_request'])) {
67 // Display the search form
69 '<div id="togglesearchresultsdiv"><a id="togglesearchresultlink"></a></div>'
70 . '<br class="clearfloat" />'
72 $response->addHTML($db_search->getSelectionForm());
73 $response->addHTML($db_search->getResultDivs());