help with pagination function

[andreea115]

hello everyone.

I have a pagination function below. the function works perfectly.

The problem, however , is that some of my search results have over 200 pages. i therefore need to find a way to refine my function so that it only shows the page numbers for the first 10 pages and then skips to the last 10 pages.

i am however unclear how to go about doing this.

the page pagination is below

// Number of records to show per page:
	$display = 9;

// Determine how many pages there are...
if (isset($_GET['p']) && is_numeric($_GET['p'])) { // Already been determined.

	$pages = $_GET['p'];


} else { // Need to determine.





// Count the number of records:

$q = "SELECT COUNT(membership_type) FROM users
	       WHERE
	       membership_type= 'travellers' ";

$detailedview = @mysqli_query ($dbc, $q);
$row = @mysqli_fetch_array ($detailedview, MYSQLI_NUM);
$records = $row[0];
     //echo $records;


// Calculate the number of pages...
if ($records > $display) { // More than 1 page.
	$pages = ceil ($records/$display);
} else {
	$pages = 1;
}

} // End of p IF.

// Determine where in the database to start returning results...
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
	$start = $_GET['s'];
} else {
	$start = 0;
}




// Make the links to other pages, if necessary.
if ($pages > 1) {

// Add some spacing and start a paragraph:
echo '<br /><p>';

// Determine what page the script is on:	
$current_page = ($start/$display) + 1;

// If it's not the first page, make a Previous button:
if ($current_page != 1) {
	echo '<a href="index.php?view=view&s=' . ($start - $display) . '&p=' . $pages . '">Previous</a> ';
}

// Make all the numbered pages:
for ($i = 1; $i <= $pages; $i++) {
	if ($i != $current_page) {
		echo '<a href="index.php?view=view&s=' . (($display * ($i - 1))) . '&p=' . $pages . '">' . $i . '</a> ';
	} else {
		echo $i . ' ';
	}
} // End of FOR loop.

// If it's not the last page, make a Next button:
if ($current_page != $pages) {
	echo '<a href="index.php?view=view&s=' . ($start + $display) . '&p=' . $pages . '">Next</a>';
}

echo '</p>'; // Close the paragraph.

} // End of links section.

thank you for your help

warm regards

Andreea

[dagon]

having answered this 10 million times before, im just going to post one of my pagination functions that has the features you request, you can work out the rest.

function pagination($total,$limit,$current_page,$extra = '',$url = ''){

	if(empty($url)){
		$url = $_SERVER['REDIRECT_URL'];
	}
	$url = rtrim($url,"/"); //clean the extra / if needed


	$numofpages = ceil($total/$limit);
	if($numofpages>'1'){

		$range = 10;
		$range_min = ($range%2==0)?($range/2)-1:($range-1)/2;
		$range_max = ($range%2==0)?$range_min+1:$range_min;
		$page_min = $current_page-$range_min;
		$page_max = $current_page+$range_max;

		$page_min = ($page_min<1)?1:$page_min;
		$page_max = ($page_max<($page_min+$range-1))?$page_min+$range-1:$page_max;
		if($page_max>$numofpages){
			$page_min = ($page_min>1)?$numofpages-$range+1:1;
			$page_max = $numofpages;
		}

		$page_min = ($page_min<1)?1:$page_min;

		if(!empty($extra)){
			$extra_p = '&'.$extra;
		}

		if(($current_page>($range-$range_min))&&($numofpages>$range)){
			$page_pagination .= '<a class="num"  title="First" href="'.$url.'/?page=1'.$extra_p.'">&lt;</a> ';
		}

		if($current_page!=1){
			$page_pagination .= '<a class="num" href="'.$url.'/?page='.($current_page-1).$extra_p.'">Previous</a> ';
		}

		for($i = $page_min ; $i<=$page_max ; $i++){
			if($i==$current_page)
				$page_pagination .= '<span class="num"><strong>'.$i.'</strong></span> ';
			else
				$page_pagination .= '<a class="num" href="'.$url.'/?page='.$i.$extra_p.'">'.$i.'</a> ';
		}

		if($current_page<$numofpages){
			$page_pagination .= ' <a class="num" href="'.$url.'/?page='.($current_page+1).$extra_p.'">Next</a>';
		}

		if(($current_page<($numofpages-$range_max))&&($numofpages>$range)){
			$page_pagination .= ' <a class="num" title="Last" href="'.$url.'/?page='.$numofpages.$extra_p.'">&gt;</a> ';
		}
		return $page_pagination;
	} //end if more than 1 page
}