$rows = $datasource->getRows($start_row, $end_row);
// display the data
echo '<table border="1">';
echo '<tr>';
echo '<td> </td>';
echo '<td>' . $writer->getOrderByLink('id', 'Key') . '</td>';
echo '<td>' . $writer->getOrderByLink('text', 'Text') . '</td>';
echo '<td>' . $writer->getOrderByLink('sort', 'Sort') . '</td>';
echo '<td> </td>';
echo '</tr>';
$n = $start_row;
foreach ($rows as $row) {
echo '<tr>';
echo '<td>' . $n++ . '.</td>';
foreach ($row as $value) {
echo '<td>' . $value . '</td>';
}
echo '<td><a href="example_sub_page.php?script=' . basename($_SERVER['SCRIPT_NAME']) . '">Sub Page</a></td>';
echo '</tr>';
}
echo '</table>';
// display the paging links
echo $writer->getFirstLink() . ' | ' . $writer->getPrevLink() . ' | ' . implode(' | ', $writer->getRangeLinks()) . ' | ' . $writer->getNextLink() . ' | ' . $writer->getLastLink() . '<p/>';
echo 'Page Size: ' . $writer->getPageSizeLink(5) . ' | ' . $writer->getPageSizeLink(10) . '<p/>';
} else {
echo 'No records found.';
}
?>
<p/>
<a href="../">Return to Examples</a>
echo '<table border="1">';
foreach ($rows as $value) {
echo '<tr>';
echo '<td>' . $n++ . '.</td><td>' . $value . '</td>';
echo '</tr>';
}
echo '</table>';
echo $writer->getPrevLink() . ' | ' . implode(' | ', $writer->getRangeLinks()) . ' | ' . $writer->getNextLink() . '<p/>';
include 'A/Pager/HTMLWriterJump.php';
$jump = new A_Pager_HTMLWriterJump($pager);
$jump->setExtraParameters($writer2->getParameters($pager2->getCurrentPage()));
$jump->setCurrentPageTemplate('Now on page {current_page}!');
echo $jump->render();
echo '</td><td width="50"> </td><td valign="top">';
$rows = $datasource->getRows($start_row2, $end_row2);
$n = $start_row2;
#echo '<pre>' . print_r($rows, 1) . '</pre>';
echo '<table border="1">';
foreach ($rows as $value) {
echo '<tr>';
echo '<td>' . $n++ . '.</td><td>' . $value . '</td>';
echo '</tr>';
}
echo '</table>';
echo $writer2->getPrevLink() . ' | ' . implode(' | ', $writer2->getRangeLinks()) . ' | ' . $writer2->getNextLink() . '<p/>';
echo 'Rows per page: ' . $writer2->getPageSizeLink(5) . ' | ' . $writer2->getPageSizeLink(10) . '<p/>';
echo '</td></tr></table>';
?>
<p/>
<a href="../">Return to Examples</a>
