[simone]

ok, so i've tried everything known to me, plus the million tutorials out there that dont work, to try and paginate my mysql results. If anyone could point my to a simple tutorial that works, or write up a simple code, i'd be so greatful.

Im pulling the data from a table called "eight" and using $perpage as my limitor. Any help guys?

Thanks.

[blaw]

Originally Posted by simone

ok, so i've tried everything known to me, plus the million tutorials out there that dont work, to try and paginate my mysql results. If anyone could point my to a simple tutorial that works, or write up a simple code, i'd be so greatful.

Im pulling the data from a table called "eight" and using $perpage as my limitor. Any help guys?

Thanks.

Hi there. I couldn't ignore this because that was exactly what I was thinking about. I've been writing a blog script using my leisure time.

Anyways, first off, I thought PEAR's DB class has pager() or something similar that does all the work for you.

If you are not interested, then here's more or less what I did:

Code:

for ($i = 0; $i < $nav_page_num; $i++) {
	// Each link's Start Post will be higher by $per_page.
	$get_sp = (1 + $per_page * $i);
	// "You're Here" indicator. No anchor.
	if ($per_page_start == $get_sp) {
		echo '<strong>'.($i+1).'</strong> &nbsp;';
	}
	else {
		echo '<a href="'.$_SERVER['PHP_SELF'].'?sp='.$get_sp.'">'.($i+1).'</a> &nbsp;';
	}
}

Vars explained:
$nav_page_num = ceil(mysql_num_rows($YOUR_RESULT) / $per_page);
$per_page_start = (isset($_GET['sp']) ? $_GET['sp'] : 1);
$get_sp: starting (Nth) post parameter to be passed onto $_GET['sp'].

Of course, you need to add a query function or whatever you need before this.

I'm not a pro-programmer so I'm not sure how good it may sound to some people, but I hope this at least gives you the idea.

Good night,

[hyjacked]

Just out of curiosity, what do you mean by "paginate"? To break up the results over several pages?

[blaw]

Helloe there,

Originally Posted by hyjacked

Just out of curiosity, what do you mean by "paginate"? To break up the results over several pages?

You are right - at least, I assumed so...

Btw, re the PEAR DB class, I found that it was not a function in DB class, but DB_Pager class. You can find more details at http://pear.php.net/package/DB_Pager .

Cheers,

[EasyWebDev]

phpBB has an excellent pagination function, in functions.php, take a look near the end of search.php to see it in use. Shouldnt take too much work to adapt it to your needs.

[mdhall]

Originally Posted by simone

ok, so i've tried everything known to me, plus the million tutorials out there that dont work, to try and paginate my mysql results. If anyone could point my to a simple tutorial that works, or write up a simple code, i'd be so greatful.

Im pulling the data from a table called "eight" and using $perpage as my limitor. Any help guys?

Thanks.

This came from a tutorial I found. Had to make some changes to the original code, but it works for me just fine.

PHP Code:

$page = $_GET['page'];
 
Add your db connection here  
$limit          = 5;      // Change to how many results you want per page          
    $query_count    = "SELECT * FROM table_name";     
    $result_count   = mysql_query($query_count);  
       
    $totalrows      = mysql_num_rows($result_count); 
    if(empty($page)){ 
        $page = 1; 
    } 
         
    $limitvalue = $page * $limit - ($limit); 
 
$query = ("your regular query here LIMIT $limitvalue, $limit");
$result = mysql_query($query); 
$num=mysql_num_rows($result);
if(mysql_num_rows($result) == 0){ 
        echo("Nothing to Display!"); 
    } 

Do your display of data here
 
if($page != 1){ 
        $pageprev = $page-1; 
         
        echo("<a href=\"$PHP_SELF?page=$pageprev\">PREV ".$limit."</a>&nbsp;&nbsp;&nbsp;"); 
    }else{ 
        echo("PREV&nbsp;" .$limit."&nbsp;&nbsp;&nbsp;"); 
    } 
    $numofpages = $totalrows / $limit; 
     
    for($i = 1; $i <= $numofpages; $i++){ 
        if($i == $page){ 
            echo($i."&nbsp;"); 
        }else{ 
            echo("<a href=\"$PHP_SELF?page=$i\">$i</a>&nbsp;"); 
        } 
    } 

    if(($totalrows % $limit) != 0){ 
        if($i == $page){ 
            echo($i."&nbsp;"); 
        }else{ 
            echo("<a href=\"$PHP_SELF?page=$i\">$i</a>&nbsp;"); 
        } 
    } 
    if(($totalrows - ($limit * $page)) >=0){ 
        $pagenext = $page+1; 
          
        echo("&nbsp;&nbsp;&nbsp;<a href=\"$PHP_SELF?page=$pagenext\">NEXT ".$limit."</a>"); 
    }else{ 
        echo("&nbsp;&nbsp;&nbsp;NEXT&nbsp;" .$limit); 
    } 
     
    mysql_free_result($result); 

Hope that helps you out.

[clintre]

You can also use this class

http://www.jvmultimedia.com/home/art...p?articleId=18