/**
* Test for PMA_getHTMLforEditingPage
*
* @return void
*/
public function testPMAGetHTMLforEditingPage()
{
$GLOBALS['dbi']->expects($this->any())->method('fetchResult')->with("SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin' AND col_name IN ('col1','col2');", null, null, $GLOBALS['controllink'])->will($this->returnValue($this->_columnData));
$result = PMA_getHTMLforEditingPage(array("col1", "col2"), 'phpmyadmin');
$this->assertContains('<form', $result);
$header_cells = array(__('Name'), __('Type'), __('Length/Values'), __('Default'), __('Collation'), __('Attributes'), __('Null'), __('A_I'));
$this->assertContains(PMA_getCentralColumnsEditTableHeader($header_cells), $result);
$list_detail_cols = PMA_findExistingColNames('phpmyadmin', "'col1','col2'", true);
$this->assertContains(PMA_getHTMLforCentralColumnsEditTableRow($list_detail_cols[0], false, 0), $result);
$this->assertContains(PMA_getCentralColumnsEditTableFooter(), $result);
}
/**
* Get HTML for editing page central columns
*
* @param array $selected_fld Array containing the selected fields
* @param string $selected_db String containing the name of database
*
* @return string HTML for complete editing page for central columns
*/
function PMA_getHTMLforEditingPage($selected_fld, $selected_db)
{
$html = '<form id="multi_edit_central_columns">';
$header_cells = array(__('Name'), __('Type'), __('Length/Values'), __('Default'), __('Collation'), __('Attributes'), __('Null'), __('A_I'));
$html .= PMA_getCentralColumnsEditTableHeader($header_cells);
$selected_fld_safe = array();
foreach ($selected_fld as $key) {
$selected_fld_safe[] = Util::sqlAddSlashes($key);
}
$columns_list = implode("','", $selected_fld_safe);
$columns_list = "'" . $columns_list . "'";
$list_detail_cols = PMA_findExistingColNames($selected_db, $columns_list, true);
$odd_row = false;
$row_num = 0;
foreach ($list_detail_cols as $row) {
$tableHtmlRow = PMA_getHTMLforCentralColumnsEditTableRow($row, $odd_row, $row_num);
$html .= $tableHtmlRow;
$odd_row = !$odd_row;
$row_num++;
}
$html .= '</table>';
$html .= PMA_getCentralColumnsEditTableFooter();
$html .= '</form>';
return $html;
}
