class for paging

mshanthys

hi,

i want to try a page navigator to my page. iam using the following class.
It works fine. The problem is i want the "next" hyperlink to display the next 10 pages' links.

i.e. 1 2 3 4 5 6 7 8 9 10 Next[10]

My code now displays the 11 th page if u click on Next[10]

it should display 10 11 12 13 etc.

this is the class

<?php

class MySQLPagedResultSet
{

var $results;
var $pageSize;
var $page;
var $row;

//$resultpage=null;

function MySQLPagedResultSet($query,$pageSize,$cnx)
{
global $resultpage;
//$resultpage=$_GET['resultpage'];

$this->results = @mysql_query($query,$cnx);

$this->pageSize = $pageSize;
if ((int)$resultpage <= 0) $resultpage = 1;
if ($resultpage > $this->getNumPages())
  $resultpage = $this->getNumPages();

$this->setPageNum($resultpage);

}

function getNumPages()
{
if (!$this->results)
return FALSE;

return ceil(mysql_num_rows($this->results) /
            (float)$this->pageSize);

}

function setPageNum($pageNum)
{
if ($pageNum > $this->getNumPages() or
$pageNum <= 0) return FALSE;

$this->page = $pageNum;
$this->row = 0;
mysql_data_seek($this->results,($pageNum-1) * $this->pageSize);

}

function getPageNum()
{
return $this->page;
}
function isTenPage()
{
return ($this->page >= 3);
}

function isLastPage()
{
return ($this->page >= $this->getNumPages());
}

function isFirstPage()
{
return ($this->page <= 1);
}

function fetchArray()
{
if (!$this->results)return FALSE;

if ($this->row >= $this->pageSize) return FALSE;
$this->row++;

return mysql_fetch_array($this->results);

}

function getPageNav($queryvars = '')
{
$nav=null;

if (!$this->isFirstPage())
{

  $nav .= "<a href=\"?resultpage=".
          ($this->getPageNum()-1).'&'.$queryvars.'">Prev</a> ';
}


if ($this->getNumPages() > 1)
  for ($i=1; $i<=$this->getNumPages(); $i++)
  {
    if ($i==$this->page)
      $nav .= "$i ";
    else
      $nav .= "<a href=\"?resultpage={$i}&".
              $queryvars."\">{$i}</a> ";
  }



if (!$this->isLastPage())
{
  $nav .= "<a href=\"?resultpage=".
          ($this->getPageNum()+1).'&'.$queryvars.'">Next</a> ';
}

return $nav;

}
}

Any help would be appreciated
Thanks in advance

shanthy

Weedpacket

Sounds like an off-by-one error in the code that writes the Next[n] link. Try taking off the +1 that's in that line.

mshanthys

hi,

Taking out the +1 will not help, as the next link will not display anything at all. It will carry pageNum() which will be the current page

I want the Next link to bring the remaing page numbers.

eg. i set the first set to 6 pages, then the next link should fetch the next 6 pages links.

Thanks
shanthy

Weedpacket

There's information mising: on which page is your example
1 2 3 4 5 6 7 8 9 10 Next[10]
supposed to be? 1? 10? 9? Or 5 for that matter?

Assume it's on page 1; click Next[10] and it lists 10-19 (ten links) or 11-20 (and displays which page? 2? 10? 11?).

Assume it's on page 10; click Next[10] and it lists 11-20 (ten links) and displays page 11. But then, why didn't page 10 list links 10-19?

Assume it's on page 9; click Next[10] and it lists 10-19 and displays page 10.

This is my question: I am on page n. Which pages are given links on that page? I will assume that Next is supposed to take me to page n+1.

mshanthys

hi,

i am sorry i used [next 10] and [next 6]. It can be any one of them. if i decide to have 1 2 3 4 5 6 Next[6] or till 10 and [next 10]

My code now will do the follg:

On click of Next link, it will take me to the current page+1.

Eg :

if iam in the 3rd page, and and click Next, it will take me to the 4 th page.This is done even if i have all the 10 pages links listed on the main page.

if stop the loop displaying the page links till 5, clicking on the "next" link will still take u to the current page + 1

I want the next hyperlink to dsiplay the next set of links , instead of just taking me to the current page + 1

I hope iam clear, if not pls ask me

Thanks
shanthy