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