How to use this Google style pagination function?

[AdRock]

I found a nice function that displays pagaination links like google links but have no idea how i use the function with the database queries.

I know how to connect to the database and create the queries but don't know how to use the function. There is nothing on the site where the code came from that tells you how to use it.

Does anyone know how I can use this function to generate links from a MySQL query?

<?php
// quickLink
# writes out page links
function quickLink ($linkHref, $desc, $accessKey, $linkTitle) {
   $theLink = '<a href="'. $linkHref .'#pagination" title="'. $desc .'" accesskey="'. 
                   $accessKey .'">'. $linkTitle .'</a>';
   return $theLink;

} 
// google_like_pagination.php 
function pagination($number, $show, $showing, $firstlink, $baselink, $seperator) {
    $disp = floor($show / 2);
    if ( $showing <= $disp) :

    if ( ($disp - $showing) > 0 ):
    $low  = ($disp - $showing);
    else:
    $low = 1;
    endif;
    $high = ($low + $show) - 1;

elseif ( ($showing + $disp) > $number) :

    $high = $number;
    $low = ($number - $show) + 1;

else:

    $low  = ($showing - $disp);
    $high = ($showing + $disp);

endif;

// next / prev / first / last
if ( ($showing - 1) > 0 ) :
    if ( ($showing - 1) == 1 ):
    $prev  = quickLink ($firstlink, 'Previous', '', 'Previous');
    else:
    $prev  = quickLink ($baselink . $seperator . ($showing - 1), 
    'Previous', 'z', 'Previous');
    endif;
else:
    $prev  = 'Previous';
endif; 

$next  = ($showing + 1) <= $number ? 
quickLink ($baselink . $seperator . ($showing + 1), 
'Next', 'x', 'Next') : 'Next';    

if ( $_SERVER['REQUEST_URI'] == $firstlink ):
$first = '<span class="sel">First Page</span>';    
else:
$first = quickLink ($firstlink, 'First Page', '', 'First Page');
endif;    

if ( $showing == $number ):
$last = '<span class="sel">Last Page</span>';    
else:
$last = quickLink ($baselink . $seperator . $number, 'Last Page', '', 'Last Page');
endif;


$navi = '<div id="pagination">
<ul>'."\n";
// start the navi

    $navi .= '<li>'. $prev ."</li>\n";

// loop through the numbers

foreach (range($low, $high) as $newnumber):

       $link = ( $newnumber == 1 ) ? $firstlink : 
            $baselink . $seperator . $newnumber;
       if ($newnumber > $number):
    $navi .= '';
    elseif ($newnumber == 0):
    $navi .= '';
    else:
    $navi .= ( $newnumber == $showing ) ? 
        '<li class="sel">'. $newnumber .'</li>'."\n" :
        '<li>'. quickLink ($link, 'Page '. $newnumber, '', $newnumber) ."</li>\n"; 
    endif;                   
endforeach;    

// end the navi first line

    $navi .= '<li>'. $next ."</li>\n";

$navi .= '</ul>'."\n";
// second line
$navi .= '<p>'. $first ."\n | Showing page ". $showing .' of '. $number ."\n | ".
        $last .'</p>
</div>';

return $navi;        

}
/* 
## fake content example 

foreach (range(1, 301) as $newnumber):
## fake content example
$content []=  'this is page '. ($newnumber - 1); 
endforeach;

## Settings

$showing   = !isset($_GET["view"]) ? 1 : $_GET["view"];

$firstlink = $_SERVER['PHP_SELF'];
$seperator = '?view=';


## $baselink can be used if for example when the main script was index.php not the filename
    $baselink  = $firstlink;

## $show must be an odd number for this to work correctly
## This is the number of links between next and previous links
    $show = 3;

echo $content[$showing]; 
echo pagination(count($content), $show, $showing, $firstlink, $baselink, $seperator);                 

*/
?>

[bokehman]

Looks complicated! Here's how I would do it:

<?php

$page = (isset($_GET['page']) and (is_numeric($_GET['page'])) and ($_GET['page'] >= 1)) ? (int)$_GET['page'] : 1 ;

$results_per_page = 10;
$tablename = 'myTable';
$orderBy = 'id';

$query = "SELECT COUNT(*) as `count` FROM `$tablename`";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$num_rows = $row['count'];

// make sure page is within range
$total_pages = $num_rows ? ceil($num_rows / $results_per_page) : 1 ;
$page = ((is_numeric($page)) and ($page >= 1) and ($page <= $total_pages)) ? (int)$page : 1 ;

$pagination_links = pagination_links($page, $num_rows, $results_per_page);

$query = "SELECT * FROM `$tablename` ORDER BY `$orderBy` DESC LIMIT $results_per_page OFFSET ".(($results_per_page * $page) - $results_per_page);
$result = mysql_query($query);

$results_array = array();

if(mysql_num_rows($result))
{
    while($row = mysql_fetch_assoc($result))
    {
        $results_array[] = $row;
    }
}

function pagination_links($page, $num_rows, $results_per_page, $each_direction = 5)
{
    $word_for_previous = 'prev';
    $word_for_next = 'next';
    $total_pages = $num_rows ? ceil($num_rows / $results_per_page) : 1 ;
    if($total_pages < 2)
    {
        return null;
    }
    $page = ((is_numeric($page)) and ($page >= 1) and ($page <= $total_pages)) ? (int)$page : 1 ;
    $output = null;
    if($page > 1)
    {
        $output .= '<a href="'.htmlentities($_SERVER['PHP_SELF']).'?page='.($page - 1).'">'.$word_for_previous.'</a>'."\n".' | '."\n";
    }
    for($i = $page - $each_direction; $i <= $page + $each_direction; $i++)
    {
        if(($i > 0) and ($i <= $total_pages))
        {
            $output .= isset($spacer) ? $spacer : null ;
            $spacer = ' | '."\n";
            if($page != $i)
            {
                $output .= '<a href="'.htmlentities($_SERVER['PHP_SELF']).'?page='.$i.'">'.$i.'</a>'."\n";
            }
            else
            {
                $output .= $i."\n";
            }
        }
    }
    if($page < $total_pages)
    {
        $output .= ' | '."\n".'<a href="'.htmlentities($_SERVER['PHP_SELF']).'?page='.($page + 1).'">'.$word_for_next.'</a>'."\n";
    }
    return '<p class="pagination-links">'."\n".$output.'</p>';
}

?> 

That produces two variables: $pagination_links and $results_array. The former is just echoed out and the latter is used in a foreach loop to output your DB results.