$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); }