MySQL Error with Pagination - Page 2

dylanfm · 02-08-2008, 01:55 AM

Never let your offset go beneath 0

Orc · 02-08-2008, 01:57 AM

Quote:

Originally Posted by dylanfm

Never let your offset go beneath 0

I have this:

PHP Code:


			
 if ($page < 1)

 {

     $page = 1;

 }

Orc · 02-08-2008, 02:05 AM

Success! I Got It But Yet The Numbers Dont Show Up! Only Next! No Prev!

Orc · 02-08-2008, 02:08 AM

Woot, I got it, but Prev doesnt show!

UPDATE: Prev goes to page 0
In fact, Next just keeps incrementing

In fact, it doesnt show it incrementing numbers on the page, just the url. /?page=% and it keeps showing [1] :[

EyeDentify · 02-08-2008, 09:13 AM

@Orc.

I have found some nice Pagination tutorials on this site called:
PHP Help: PHP Freaks!

Wich got me going some time back with pagination.
Maybe it could help you.

Seems they removed the Tutorial.
But i found some code snippets in there library
PHP Help: Pagination

/EyeDentify

ReSpawN · 02-08-2008, 10:24 AM

Various sites offer these classes but the best way is to make your own. Do not be afraid to use if/else 's since that is what they are made for. I know from experience that vBulletin and others have a very good script for what you are trying to do. I myself am going to make on as well but I always do some research into how it's done. I suggest you do the same.

Otherwise, you can check some tutorials on Pixel2Life.com and Tutorialized.com

If you don't manage, just post! Hopefully this post will help you sort out some problems, kinda useless post otherwise.

Good luck!

Orc · 02-08-2008, 01:59 PM

Quote:

Originally Posted by ReSpawN

Various sites offer these classes but the best way is to make your own. Do not be afraid to use if/else 's since that is what they are made for. I know from experience that vBulletin and others have a very good script for what you are trying to do. I myself am going to make on as well but I always do some research into how it's done. I suggest you do the same.

Otherwise, you can check some tutorials on Pixel2Life.com and Tutorialized.com

If you don't manage, just post! Hopefully this post will help you sort out some problems, kinda useless post otherwise.

Good luck!

Alright, I'll probably make my own, I just need to understand MySQL a bit more. That's all.

REFFER · 03-17-2010, 10:15 PM

Here one simple solution for people looking for pagination...
Just a few changes in the code and it works fine.

PHP Code:


			
    $max = 3;
    if (is_numeric($_GET['p'])){
        $p = $_GET['p'];
        if ($p<1) $p = 1;
    } else {
        $p = 1;
    }
    
    $limit = ($p * $max) - $max;
    
    $conn = mysql_connect("localhost","user","pass");
    mysql_select_db("db_name",$conn);
    
    $query_count = "SELECT * FROM `table`";
    $result = mysql_query($query_count);
    $rows = @mysql_num_rows($result);
    $numOfPages = ceil($rows/$max);
    
    if ($p>$numOfPages) $p = $numOfPages;
    
    $query = $query_count . " LIMIT $limit, $max";
    $result = mysql_query($query);
    

    while ($data = mysql_fetch_object($result)){
        echo $data->field."<br />";
    }
    
    echo "<br /><br />";

    if ($p>1){
        $prev = $p - 1;
        echo '<a href="?p='.$prev.'">Previous</a> ';
    }
    for ($i=1;$i<=$numOfPages;$i++){
        if ($i == $p){
            echo "<b>$i</b> ";
        } else {
            echo '<a href="?p='.$i.'">'.$i.'</a> ';
        }
    }
    if ($p<$numOfPages){
        $next = $p + 1;
        echo '<a href="?p='.$next.'">Next</a>';
    }

Nicklaus · 11-21-2011, 09:32 AM

I am trying to make a simple site map - from a directory full of files.. but I have too many files in the folder, I need pagination.. I have no idea how to do this without MySQL.

PHP Code:
<?php
$filearray = array(); if ($fil = opendir("directory/")) {
while (($file = readdir($fil)) !== false) {
if ($file != "." && $file != "..") { $filearray[] = $file;
echo "<a href="http://www.mydomain.com/directory/$file">http://www.mydomain.com/directory/$file</a><br>";
[code]...

EyeDentify · 11-21-2011, 10:58 AM

Quote:

Originally Posted by Nicklaus

I am trying to make a simple site map - from a directory full of files.. but I have too many files in the folder, I need pagination.. I have no idea how to do this without MySQL.

PHP Code:
<?php
$filearray = array(); if ($fil = opendir("directory/")) {
while (($file = readdir($fil)) !== false) {
if ($file != "." && $file != "..") { $filearray[] = $file;
echo "<a href="http://www.mydomain.com/directory/$file">http://www.mydomain.com/directory/$file</a><br>";
[code]...

Perhaps you could cache the "file listing" in a textfile and then make use of it in an array thereby be able to paginate it ?

And have a look at this function:
http://se.php.net/manual/en/function.glob.php

It´s often underestimated.

Good luck.