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