2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * query by example the whole database
8 use PhpMyAdmin\Database\Qbe
;
9 use PhpMyAdmin\Message
;
10 use PhpMyAdmin\Relation
;
11 use PhpMyAdmin\Response
;
12 use PhpMyAdmin\SavedSearches
;
20 require_once 'libraries/common.inc.php';
22 $response = Response
::getInstance();
24 // Gets the relation settings
25 $cfgRelation = Relation
::getRelationsParam();
27 $savedSearchList = array();
29 $currentSearchId = null;
30 if ($cfgRelation['savedsearcheswork']) {
31 $header = $response->getHeader();
32 $scripts = $header->getScripts();
33 $scripts->addFile('db_qbe.js');
35 //Get saved search list.
36 $savedSearch = new SavedSearches($GLOBALS);
37 $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
38 ->setDbname($_REQUEST['db']);
40 if (!empty($_REQUEST['searchId'])) {
41 $savedSearch->setId($_REQUEST['searchId']);
44 //Action field is sent.
45 if (isset($_REQUEST['action'])) {
46 $savedSearch->setSearchName($_REQUEST['searchName']);
47 if ('create' === $_REQUEST['action']) {
48 $saveResult = $savedSearch->setId(null)
49 ->setCriterias($_REQUEST)
51 } elseif ('update' === $_REQUEST['action']) {
52 $saveResult = $savedSearch->setCriterias($_REQUEST)
54 } elseif ('delete' === $_REQUEST['action']) {
55 $deleteResult = $savedSearch->delete();
56 //After deletion, reset search.
57 $savedSearch = new SavedSearches($GLOBALS);
58 $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
59 ->setDbname($_REQUEST['db']);
61 } elseif ('load' === $_REQUEST['action']) {
62 if (empty($_REQUEST['searchId'])) {
63 //when not loading a search, reset the object.
64 $savedSearch = new SavedSearches($GLOBALS);
65 $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
66 ->setDbname($_REQUEST['db']);
69 $loadResult = $savedSearch->load();
72 //Else, it's an "update query"
75 $savedSearchList = $savedSearch->getList();
76 $currentSearchId = $savedSearch->getId();
80 * A query has been submitted -> (maybe) execute it
82 $message_to_display = false;
83 if (isset($_REQUEST['submit_sql']) && ! empty($sql_query)) {
84 if (! preg_match('@^SELECT@i', $sql_query)) {
85 $message_to_display = true;
89 $sql->executeQueryAndSendQueryResponse(
90 null, // analyzed_sql_results
92 $_REQUEST['db'], // db
94 false, // find_real_end
95 null, // sql_query_for_bookmark
97 null, // message_to_show
101 $pmaThemeImage, // pmaThemeImage
103 null, // disp_message
105 $sql_query, // sql_query
106 null, // selectedTables
107 null // complete_query
113 require 'libraries/db_common.inc.php';
114 $url_query .= '&goto=db_qbe.php';
115 $url_params['goto'] = 'db_qbe.php';
123 $db_is_system_schema,
127 ) = Util
::getDbInfo($db, isset($sub_part) ?
$sub_part : '');
129 if ($message_to_display) {
131 __('You have to choose at least one column to display!')
135 unset($message_to_display);
137 // create new qbe search instance
138 $db_qbe = new Qbe($GLOBALS['db'], $savedSearchList, $savedSearch);
140 $url = 'db_designer.php' . Url
::getCommon(
149 __('Switch to %svisual builder%s'),
150 '<a href="' . $url . '">',
157 * Displays the Query by example form
159 $response->addHTML($db_qbe->getSelectionForm());