Ahhh! Too many pages

mabans

I have a script running that sets page numbers and so far it has worked quite well for me. No real complaints.

The Script is as follows:

// If current page number, use it
// if not, set one!

if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

// Define the number of results per page
$max_results = 10;

// Figure out the limit for the query based
// on the current page number.
$from = (($page * $max_results) - $max_results);

// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM $table"),0);

// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);


// Build Previous Link
if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\""
    .$_PHP_SELF
    ."?page=$prev\">"
    ."<< Previous</a> ";
}

for($i = 1; $i <= $total_pages; $i++){ // Builds page numbers
    if(($page) == $i){
        echo "$i | ";
        } else {
           echo "<a href=\""
           		.$_PHP_SELF
                ."?page=$i\">$i</a>&nbsp;|&nbsp;";
    }
}

// Build Next Link
if($page < $total_pages){
    $next = ($page + 1);
    echo "<a href=\""
    .$_PHP_SELF
    ."?page=$next\">Next >></a>";
}

Now the problem is I was using the script to page out an adminstration page for some items but it's 70+ pages! yikes! :eek:

Of course it doesn't wrap around and extends the page waaay farther than I would like it to. And even if it didn't wrap around cosmetically it doesn't look neat. Page nunmbering schemes that go something like

1 2 3 >> .... last page.

How can I achieve this amazing feat? Thanks in advance.

bubblenut

Here's a class I wrote, needs a little polishing but works OK. There's some good comments on how to make it better there as well. Good luck.
Bubble
[edit]
I forgot to post the link :rolleyes:

mabans

hmm I'm not as advanced as you are, how does it know how many pages it needs to prepare.

bubblenut

In short, it doesn't; not until you give it some info anyway.
Right, when you instantiate the class (don't worry if you're not too hot on OO I'll go through it in a min). You provide it with which page you're on, the total number of rows and the number of rows you want to display on each page (there's also a var called $IN_LIST which set's how many numbers on the page list before it goes to dots).
You can then do getLinks('http://www.yousite.com/thepage.php'); to get the page links & getLimit() to get the SQL limit. You should note that this just handles the pagination, not the DB stuff.
Right here's an example assuming we're on $page, we want $per_page rows per page and the page link is $page_link.

<?php
$sql="SELECT * FROM table";
$res=mysql_query($sql);
$row=mysql_fetch_row($res);
$paginator=new Paginator($page, $row[0],$per_page);
$links=$paginator->getLinks($page_link);
$sql="SELECT * FROM table LIMIT ".$paginator->getLinks();
$res=mysql_query($sql);
?>
<?=$links?><br />
<?php
while($row=mysql_fetch_array($res)) {
  echo($row[0]." - ".$row[1]."etc...<br />");
}
?>
<?=$links?><br />

HTH
Bubble