Server IP : 85.214.239.14 / Your IP : 3.138.33.201 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/self/root/var/www/wordpress/phpMyAdmin/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * query by example the whole database * * @package PhpMyAdmin */ declare(strict_types=1); use PhpMyAdmin\Database\Qbe; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Message; use PhpMyAdmin\Relation; use PhpMyAdmin\Response; use PhpMyAdmin\SavedSearches; use PhpMyAdmin\Sql; use PhpMyAdmin\Template; use PhpMyAdmin\Url; use PhpMyAdmin\Util; if (! defined('ROOT_PATH')) { define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR); } global $db, $pmaThemeImage, $url_query; require_once ROOT_PATH . 'libraries/common.inc.php'; /** @var Response $response */ $response = $containerBuilder->get(Response::class); /** @var DatabaseInterface $dbi */ $dbi = $containerBuilder->get(DatabaseInterface::class); /** @var Relation $relation */ $relation = $containerBuilder->get('relation'); /** @var Template $template */ $template = $containerBuilder->get('template'); // Gets the relation settings $cfgRelation = $relation->getRelationsParam(); $savedSearchList = []; $savedSearch = null; $currentSearchId = null; if ($cfgRelation['savedsearcheswork']) { $header = $response->getHeader(); $scripts = $header->getScripts(); $scripts->addFile('database/qbe.js'); //Get saved search list. $savedSearch = new SavedSearches($GLOBALS, $relation); $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) ->setDbname($db); if (! empty($_POST['searchId'])) { $savedSearch->setId($_POST['searchId']); } //Action field is sent. if (isset($_POST['action'])) { $savedSearch->setSearchName($_POST['searchName']); if ('create' === $_POST['action']) { $saveResult = $savedSearch->setId(null) ->setCriterias($_POST) ->save(); } elseif ('update' === $_POST['action']) { $saveResult = $savedSearch->setCriterias($_POST) ->save(); } elseif ('delete' === $_POST['action']) { $deleteResult = $savedSearch->delete(); //After deletion, reset search. $savedSearch = new SavedSearches($GLOBALS, $relation); $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) ->setDbname($db); $_POST = []; } elseif ('load' === $_POST['action']) { if (empty($_POST['searchId'])) { //when not loading a search, reset the object. $savedSearch = new SavedSearches($GLOBALS, $relation); $savedSearch->setUsername($GLOBALS['cfg']['Server']['user']) ->setDbname($db); $_POST = []; } else { $loadResult = $savedSearch->load(); } } //Else, it's an "update query" } $savedSearchList = $savedSearch->getList(); $currentSearchId = $savedSearch->getId(); } /** * A query has been submitted -> (maybe) execute it */ $message_to_display = false; if (isset($_POST['submit_sql']) && ! empty($sql_query)) { if (0 !== stripos($sql_query, "SELECT")) { $message_to_display = true; } else { $goto = 'db_sql.php'; $sql = new Sql(); $sql->executeQueryAndSendQueryResponse( null, // analyzed_sql_results false, // is_gotofile $_POST['db'], // db null, // table false, // find_real_end null, // sql_query_for_bookmark null, // extra_data null, // message_to_show null, // message null, // sql_data $goto, // goto $pmaThemeImage, // pmaThemeImage null, // disp_query null, // disp_message null, // query_type $sql_query, // sql_query null, // selectedTables null // complete_query ); } } $sub_part = '_qbe'; require ROOT_PATH . 'libraries/db_common.inc.php'; $url_query .= '&goto=db_qbe.php'; $url_params['goto'] = 'db_qbe.php'; list( $tables, $num_tables, $total_num_tables, $sub_part, $is_show_stats, $db_is_system_schema, $tooltip_truename, $tooltip_aliasname, $pos ) = Util::getDbInfo($db, $sub_part === null ? '' : $sub_part); if ($message_to_display) { 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 Qbe($relation, $template, $dbi, $db, $savedSearchList, $savedSearch); $secondaryTabs = [ 'multi' => [ 'link' => 'db_multi_table_query.php', 'text' => __('Multi-table query'), ], 'qbe' => [ 'link' => 'db_qbe.php', 'text' => __('Query by example'), ], ]; $response->addHTML( $template->render('secondary_tabs', [ 'url_params' => $url_params, 'sub_tabs' => $secondaryTabs, ]) ); $url = 'db_designer.php' . Url::getCommon( array_merge( $url_params, ['query' => 1] ) ); $response->addHTML( Message::notice( sprintf( __('Switch to %svisual builder%s'), '<a href="' . $url . '">', '</a>' ) ) ); /** * Displays the Query by example form */ $response->addHTML($db_qbe->getSelectionForm());