$columnAdd = PMA_getHTMLforAddCentralColumn($total_rows, $pos, $db);
$response->addHTML($columnAdd);
exit;
}
$table_navigation_html = PMA_getHTMLforTableNavigation($total_rows, $pos, $db);
$response->addHTML($table_navigation_html);
$columnAdd = PMA_getHTMLforAddCentralColumn($total_rows, $pos, $db);
$response->addHTML($columnAdd);
$deleteRowForm = '<form method="post" id="del_form" action="db_central_columns.php">' . PMA_URL_getHiddenInputs($db) . '<input id="del_col_name" type="hidden" name="col_name" value="">' . '<input type="hidden" name="pos" value="' . $pos . '">' . '<input type="hidden" name="delete_save" value="delete"></form>';
$response->addHTML($deleteRowForm);
$table_struct = '<div id="tableslistcontainer">' . '<form name="tableslistcontainer">' . '<table id="table_columns" class="tablesorter" ' . 'style="min-width:100%" class="data">';
$response->addHTML($table_struct);
$tableheader = PMA_getCentralColumnsTableHeader('column_heading', __('Click to sort.'), 2);
$response->addHTML($tableheader);
$result = PMA_getColumnsList($db, $pos, $max_rows);
$odd_row = true;
$row_num = 0;
foreach ($result as $row) {
$tableHtmlRow = PMA_getHTMLforCentralColumnsTableRow($row, $odd_row, $row_num, $db);
$response->addHTML($tableHtmlRow);
$odd_row = !$odd_row;
$row_num++;
}
$response->addHTML('</table>');
$tablefooter = PMA_getCentralColumnsTableFooter($pmaThemeImage, $text_dir);
$response->addHTML($tablefooter);
$response->addHTML('</form></div>');
$message = PMA_Message::success(sprintf(__('Showing rows %1$s - %2$s.'), $pos + 1, $pos + count($result)));
if (isset($tmp_msg) && $tmp_msg !== true) {
$message = $tmp_msg;
}
/**
* Test for PMA_getHTMLforCentralColumnsTableRow
*
* @return void
*/
public function testPMAGetHTMLforCentralColumnsTableRow()
{
$row = array('col_name' => 'col_test', 'col_type' => 'int', 'col_length' => 12, 'col_collation' => 'utf8_general_ci', 'col_isNull' => 1, 'col_extra' => '', 'col_attribute' => '');
$result = PMA_getHTMLforCentralColumnsTableRow($row, false, 1, 'phpmyadmin');
$this->assertContains('<tr', $result);
$this->assertContains(PMA_URL_getHiddenInputs('phpmyadmin'), $result);
$this->assertContains('<span', $result);
$this->assertContains('col_test', $result);
$this->assertContains(__('on update CURRENT_TIMESTAMP'), $result);
$this->assertContains(PMA_getHtmlForColumnDefault(1, 6, 0, mb_strtoupper($row['col_type']), '', array('DefaultType' => 'NONE')), $result);
$row['col_default'] = 100;
$result_1 = PMA_getHTMLforCentralColumnsTableRow($row, false, 1, 'phpmyadmin');
$this->assertContains(PMA_getHtmlForColumnDefault(1, 6, 0, mb_strtoupper($row['col_type']), '', array('DefaultType' => 'USER_DEFINED', 'DefaultValue' => 100)), $result_1);
$row['col_default'] = 'CURRENT_TIMESTAMP';
$result_2 = PMA_getHTMLforCentralColumnsTableRow($row, false, 1, 'phpmyadmin');
$this->assertContains(PMA_getHtmlForColumnDefault(1, 6, 0, mb_strtoupper($row['col_type']), '', array('DefaultType' => 'CURRENT_TIMESTAMP')), $result_2);
}
/**
* Test for PMA_getHTMLforCentralColumnsTableRow
*
* @return void
*/
public function testPMAGetHTMLforCentralColumnsTableRow()
{
/** @var PMA_String $pmaString */
$pmaString = $GLOBALS['PMA_String'];
$row = array('col_name' => 'col_test', 'col_type' => 'int', 'col_length' => 12, 'col_collation' => 'utf8_general_ci', 'col_isNull' => 1, 'col_extra' => '');
$result = PMA_getHTMLforCentralColumnsTableRow($row, false, 1, 'phpmyadmin');
$this->assertTag(array('tag' => 'tr'), $result);
$this->assertContains(PMA_URL_getHiddenInputs('phpmyadmin'), $result);
$this->assertTag(array('tag' => 'span', 'content' => 'col_test'), $result);
$this->assertContains(__('on update CURRENT_TIMESTAMP'), $result);
$this->assertContains(PMA_getHtmlForColumnDefault(1, 5, 0, $pmaString->strtoupper($row['col_type']), '', array('DefaultType' => 'NONE')), $result);
$row['col_default'] = 100;
$result_1 = PMA_getHTMLforCentralColumnsTableRow($row, false, 1, 'phpmyadmin');
$this->assertContains(PMA_getHtmlForColumnDefault(1, 5, 0, $pmaString->strtoupper($row['col_type']), '', array('DefaultType' => 'USER_DEFINED', 'DefaultValue' => 100)), $result_1);
$row['col_default'] = 'CURRENT_TIMESTAMP';
$result_2 = PMA_getHTMLforCentralColumnsTableRow($row, false, 1, 'phpmyadmin');
$this->assertContains(PMA_getHtmlForColumnDefault(1, 5, 0, $pmaString->strtoupper($row['col_type']), '', array('DefaultType' => 'CURRENT_TIMESTAMP')), $result_2);
}
