Re: Re: algorithm of pages beaking

["jeffry s" <paragasu@xxxxxxxxx>]

On Thu, Mar 20, 2008 at 7:35 AM, George J <georgejamieson@xxxxxxxxxxxxx>
wrote:

> Hi,
>
> I'm trying to resolve an issue with a pagination routine. Sounds like
> we're
> working on a similar routine. I have a query returning products from a
> database and then display the results in a defined number of products per
> page.
>
> Checkout - 'Newbie question, Which way is best?' in this newsgroup.
>
> George
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> i  have spent some time to figure it out last time. i did create a simple
function to do it
total - is the total record. can be output of SELECT COUNT(*) FROM table
offset - is the current offset.

    //display pages
    function pages($total, $offset, $perpage)
       {
           if($total == 0) return;

           $total_pages = floor($total / $perpage);
           $current_page = floor($offset / $perpage);

           $pg = '';
           for($i = 0; $i <= $total_pages; $i++)
           {
               $pg .= "<a class='page_nav' href='?p=".($i *
$perpage)."'>".($i + 1)."</a>";
        }

        return $pg;
    }

i am afraid this one look too simple. but you can see how the basis work.
this one simply print 1, 2, 3 etc..