Page Numbering Help Plz

[stebut05]

Hi all,

Need some help please on page numbering for query results. Really apreciate help, advice and suggestions given, thanks.

Regards,

Steven

[maxpup979]

are you talking about having a query get results 1-10, then 11-20 etc?

[stebut05]

Hi,

I have done the paging to show how many records per page and i have a next page, previous page etc. But i want to have page numbering

eg <<Previous 1 2 3 4 5 >> Next

Regards,

Steven

[jara06]

quite easy actually.

a quick sloppy example .. but imagine this:

function showPageNumbers()
{
	if (isset($_GET['p'])) {
		$page = (int) $_GET['p'];
	}
	else {
		$page = 1;
	]

$number_of_posts	= 100;  //  could be a count from a db or something
$posts_pr_page		= 9;  // just to do it 'tricky'
$total_pages 		= floor($number_of_posts / $posts_pr_page); // round up

if ($p > $total_pages) {
	$p = $total_pages;
}
else if ($p <= 0) {
	$p = 1;
}

//$start_post			= (($p - 1) * $posts_pr_page) + 1;
//$end_post			= $start_post + $p;
$prev = $p - 1;
$next = $p + 1;

echo "<a href=\"". $_SERVER['PHP_SELF'] ."?p=". $prev ."\"> << </a>";
for ($i = 1; $i <= $total_pages; $i++)
[
	if ($page == $i) {
		echo "<a href=\"". $_SERVER['PHP_SELF'] ."?p=". $i ."\"><b>". $i ."</b></a>";
	}
	else {
		echo "<a href=\"". $_SERVER['PHP_SELF'] ."?p=". $i ."\">". $i ."</a>";
	}
}
echo "<a href=\"". $_SERVER['PHP_SELF'] ."?p=". $next ."\"> << </a>";
}

whenever you need the pagelist just use

showPageNumbers();