Method to output the page selector links when returning query results in pages.
Class: bb_main, called as $main
File: bb_main.php (php)
function page_selector($element, $offset, $count_rows, $return_rows, $pagination)
$main->page_selector($element, $offset, $count_rows, $return_rows, $pagination);
Outputs: Page selection navigation links along the bottom of a page returning records.
Note: This method requires a form variable in the required form of the module passed as
The offset variable represents the page of the query to be returned. The lower limit of the query is calculated from this value and is used in the
The total rows returned by the query without
OFFSET, found using
count(*) OVER () as cnt in the SQL query.
The number of rows in a page, based on constant
RETURN_ROWS and used in LIMIT clause of the query.
The number of pages displayed in the page selector, based on the constant