Posted By

kendsnyder on 01/18/11

Tagged

sql
html

Versions (?)

Last Edited at 01/18/11 04:31am

Statistics

Viewed 660 times

Favorited by 0 user(s)

Related snippets

SQL results pager HTML

/ Published in: PHP

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function getResultPaging($perPage, $currPage, $total) {
	$paging = new stdClass;
 
	// get text
	$startRec = ($perPage * ($currPage - 1)) + 1;
	$endRec = min($total, $perPage * $currPage);
	$totalPages = ceil($total / $perPage);
	$paging->text = "Viewing records $startRec&ndash;$endRec of $total";
	$paging->links = array();
 
	// do we have a search string to append to each paging link?
	if (($searchName = trim(@$_REQUEST['search']))) {
		$searchString = "&amp;search=" . rawurlencode($searchName);
	}
	else {
		$searchString = '';
	}
	$_SESSION['last-search'] = '?page=' . $currPage . $searchString;
 
	// get pages that should be listed
	if ($currPage > 5 && $totalPages > 10) {
		$posFromLast = $totalPages - $currPage;
		if ($posFromLast >= 5) {
			$pages = range($currPage - 4, $currPage + 5);
		}
		else {
			$pages = range($currPage - 9 + $posFromLast, $totalPages);
		}
	}
	else {
		$pages = range(1, $totalPages > 10 ? 10 : $totalPages);
	}
 
	// prev link
	$paging->links[] = $currPage > 1 ?
		'<a class="item prev-next prev" href="?page='.($currPage-1).$searchString.'"><span class="quo">&laquo;</span> Prev</a>' :
		'<span class="item prev-next prev inactive"><span class="quo">&laquo;</span> Prev</span>';
 
	if ($pages[0] != 1) {
		$paging->links[] = '<span class="item elipses">...</span>';
	}
 
	// regular links
	foreach ($pages as $page) {
		$paging->links[] = $currPage == $page ?
			'<span class="item inactive current">'.$page.'</span>' :
			'<a class="item" href="?page='.$page.$searchString.'">'.$page.'</a>';
	}
 
	if ($pages[count($pages) - 1] != $totalPages) {
		$paging->links[] = '<span class="item elipses">...</span>';
	}
 
	// next link
	$paging->links[] = $currPage < $totalPages ?
		'<a class="item prev-next prev" href="?page='.($currPage+1).$searchString.'">Next <span class="quo">&raquo;</span></a>' :
		'<span class="item prev-next prev inactive">Next <span class="quo">&raquo;</span></span>';
 
	return $paging;
}