/**
  * Tests for PMA_getHtmlForSelectableTables() method.
  *
  * @return void
  * @test
  */
 public function testPMAGetHtmlForSelectableTables()
 {
     $selectable_tables_sql_result = true;
     $url_query = "select * from PMA";
     $dbi_old = $GLOBALS['dbi'];
     $dbi = $this->getMockBuilder('PMA_DatabaseInterface')->disableOriginalConstructor()->getMock();
     $fetchArray = array('tracking_active' => 1, 'version' => "10", 'db_name' => 'db_name', 'table_name' => 'table_name', 'date_created' => 'date_created', 'date_updated' => 'date_updated');
     $dbi->expects($this->at(0))->method('fetchArray')->will($this->returnValue($fetchArray));
     $dbi->expects($this->at(1))->method('fetchArray')->will($this->returnValue($fetchArray));
     $dbi->expects($this->at(2))->method('fetchArray')->will($this->returnValue(false));
     $GLOBALS['dbi'] = $dbi;
     $ret = PMA_getHtmlForSelectableTables($selectable_tables_sql_result, $url_query);
     $this->assertContains(htmlspecialchars($fetchArray['table_name']), $ret);
     $this->assertContains(htmlspecialchars($fetchArray['db_name']), $ret);
     //restore DBI
     $GLOBALS['dbi'] = $dbi_old;
 }
示例#2
0
if (isset($_REQUEST['report']) || isset($_REQUEST['report_export'])) {
    $html .= PMA_getHtmlForTrackingReport(
        $url_query, $data, $url_params, $selection_schema, $selection_data,
        $selection_both, $filter_ts_to, $filter_ts_from, $filter_users
    );
} // end of report


/*
 * List selectable tables
 */
$selectable_tables_sql_result = PMA_getSQLResultForSelectableTables();
if ($GLOBALS['dbi']->numRows($selectable_tables_sql_result) > 0) {
    $html .= PMA_getHtmlForSelectableTables(
        $selectable_tables_sql_result, $url_query
    );
}
$html .= '<br />';

/*
 * List versions of current table
 */
$sql_result = PMA_getListOfVersionsOfTable();
$last_version = PMA_getTableLastVersionNumber($sql_result);
if ($last_version > 0) {
    $html .= PMA_getHtmlForTableVersionDetails(
        $sql_result, $last_version, $url_params,
        $url_query, $pmaThemeImage, $text_dir
    );
}