Sign up to create your own snipts, or login.

Public snipts » robertbanh's snipts » pagination The latest pagination snipts from robertbanh.

showing 1-2 of 2 snipts for pagination
  • Pagination for PHP
            <div id='pagination'>
                <span class='curr'>Page <?php echo $page; ?> of <?php echo $totalPages; ?></span>
                <?php
                $range = 3;
                // build previous page
                if ($page > 1)
                    echo "<span><a href='{$_SERVER['PHP_SELF']}?page=".($page-1)."'>Previous</a></span> ";
                // build range pages
                $stop = ($page + $range) + 1;
                for ($x=($page-$range); $x<$stop; $x++) 
                {
                    // if it's a valid page number...
                    if (($x > 0) && ($x <= $totalPages)) 
                    {
                        if ($x == $page)
                            echo "<span class='curr'>$x</span> ";
                        else
                            echo "<span><a href='{$_SERVER['PHP_SELF']}?page=$x'>$x</a></span> ";
                    }
                }
                // build last page
                if ($stop <= $totalPages) 
                    echo "... <span><a href='{$_SERVER['PHP_SELF']}?page=$totalPages'>$totalPages</a></span> ";
                // build next page
                if ($page != $totalPages)
                    echo "<span><a href='{$_SERVER['PHP_SELF']}?page=".($page+1)."'>Next</a></span>";
                ?>
            </div>
    

    copy | embed

    0 comments - tagged in  posted by robertbanh on Jan 02, 2010 at 2:12 p.m. EST
  • Correct way to do Pagination in Zend
    <?
    //In other words, instead of this:
    
        $select= $this->db->select()->from( 'runz_miles', 'EMPL_NO')->where('empl_no = ?', 31713);
        $this->view->result = $this->db->fetchAll($sql);
        $paginator = Zend_Paginator::factory($this->view->result);
    
    //Do this:
    
        $select= $this->db->select()->from( 'runz_miles', 'EMPL_NO')->where('empl_no = ?', 31713);
        $paginator = Zend_Paginator::factory($select);
    

    copy | embed

    0 comments - tagged in  posted by robertbanh on Oct 13, 2009 at 9:59 a.m. EDT
Sign up to create your own snipts, or login.