Buiding pagnation? Probs

[brianb]

Hello,

I'm querying my DB for a number of records, then printing those records based on some limiting to display a certain number of records per page.

I'm having an issue though...

When my page navigation starts to build beyond 18 pages it starts making the table the page numbers are being built in to go beyond my table dimensions, causing the design to break apart....

So, what I need to do is to build the pagnation into another row once it hits 18, but I'm having some issues doing so.

Maybe someone can give me some advice?

Here's my pagnation code as it is...

//==================================
// START PAGE LIST
//================================== 

$pagelist .= "<table cellpadding=4 cellspacing=0 border=2 bordercolor='#FFFFFF' bgcolor='#F0F0F0' class='table_thin' align='center'><tr>";

//Build PREVIOUS Link
if($page > 1) {
	$prev = ($page - 1);
	$pagelist .= "<td><a href='".$PHP_SELF."?page=$prev' class='main3'><< Previous Page</a></td>";
	}

//Build Pagnation
for($i = 1; $i <= $total_pages; $i++) {
	if(($page) == $i) {
	$pagelist .= "<td><span class='main4'>$i</span></td>";
	} else {
	$pagelist .= "<td><a href='".$PHP_SELF."?w=$yearWeek&page=$i' class='main3'>$i</a></td>";
	}
}

//Build NEXT link
if($page < $total_pages) {
	$next = ($page + 1);
	$pagelist .= "<td><a href='".$PHP_SELF."?w=$yearWeek&page=$next' class='main3'>Next Page >></a></td>";
}

$pagelist .= "</tr></table>";

//==================================
// END PAGE LIST
//==================================

All help is appreciated!

Thanks in advance!

[tekky]

limit your page options to 18, using your for loop....

like here you dont have 1 -> 98 if there are 98 pages... you get something more along the lines of (assuming we are on page 5)

<< 4 [ 5 ] 6 7 8 9 10 >>

<< being to first page, and >> being to last page

[sidney]

or put a </tr><tr> after 18 page links

eg

 //Build Pagnation 
for($i = 1; $i <= $total_pages; $i++) { 
    if($i%18==1){$pagelist .="</tr><tr>";}
    if(($page) == $i) { 
    $pagelist .= "<td><span class='main4'>$i</span></td>"; 
    } else { 
    $pagelist .= "<td><a href='".$PHP_SELF."?w=yearWeek&page=$i' class='main3'>$i</a></td>"; 
    } 
}  

[onion2k]

function paging($baseUrl,$page,$total,$records_per_page) {

$page = ($page < 1) ? 1 : $page;
$page = ($page > ceil($total/$records_per_page)) ? ceil($total/$records_per_page) : $page;
$prevnext[] = "<a href=\"".$baseUrl."?page=".($page-1)."\">Prev</a>";

$start = ($page <= 2) ? 1 : (($page > ceil($total/$records_per_page)-2) ? ceil($total/$records_per_page)-((ceil($total/$records_per_page)>=5) ? 4 : ceil($total/$records_per_page)-1 ) : $page-2) ;
$end = (ceil($total/$records_per_page) >= 5) ? $start+4 : ceil($total/$records_per_page);

for ($x=$start;$x<=$end;$x++) {
	$prevnext[] = ($page == $x) ? "<b>".$x."</b>" : "<a href=\"".$baseUrl."?page=".$x."\">".$x."</a>";
}

$prevnext[] = "<a href=\"".$baseUrl."?page=".($page+1)."\">Next</a>";
return implode("&nbsp;&nbsp;|&nbsp;&nbsp;",$prevnext);

}

//echo paging("index.php",$page,10,5);

Usage: echo paging(<url>,$page,<total records>,<records to show paging options for>);

Save it into index.php and uncomment the comment for an example.

Variable names are a proper mess, but it works..