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