diff options
Diffstat (limited to 'hugo/db_qbe.php')
| -rw-r--r-- | hugo/db_qbe.php | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/hugo/db_qbe.php b/hugo/db_qbe.php new file mode 100644 index 0000000..940758c --- /dev/null +++ b/hugo/db_qbe.php @@ -0,0 +1,68 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * query by example the whole database + * + * @package PhpMyAdmin + */ + +/** + * requirements + */ +require_once 'libraries/common.inc.php'; +require_once 'libraries/DBQbe.class.php'; +$response = PMA_Response::getInstance(); + +// Gets the relation settings +$cfgRelation = PMA_getRelationsParam(); + +/** + * A query has been submitted -> (maybe) execute it + */ +$message_to_display = false; +if (isset($_REQUEST['submit_sql']) && ! empty($sql_query)) { + if (! preg_match('@^SELECT@i', $sql_query)) { + $message_to_display = true; + } else { + $goto = 'db_sql.php'; + include 'sql.php'; + exit; + } +} + +$sub_part = '_qbe'; +require 'libraries/db_common.inc.php'; +$url_query .= '&goto=db_qbe.php'; +$url_params['goto'] = 'db_qbe.php'; +require 'libraries/db_info.inc.php'; + +if ($message_to_display) { + PMA_Message::error(__('You have to choose at least one column to display'))->display(); +} +unset($message_to_display); + +// create new qbe search instance +$db_qbe = new PMA_DBQbe($GLOBALS['db']); + +/** + * Displays the Query by example form + */ +if ($cfgRelation['designerwork']) { + $url = 'pmd_general.php' . PMA_generate_common_url( + array_merge( + $url_params, + array('query' => 1) + ) + ); + $response->addHTML( + PMA_Message::notice( + sprintf( + __('Switch to %svisual builder%s'), + '<a href="' . $url . '">', + '</a>' + ) + ) + ); +} +$response->addHTML($db_qbe->getSelectionForm($cfgRelation)); +?> |
