db_qbe.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * query by example the whole database
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 use PMA\libraries\SavedSearches;
   9
  10 /**
  11  * requirements
  12  */
  13 require_once 'libraries/common.inc.php';
  14 require_once 'libraries/bookmark.lib.php';
  15 require_once 'libraries/sql.lib.php';
  16
  17 $response = PMA\libraries\Response::getInstance();
  18
  19 // Gets the relation settings
  20 $cfgRelation = PMA_getRelationsParam();
  21
  22 $savedSearchList = array();
  23 $savedSearch = null;
  24 $currentSearchId = null;
  25 if ($cfgRelation['savedsearcheswork']) {
  26     $header = $response->getHeader();
  27     $scripts = $header->getScripts();
  28     $scripts->addFile('db_qbe.js');
  29
  30     //Get saved search list.
  31     $savedSearch = new SavedSearches($GLOBALS);
  32     $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
  33         ->setDbname($_REQUEST['db']);
  34
  35     if (!empty($_REQUEST['searchId'])) {
  36         $savedSearch->setId($_REQUEST['searchId']);
  37     }
  38
  39     //Action field is sent.
  40     if (isset($_REQUEST['action'])) {
  41         $savedSearch->setSearchName($_REQUEST['searchName']);
  42         if ('create' === $_REQUEST['action']) {
  43             $saveResult = $savedSearch->setId(null)
  44                 ->setCriterias($_REQUEST)
  45                 ->save();
  46         } elseif ('update' === $_REQUEST['action']) {
  47             $saveResult = $savedSearch->setCriterias($_REQUEST)
  48                 ->save();
  49         } elseif ('delete' === $_REQUEST['action']) {
  50             $deleteResult = $savedSearch->delete();
  51             //After deletion, reset search.
  52             $savedSearch = new SavedSearches($GLOBALS);
  53             $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
  54                 ->setDbname($_REQUEST['db']);
  55             $_REQUEST = array();
  56         } elseif ('load' === $_REQUEST['action']) {
  57             if (empty($_REQUEST['searchId'])) {
  58                 //when not loading a search, reset the object.
  59                 $savedSearch = new SavedSearches($GLOBALS);
  60                 $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
  61                     ->setDbname($_REQUEST['db']);
  62                 $_REQUEST = array();
  63             } else {
  64                 $loadResult = $savedSearch->load();
  65             }
  66         }
  67         //Else, it's an "update query"
  68     }
  69
  70     $savedSearchList = $savedSearch->getList();
  71     $currentSearchId = $savedSearch->getId();
  72 }
  73
  74 /**
  75  * A query has been submitted -> (maybe) execute it
  76  */
  77 $message_to_display = false;
  78 if (isset($_REQUEST['submit_sql']) && ! empty($sql_query)) {
  79     if (! preg_match('@^SELECT@i', $sql_query)) {
  80         $message_to_display = true;
  81     } else {
  82         $goto = 'db_sql.php';
  83
  84         // Parse and analyze the query
  85         include_once 'libraries/parse_analyze.lib.php';
  86         list(
  87             $analyzed_sql_results,
  88             $db,
  89             $table
  90         ) = PMA_parseAnalyze($sql_query, $db);
  91         // @todo: possibly refactor
  92         extract($analyzed_sql_results);
  93
  94         PMA_executeQueryAndSendQueryResponse(
  95             $analyzed_sql_results, // analyzed_sql_results
  96             false, // is_gotofile
  97             $_REQUEST['db'], // db
  98             null, // table
  99             false, // find_real_end
 100             null, // sql_query_for_bookmark
 101             null, // extra_data
 102             null, // message_to_show
 103             null, // message
 104             null, // sql_data
 105             $goto, // goto
 106             $pmaThemeImage, // pmaThemeImage
 107             null, // disp_query
 108             null, // disp_message
 109             null, // query_type
 110             $sql_query, // sql_query
 111             null, // selectedTables
 112             null // complete_query
 113         );
 114     }
 115 }
 116
 117 $sub_part  = '_qbe';
 118 require 'libraries/db_common.inc.php';
 119 $url_query .= '&amp;goto=db_qbe.php';
 120 $url_params['goto'] = 'db_qbe.php';
 121
 122 list(
 123     $tables,
 124     $num_tables,
 125     $total_num_tables,
 126     $sub_part,
 127     $is_show_stats,
 128     $db_is_system_schema,
 129     $tooltip_truename,
 130     $tooltip_aliasname,
 131     $pos
 132 ) = PMA\libraries\Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
 133
 134 if ($message_to_display) {
 135     PMA\libraries\Message::error(__('You have to choose at least one column to display!'))
 136         ->display();
 137 }
 138 unset($message_to_display);
 139
 140 // create new qbe search instance
 141 $db_qbe = new PMA\libraries\DbQbe($GLOBALS['db'], $savedSearchList, $savedSearch);
 142
 143 $url = 'db_designer.php' . PMA_URL_getCommon(
 144     array_merge(
 145         $url_params,
 146         array('query' => 1)
 147     )
 148 );
 149 $response->addHTML(
 150     PMA\libraries\Message::notice(
 151         sprintf(
 152             __('Switch to %svisual builder%s'),
 153             '<a href="' . $url . '">',
 154             '</a>'
 155         )
 156     )
 157 );
 158
 159 /**
 160  * Displays the Query by example form
 161  */
 162 $response->addHTML($db_qbe->getSelectionForm());