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;
88 Sql
::executeQueryAndSendQueryResponse(
89 null, // analyzed_sql_results
91 $_REQUEST['db'], // db
93 false, // find_real_end
94 null, // sql_query_for_bookmark
96 null, // message_to_show
100 $pmaThemeImage, // pmaThemeImage
102 null, // disp_message
104 $sql_query, // sql_query
105 null, // selectedTables
106 null // complete_query
112 require 'libraries/db_common.inc.php';
113 $url_query .= '&goto=db_qbe.php';
114 $url_params['goto'] = 'db_qbe.php';
122 $db_is_system_schema,
126 ) = Util
::getDbInfo($db, isset($sub_part) ?
$sub_part : '');
128 if ($message_to_display) {
130 __('You have to choose at least one column to display!')
134 unset($message_to_display);
136 // create new qbe search instance
137 $db_qbe = new Qbe($GLOBALS['db'], $savedSearchList, $savedSearch);
139 $url = 'db_designer.php' . Url
::getCommon(
148 __('Switch to %svisual builder%s'),
149 '<a href="' . $url . '">',
156 * Displays the Query by example form
158 $response->addHTML($db_qbe->getSelectionForm());