function listing($locator)
{
$usersession = $locator->get('UserSession');
$db = $locator->get('Db');
$template = $this->_load('controller')->template('listing');
// create a data object that has the interface needed by the Pager object
$datasource = new A_Pagination_Adapter_Db($db, "SELECT * FROM `blog_posts` WHERE post_type='post'");
// create a request processor to set pager from GET parameters
$pager = new A_Pagination_Request($datasource);
// initialize using values from $_GET
$pager->process($locator->get('Request'));
// create a "standard" view object to create pagination links
$view = new A_Pagination_View_Standard($pager);
$rows = $pager->getItems();
$template->set('rows', $rows);
$template->set('links', $view->render());
// display the pagination links
$this->response->set('maincontent', $template->render());
}
$myarray[$i]['title'] = 'This is row ' . $i;
$myarray[$i]['month'] = date('F', time() + $i * 60 * 60 * 24 * 30);
}
#$myarray = null;
// create a data object that has the interface needed by the Pager object
$datasource = new Datasource($myarray);
// create a request processor to set pager from GET parameters
$pager = new A_Pagination_Request($datasource);
// set range (number of links on either side of current page) and process core based on request
$pager->setRangeSize(3)->process();
// create a new link helper
$link = new A_Pagination_Helper_Link($pager);
// create a new order link helper
$order = new A_Pagination_Helper_Order($pager, $url, array('' => 'Row', 'title' => 'Title', 'month' => 'Month'));
// retrieve items on current page
$rows = $pager->getItems();
// display the paging links ... should this go in a template?
$links = '';
$links .= $link->first('First');
$links .= $link->previous('Previous');
$links .= $link->range();
$links .= $link->next('Next');
$links .= $link->last('Last');
// display the data
echo "<div>{$links}</div>";
echo '<table border="1">';
echo '<tr><th>' . $order->render() . '</th></tr>';
$n = 1;
foreach ($rows as $value) {
echo '<tr>';
echo '<td>' . $n++ . '.</td><td>' . $value['title'] . '</td><td>' . $value['month'] . '</td>';
