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 PhpMyAdmin\Database\Qbe;
   9 use PhpMyAdmin\Message;
  10 use PhpMyAdmin\Relation;
  11 use PhpMyAdmin\Response;
  12 use PhpMyAdmin\SavedSearches;
  13 use PhpMyAdmin\Sql;
  14 use PhpMyAdmin\Url;
  15 use PhpMyAdmin\Util;
  16
  17 /**
  18  * requirements
  19  */
  20 require_once 'libraries/common.inc.php';
  21
  22 $response = Response::getInstance();
  23
  24 // Gets the relation settings
  25 $cfgRelation = Relation::getRelationsParam();
  26
  27 $savedSearchList = array();
  28 $savedSearch = null;
  29 $currentSearchId = null;
  30 if ($cfgRelation['savedsearcheswork']) {
  31     $header = $response->getHeader();
  32     $scripts = $header->getScripts();
  33     $scripts->addFile('db_qbe.js');
  34
  35     //Get saved search list.
  36     $savedSearch = new SavedSearches($GLOBALS);
  37     $savedSearch->setUsername($GLOBALS['cfg']['Server']['user'])
  38         ->setDbname($_REQUEST['db']);
  39
  40     if (!empty($_REQUEST['searchId'])) {
  41         $savedSearch->setId($_REQUEST['searchId']);
  42     }
  43
  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)
  50                 ->save();
  51         } elseif ('update' === $_REQUEST['action']) {
  52             $saveResult = $savedSearch->setCriterias($_REQUEST)
  53                 ->save();
  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']);
  60             $_REQUEST = array();
  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']);
  67                 $_REQUEST = array();
  68             } else {
  69                 $loadResult = $savedSearch->load();
  70             }
  71         }
  72         //Else, it's an "update query"
  73     }
  74
  75     $savedSearchList = $savedSearch->getList();
  76     $currentSearchId = $savedSearch->getId();
  77 }
  78
  79 /**
  80  * A query has been submitted -> (maybe) execute it
  81  */
  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;
  86     } else {
  87         $goto = 'db_sql.php';
  88         Sql::executeQueryAndSendQueryResponse(
  89             null, // analyzed_sql_results
  90             false, // is_gotofile
  91             $_REQUEST['db'], // db
  92             null, // table
  93             false, // find_real_end
  94             null, // sql_query_for_bookmark
  95             null, // extra_data
  96             null, // message_to_show
  97             null, // message
  98             null, // sql_data
  99             $goto, // goto
 100             $pmaThemeImage, // pmaThemeImage
 101             null, // disp_query
 102             null, // disp_message
 103             null, // query_type
 104             $sql_query, // sql_query
 105             null, // selectedTables
 106             null // complete_query
 107         );
 108     }
 109 }
 110
 111 $sub_part  = '_qbe';
 112 require 'libraries/db_common.inc.php';
 113 $url_query .= '&amp;goto=db_qbe.php';
 114 $url_params['goto'] = 'db_qbe.php';
 115
 116 list(
 117     $tables,
 118     $num_tables,
 119     $total_num_tables,
 120     $sub_part,
 121     $is_show_stats,
 122     $db_is_system_schema,
 123     $tooltip_truename,
 124     $tooltip_aliasname,
 125     $pos
 126 ) = Util::getDbInfo($db, isset($sub_part) ? $sub_part : '');
 127
 128 if ($message_to_display) {
 129     Message::error(
 130         __('You have to choose at least one column to display!')
 131     )
 132         ->display();
 133 }
 134 unset($message_to_display);
 135
 136 // create new qbe search instance
 137 $db_qbe = new Qbe($GLOBALS['db'], $savedSearchList, $savedSearch);
 138
 139 $url = 'db_designer.php' . Url::getCommon(
 140     array_merge(
 141         $url_params,
 142         array('query' => 1)
 143     )
 144 );
 145 $response->addHTML(
 146     Message::notice(
 147         sprintf(
 148             __('Switch to %svisual builder%s'),
 149             '<a href="' . $url . '">',
 150             '</a>'
 151         )
 152     )
 153 );
 154
 155 /**
 156  * Displays the Query by example form
 157  */
 158 $response->addHTML($db_qbe->getSelectionForm());