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
   9 /**
  10  * requirements
  11  */
  12 require_once 'libraries/common.inc.php';
  13 require_once 'libraries/DBQbe.class.php';
  14 require_once 'libraries/bookmark.lib.php';
  15 require_once 'libraries/sql.lib.php';
  16
  17 $response = PMA_Response::getInstance();
  18
  19 // Gets the relation settings
  20 $cfgRelation = PMA_getRelationsParam();
  21
  22 /**
  23  * A query has been submitted -> (maybe) execute it
  24  */
  25 $message_to_display = false;
  26 if (isset($_REQUEST['submit_sql']) && ! empty($sql_query)) {
  27     if (! preg_match('@^SELECT@i', $sql_query)) {
  28         $message_to_display = true;
  29     } else {
  30         $goto      = 'db_sql.php';
  31
  32         // Parse and analyze the query
  33         include_once 'libraries/parse_analyze.inc.php';
  34
  35         PMA_executeQueryAndSendQueryResponse(
  36             $analyzed_sql_results, false, $_REQUEST['db'], null, null, null, null,
  37             false, null, null, null, null, $goto, $pmaThemeImage, null, null, null,
  38             $sql_query, null, null
  39         );
  40     }
  41 }
  42
  43 $sub_part  = '_qbe';
  44 require 'libraries/db_common.inc.php';
  45 $url_query .= '&amp;goto=db_qbe.php';
  46 $url_params['goto'] = 'db_qbe.php';
  47 require 'libraries/db_info.inc.php';
  48
  49 if ($message_to_display) {
  50     PMA_Message::error(__('You have to choose at least one column to display'))->display();
  51 }
  52 unset($message_to_display);
  53
  54 // create new qbe search instance
  55 $db_qbe = new PMA_DBQbe($GLOBALS['db']);
  56
  57 /**
  58  * Displays the Query by example form
  59  */
  60 if ($cfgRelation['designerwork']) {
  61     $url = 'pmd_general.php' . PMA_URL_getCommon(
  62         array_merge(
  63             $url_params,
  64             array('query' => 1)
  65         )
  66     );
  67     $response->addHTML(
  68         PMA_Message::notice(
  69             sprintf(
  70                 __('Switch to %svisual builder%s'),
  71                 '<a href="' . $url . '">',
  72                 '</a>'
  73             )
  74         )
  75     );
  76 }
  77 $response->addHTML($db_qbe->getSelectionForm($cfgRelation));
  78 ?>