$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>