Need help with Pagination - Next - Previous Not working

Discussion in 'PHP' started by Sarao, Jan 30, 2011.

  1. #1
    Friends,

    I am trying to display data with limits from my MYSQL Records. It Shows the data, but it does not work with Next or Previous Page. Here is the code:

    
    <?php 
     // Connects to your Database 
     mysql_connect("localhost", "root", "") or die(mysql_error()); 
     mysql_select_db("shipments") or die(mysql_error()); 
     
     //This checks to see if there is a page number. If not, it will set it to page 1 
     if (!(isset($pagenum))) 
     { 
     $pagenum = 1; 
     } 
     
     //Here we count the number of results 
     //Edit $data to be your query 
     $data = mysql_query("SELECT * FROM info") or die(mysql_error()); 
     $rows = mysql_num_rows($data); 
     
     //This is the number of results displayed per page 
     $page_rows = 1; 
     
     //This tells us the page number of our last page 
     $last = ceil($rows/$page_rows); 
     
     //this makes sure the page number isn't below one, or more than our maximum pages 
     if ($pagenum < 1) 
     { 
     $pagenum = 1; 
     } 
     elseif ($pagenum > $last) 
     { 
     $pagenum = $last; 
     } 
     
     //This sets the range to display in our query 
     $max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; 
    //This is your query again, the same one... the only difference is we add $max into it
     $data_p = mysql_query("SELECT * FROM info $max") or die(mysql_error()); ?>
    
    <table width="100%" border="0" cellspacing="1" cellpadding="0">
    
    <tr> 
    <td><table width="100%" border="1" cellspacing="1" cellpadding="0">
      <tr>
        <td width="34" height="61" align="center"><p><strong>Id</strong></p>
          <p>&nbsp;</p></td>
        <td width="146" align="center"><p><strong>eBay ID</strong></p>
          <p>&nbsp;</p></td>
        <td width="22" align="center"><p ><strong>To/Address</strong></p>
          <p>&nbsp;</p></td>
        <td width="144" align="center"><p><strong>Date Sent</strong></p>
          <p>&nbsp;</p></td>
        <td width="148" align="center"><p><strong>Tracking</strong></p>
          <p>&nbsp;</p></td>
      </tr>
      <?php
    while($rows=mysql_fetch_array($data_p)){
    ?>
      <tr>
        <td align="center"><?php $id[]=$rows['id']; ?>
          <?php echo $rows['id']; ?></td>
        <td align="CENTER"><?php echo $rows['user']; ?></td>
        <td align="justify" ><?php echo nl2br ( $rows['addr']); ?></td>
        <td align="justify"><?php echo $rows['datesent']; ?></td>
        <td align="center"><?php echo $rows['tracking']; ?></td>
      </tr>
      <?php
    }
    ?>
      <tr><td></td>
        <td colspan="4" align="center"></td>
      </tr>
    </table></td>
    </tr>
    </form>
    </table><?php 
     // This shows the user what page they are on, and the total number of pages
     echo " --Page $pagenum of $last-- <p>";
     
     // First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
     if ($pagenum == 1) 
     {
     } 
     else 
     {
     echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
     echo " ";
     $previous = $pagenum-1;
     echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";
     } 
    
     //just a spacer
     echo " ---- ";
    
     //This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
     if ($pagenum == $last) 
     {
     } 
     else {
     $next = $pagenum+1;
     echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";
     echo " ";
     echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";
     } 
     ?>
    
    PHP:

     
    Sarao, Jan 30, 2011 IP
  2. greatlogix

    greatlogix Active Member

    Messages:
    664
    Likes Received:
    13
    Best Answers:
    1
    Trophy Points:
    85
    #2
    What error you get. Can you post here?
     
    greatlogix, Jan 31, 2011 IP
  3. koula

    koula Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Try to use another pagination take it here : how2dev.com/magic-pagination/
     
    koula, Feb 3, 2011 IP