2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * query by example the whole database
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';
17 $response = PMA_Response
::getInstance();
19 // Gets the relation settings
20 $cfgRelation = PMA_getRelationsParam();
23 * A query has been submitted -> (maybe) execute it
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;
32 // Parse and analyze the query
33 include_once 'libraries/parse_analyze.inc.php';
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
44 require 'libraries/db_common.inc.php';
45 $url_query .= '&goto=db_qbe.php';
46 $url_params['goto'] = 'db_qbe.php';
47 require 'libraries/db_info.inc.php';
49 if ($message_to_display) {
50 PMA_Message
::error(__('You have to choose at least one column to display'))->display();
52 unset($message_to_display);
54 // create new qbe search instance
55 $db_qbe = new PMA_DBQbe($GLOBALS['db']);
58 * Displays the Query by example form
60 if ($cfgRelation['designerwork']) {
61 $url = 'pmd_general.php' . PMA_URL_getCommon(
70 __('Switch to %svisual builder%s'),
71 '<a href="' . $url . '">',
77 $response->addHTML($db_qbe->getSelectionForm($cfgRelation));