/**
 * 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);
 }