/** * Displays the sub-page heading */ $doc_link = PMA_Util::showMySQLDocu('server_system_variables'); $response->addHtml(PMA_getHtmlForSubPageHeader('variables', $doc_link)); /** * Sends the queries and buffers the results */ $serverVarsResult = $GLOBALS['dbi']->tryQuery('SHOW SESSION VARIABLES;'); if ($serverVarsResult !== false) { $serverVarsSession = array(); while ($arr = $GLOBALS['dbi']->fetchRow($serverVarsResult)) { $serverVarsSession[$arr[0]] = $arr[1]; } $GLOBALS['dbi']->freeResult($serverVarsResult); $serverVars = $GLOBALS['dbi']->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1); /** * Link templates */ $response->addHtml(PMA_getHtmlForLinkTemplates()); /** * Displays the page */ $response->addHtml(PMA_getHtmlForServerVariables($variable_doc_links, $serverVars, $serverVarsSession)); } else { /** * Display the error message */ $response->addHTML(PMA_Message::error(sprintf(__('Not enough privilege to view server variables and settings. %s'), PMA_Util::showMySQLDocu('server-system-variables', false, 'sysvar_show_compatibility_56')))->getDisplay()); } exit;
*/ $variable_doc_links = PMA_getArrayForDocumentLinks(); /** * Ajax request */ if (isset($_REQUEST['ajax_request']) && $_REQUEST['ajax_request'] == true) { if (isset($_REQUEST['type'])) { if ($_REQUEST['type'] === 'getval') { PMA_getAjaxReturnForGetVal($variable_doc_links); } else { if ($_REQUEST['type'] === 'setval') { PMA_getAjaxReturnForSetVal($variable_doc_links); } } exit; } } /** * Displays the sub-page heading */ $doc_link = PMA_Util::showMySQLDocu('server_system_variables'); $response->addHtml(PMA_getHtmlForSubPageHeader('variables', $doc_link)); /** * Link templates */ $response->addHtml(PMA_getHtmlForLinkTemplates()); /** * Displays the page */ $response->addHtml(PMA_getHtmlForServerVariables($variable_doc_links)); exit;
/** * Test for PMA_getHtmlForServerVariables * * @return void */ public function testPMAGetHtmlForServerVariables() { //Call the test function $_REQUEST['filter'] = "auto-commit"; $variable_doc_links = PMA_getArrayForDocumentLinks(); $html = PMA_getHtmlForServerVariables($variable_doc_links); //validate 1: Filters $this->assertContains( '<legend>' . __('Filters') . '</legend>', $html ); $this->assertContains( __('Containing the word:'), $html ); $this->assertContains( $_REQUEST['filter'], $html ); //validate 2: Server Variables $this->assertContains( '<div id="serverVariables" class="data filteredData noclick">', $html ); $this->assertContains( __('Variable'), $html ); $this->assertContains( __('Global value'), $html ); }
/** * Test for PMA_getHtmlForServerVariables * * @return void */ public function testPMAGetHtmlForServerVariables() { //Call the test function $_REQUEST['filter'] = "auto-commit"; $variable_doc_links = PMA_getArrayForDocumentLinks(); $serverVarsSession = $GLOBALS['dbi']->fetchResult('SHOW SESSION VARIABLES;', 0, 1); $serverVars = $GLOBALS['dbi']->fetchResult('SHOW GLOBAL VARIABLES;', 0, 1); $html = PMA_getHtmlForServerVariables($variable_doc_links, $serverVars, $serverVarsSession); //validate 1: Filters $this->assertContains('<legend>' . __('Filters') . '</legend>', $html); $this->assertContains(__('Containing the word:'), $html); $this->assertContains($_REQUEST['filter'], $html); //validate 2: Server Variables $this->assertContains('<table id="serverVariables" class="data filteredData noclick">', $html); $this->assertContains(__('Variable'), $html); $this->assertContains(__('Global value'), $html); }