/** * Test for PMA_getColumnsList * * @return void */ public function testPMAGetColumnsList() { $GLOBALS['dbi']->expects($this->at(1))->method('fetchResult')->with("SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin' LIMIT 0, 25;", null, null, $GLOBALS['controllink'])->will($this->returnValue($this->_columnData)); $GLOBALS['dbi']->expects($this->at(3))->method('fetchResult')->with("SELECT * FROM `pma_central_columns` " . "WHERE db_name = 'phpmyadmin' LIMIT 1, 2;", null, null, $GLOBALS['controllink'])->will($this->returnValue(array_slice($this->_columnData, 1, 2))); $this->assertEquals($this->_modifiedColumnData, PMA_getColumnsList('phpmyadmin')); $this->assertEquals(array_slice($this->_modifiedColumnData, 1, 2), PMA_getColumnsList('phpmyadmin', 1, 2)); }
/** * Test for PMA_getColumnsList * * @return void */ public function testPMAGetColumnsList() { $GLOBALS['dbi']->expects($this->exactly(2))->method('fetchResult')->willReturnOnConsecutiveCalls($this->_columnData, array_slice($this->_columnData, 1, 2)); $this->assertEquals($this->_modifiedColumnData, PMA_getColumnsList('phpmyadmin')); $this->assertEquals(array_slice($this->_modifiedColumnData, 1, 2), PMA_getColumnsList('phpmyadmin', 1, 2)); }
$response->addHTML('<fieldset>' . __('The central list of columns for the current database is empty.') . '</fieldset>'); $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_getColumnsList * * @return void */ public function testPMAGetColumnsList() { $this->assertEquals(array("id", "col1"), PMA_getColumnsList('phpmyadmin')); $this->assertEquals(array("id", "col1"), PMA_getColumnsList('phpmyadmin', 0, 0)); }