示例#1
0
if (PMA_DRIZZLE) {
    $server_master_status = false;
    $server_slave_status = false;
} else {
    include_once 'libraries/replication.inc.php';
    include_once 'libraries/replication_gui.lib.php';
}
/**
 * flush status variables if requested
 */
if (isset($_REQUEST['flush'])) {
    $_flush_commands = array('STATUS', 'TABLES', 'QUERY CACHE');
    if (in_array($_REQUEST['flush'], $_flush_commands)) {
        $GLOBALS['dbi']->query('FLUSH ' . $_REQUEST['flush'] . ';');
    }
    unset($_flush_commands);
}
$ServerStatusData = new PMA_ServerStatusData();
$response = PMA_Response::getInstance();
$header = $response->getHeader();
$scripts = $header->getScripts();
$scripts->addFile('server_status_variables.js');
$scripts->addFile('jquery/jquery.tablesorter.js');
$scripts->addFile('server_status_sorter.js');
$response->addHTML('<div>');
$response->addHTML($ServerStatusData->getMenuHtml());
$response->addHTML(PMA_getHtmlForFilter($ServerStatusData));
$response->addHTML(PMA_getHtmlForLinkSuggestions($ServerStatusData));
$response->addHTML(PMA_getHtmlForVariablesList($ServerStatusData));
$response->addHTML('</div>');
exit;
 /**
  * Test for PMA_getHtmlForVariablesList
  *
  * @return void
  * @group medium
  */
 public function testPMAGetHtmlForVariablesList()
 {
     //Call the test function
     $html = PMA_getHtmlForVariablesList($this->ServerStatusData);
     //validate 1: PMA_getHtmlForVariablesList
     $table = '<table class="data noclick" ' . 'id="serverstatusvariables">';
     $this->assertContains($table, $html);
     $this->assertContains('<th>Variable</th>', $html);
     $this->assertContains('<th>Value</th>', $html);
     $this->assertContains('<th>Description</th>', $html);
     //validate 3:Items
     $this->assertContains('<th class="name">Aborted clients', $html);
     $this->assertContains('<span class="allfine">0</span>', $html);
     $this->assertContains('<th class="name">Aborted connects', $html);
     $this->assertContains('<th class="name">Com delete multi', $html);
     $this->assertContains('<th class="name">Com create function', $html);
     $this->assertContains('<th class="name">Com empty query', $html);
 }