[RESOLVED] page link bar

[spiritssight]

Hello,

I am wondering how could you limit the number of links

ok it looks like this

FIrst page | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | next | last page

now I only want to display 1 - 5 and when you it next it shows page 2 but when it hits 5 and you hit next it shows 2 - 6 and so on,

I hope this makes sence?

Sincerely,
Christopher

[PartDigital]

Can we see the code?

[spiritssight]

Ok, here is the code to what I have already, if there is 500 results and there is 20 results on a page it would have 50 links from 1 to 50 on the bar along with first page, pre and next, last page.

also this code is not changing the results like it should. I have passed through a $_GET var sq= ... which also needs to be on all them links

Thanks very much for your help with this!

Sincerely,
Christopher

Code:

include '/home/dev/www/search/search_form.php';

$search_query = $_GET['sq'];

$perpage = 20; if(isset($_GET["perpage"])) { $perpage =$_GET["perpage"];}
$pagenum = 1; if(isset($_GET["page"])) { $pagenum =$_GET["page"];}

include '/home/dev/www/search/lib/db_config_ro-dev.php';
include '/home/dev/www/search/lib/db_conn-select.php';

$offset = ($pagenum - 1) * $perpage;

$field1 = "PNO";
$field2 = "SN_SNL";

$query = " SELECT * FROM query WHERE $field1 LIKE '%$search_query%' OR $field2 LIKE '%$search_query%' LIMIT $offset, $perpage";
$result = mysql_query($query) OR die("Was unable to get the results!" . mysql_error());
$rows = mysql_num_rows($result) OR die("Was unable to get number of rows" . mysql_error());
$num = mysql_affected_rows();

// how many rows we have in database
$query = " SELECT * FROM query WHERE $field1 LIKE '%$search_query%' OR $field2 LIKE '%$search_query%'";
$result = mysql_query($query) OR die("Was unable to get the results!" . mysql_error());
$numrows = mysql_num_rows($result) OR die("Was unable to get number of rows" . mysql_error());
// $num = mysql_affected_rows();

// how many pages we have when using paging?
$maxPage = ceil($numrows/$perpage);

// print the link to access each page
$self = $_SERVER['HTTP_REFERER'];
$page_num_nav  = "";

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pagenum)
   {
      $page_num_nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $page_num_nav .= " <a href=\"$self?page=$page&sq=$search_query\">$page</a> ";
   }
}
if ($pagenum > 1)
{
   $page  = $pagenum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Prev]</a> ";

   $first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
   $prev  = ""; // we're on page one, don't print previous link
   $first = ""; // nor the first page link
}

if ($pagenum < $maxPage)
{
   $page = $pagenum + 1;
   $next = " <a href=\"$self?page=$page\">[Next]</a> ";

   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
   $next = ""; // we're on the last page, don't print next link
   $last = ""; // nor the last page link
}

$result_bar = $first . $prev . $page_num_nav . $next . $last;

[PartDigital]

can you please provide large comments where you aren't sure it's working?

[spiritssight]

ok here is two code boxes the first one is the area I think is not allowing the results to change right and the next box is the whole code

Thanks ahead of time for your help!

area where think is wrong:

   if ($page == $pagenum)
   {
      $page_num_nav .= " $page "; // no need to create a link to current page
   }
   else
   {
		// I think my problem of why is not changing lies with then the below code
      $page_num_nav .= " <a href=\"http://search.yoursite.com/?sq=$search_query&page=$page\">$page</a> ";
   }

whole script:

include '/home/dev/www/search/search_form.php';

// the var used to search the database
$search_query = $_GET['sq'];

// sets the default values for the perpage and page if not in the url
$perpage = 20; if(isset($_GET["perpage"])) { $perpage =$_GET["perpage"];}
$pagenum = 1; if(isset($_GET["page"])) { $pagenum =$_GET["page"];}

include '/home/dev/www/search/lib/db_config_ro-dev.php';
include '/home/dev/www/search/lib/db_conn-select.php';

$offset = ($pagenum - 1) * $perpage;

$field1 = "PNO";
$field2 = "SN_SNL";

$query = " SELECT * FROM query WHERE $field1 LIKE '%$search_query%' OR $field2 LIKE '%$search_query%' LIMIT $offset, $perpage";
$result = mysql_query($query) OR die("Was unable to get the results!" . mysql_error());
$rows = mysql_num_rows($result) OR die("Was unable to get number of rows" . mysql_error());
$num = mysql_affected_rows();

// how many rows we have in database
$query = " SELECT * FROM query WHERE $field1 LIKE '%$search_query%' OR $field2 LIKE '%$search_query%'";
$result = mysql_query($query) OR die("Was unable to get the results!" . mysql_error());
$numrows = mysql_num_rows($result) OR die("Was unable to get number of rows" . mysql_error());

// how many pages we have when using paging?
$maxPage = ceil($numrows/$perpage);

// print the link to access each page
$page_num_nav  = "";

for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pagenum)
   {
      $page_num_nav .= " $page "; // no need to create a link to current page
   }
   else
   {
		// I think my problem of why is not changing lies with then the below code
      $page_num_nav .= " <a href=\"http://search.yoursite.com/?sq=$search_query&page=$page\">$page</a> ";
   }
}
if ($pagenum > 1)
{
   $page  = $pagenum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Prev]</a> ";

   $first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
   $prev  = ""; // we're on page one, don't print previous link
   $first = ""; // nor the first page link
}

if ($pagenum < $maxPage)
{
   $page = $pagenum + 1;
   $next = " <a href=\"$self?page=$page\">[Next]</a> ";

   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
   $next = ""; // we're on the last page, don't print next link
   $last = ""; // nor the last page link
}

$result_bar = $first . $prev . $page_num_nav . $next . $last;

[spiritssight]

also I just found the way I want these links to behavie. if you look at this forum you will see where it shows the different topics on the right hand side at the top is a links bar that is for the pages it like:

Page 4 of 14 &#171; First < 2 3 4 5 6 > Last &#187;

I would like my to be like that one!

Any help would be great!

[spiritssight]

I am still looking for assistance with this!

Thanks
Christopher

[garblar]

this should do what you want. you will have to set $numPagesShown to be how many you want to show up.
you might have to change some variable names also to get it to work with your script

$numPagesShown = 5;
if($numrows > $perpage){

$maxPage = ceil($numrows/$perpage);

if($pagenum > $maxPage){
	$pagenum = 1;
}

$pageOffset = ($numPagesShown - 1)/2;
if(($pagenum - $pageOffset > 1)&&($pagenum + $pageOffset <= $maxPage)){
	$startPage = $pagenum - $pageOffset;
}
else if($pagenum - $pageOffset <= 1){
	$startPage = 1;
}
else if($pagenum + $pageOffset > $maxPage){
	$startPage = $lastPage - $numPagesShown;
	if($startPage<1){
		$startPage=1;
	}
}

$numPage = 0;
for($i = 0; $i < $numPagesShown; $i++){
	if($startPage + $i >=  $maxPage){
		break;
	}
	$numPage = $i;
}

$finishPage = $startPage + $numPage;

$page_num_nav  = "";

for($i = $startPage; $i <= $finishPage; $i++){
	if($pagenum == $i){
		$page_num_nav .= " $i ";
	}
	else{
		$page_num_nav .= " <a href=\"http://search.yoursite.com/?sq=$search_query&page=$i\">$i</a> ";
	}
}
}	

[spiritssight]

Ok, I have put this into my code and changes some of the var names,
I get the following error when I get on the last page number say there is 172 records and showing 20 results per page, there would be 8 pages so when I click on 8 then it gives this:
Notice: Undefined variable: lastPage in /home/dev/www/qna/results_nav_bar.php on line 22

below is the code, I got till still add to the code a first page and last page link which I will add once this is working the way I want.

Thanks for any advice on this!

Sincerely,
Christopher

results_nav_bar.php

<?php
// passed through URL $search_query
// Can be paaed through URL $resultsperpage (default: 20) / $pagenum (default: 1)

$numPagesShown = 5;
if($numrows > $resultsperpage){

$maxPage = ceil($numrows/$resultsperpage);

if($pagenum > $maxPage){
    $pagenum = 1;
}

$pageOffset = ($numPagesShown - 1)/2;
if(($pagenum - $pageOffset > 1)&&($pagenum + $pageOffset <= $maxPage)){
    $startPage = $pagenum - $pageOffset;
}
else if($pagenum - $pageOffset <= 1){
    $startPage = 1;
}
else if($pagenum + $pageOffset > $maxPage){
    $startPage = $lastPage - $numPagesShown;
    if($startPage<1){
        $startPage=1;
    }
}

$numPage = 0;
for($i = 0; $i < $numPagesShown; $i++){
    if($startPage + $i >=  $maxPage){
        break;
    }
    $numPage = $i;
}

$finishPage = $startPage + $numPage;

$page_num_nav  = "";

for($i = $startPage; $i <= $finishPage; $i++){
    if($pagenum == $i){
        $page_num_nav .= " $i ";
    }
    else{
        $page_num_nav .= " <a href=\"http://qna.disabilityinfoseek.com/?sq=$search_query&pn=$i\">$i</a> ";
    }
}
} 
?>

[spiritssight]

I want to thank you garblar for your help with this piece of code!
Sincerely,
Christopher

[garblar]

change $lastPage to $maxPage and it should be ok