Back To Website Design Forum

Pagination Question...

  • Brian Jester
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jan 06, 2006
  • Posts: 61
  • Loc: Bayonne, New Jersey USA
  • Status: Offline

Post November 22nd, 2009, 8:36 am

Hi,

I am trying out a php pagination script (using mysql)...Have it running locally on my test server it works fine, the only problem I am having is that I want the results to be displayed in an html table that can be adjusted. Ex: $tr and $td so I can set those for the amount of rows and columns in the table. A Dynamic Html table.

Here's the entire code (pagination script first, then current code I am using to echo the html) currently it only displays one row of images and I would like it to display more than one row. But would like to be able to adjust it as I said above so I can adjust it according to the resolution.

Code: [ Select ]
<html>
<head><title>Visit My Site - The Next Generation of Web Advertising!</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>

<?php

// Pagnination Script ------------------------------------------------------------------------------------------------------------------------------
    include('config.php');    // include your code to connect to DB.

    $tbl_name="ap_form_1";        //your table name
    // How many adjacent pages should be shown on each side?
    $adjacents = 1;
    
    /*
      First get total number of rows in data table.
      If you have a WHERE clause in your query, make sure you mirror it here.
    */
    $query = "SELECT COUNT(*) as num FROM $tbl_name";
    $total_pages = mysql_fetch_array(mysql_query($query));
    $total_pages = $total_pages[num];
    
    /* Setup vars for query. */
    $targetpage = "page.php";     //your file name (the name of this file)
    $limit = 6;             //how many items to show per page
    $page = $_GET['page'];
    if($page)
        $start = ($page - 1) * $limit;             //first item to display on this page
    else
        $start = 0;                                //if no page var is given, set start to 0
    
    /* Get data. */
    $sql = "SELECT * FROM $tbl_name ORDER BY element_4 LIMIT $start, $limit";
    $result = mysql_query($sql);

  
    /* Setup page vars for display. */
    if ($page == 0) $page = 1;                    //if no page var is given, default to 1.
    $prev = $page - 1;                            //previous page is page - 1
    $next = $page + 1;                            //next page is page + 1
    $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.
    $lpm1 = $lastpage - 1;                        //last page minus 1
    
    /*
        Now we apply our rules and draw the pagination object.
        We're actually saving the code to a variable in case we want to draw it more than once.
    */

    $pagination = "";
    if($lastpage > 1)
    {    
        $pagination .= "<div class=\"pagination\">";
        //previous button
        if ($page > 1)
           $pagination.= "<a href=\"$targetpage?page=$prev\"><< previous </a>";
        else
            $pagination.= "<span class=\"disabled\"><< previous </span>";    
        
        //pages    
        if ($lastpage < 7 + ($adjacents * 2))    //not enough pages to bother breaking it up
        {    
            for ($counter = 1; $counter <= $lastpage; $counter++)
            {
                if ($counter == $page)
                    $pagination.= "<span class=\"current\">$counter</span>";
                else
                    $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
            }
        }
        elseif($lastpage > 5 + ($adjacents * 2))    //enough pages to hide some
        {
            //close to beginning; only hide later pages
            if($page < 1 + ($adjacents * 2))        
            {
                for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<span class=\"current\">$counter</span>";
                    else
                        $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
                }
                $pagination.= "...";
                $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
                $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
            }
            //in middle; hide some front and some back
            elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
            {
                $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
                $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
                $pagination.= "...";
                for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<span class=\"current\">$counter</span>";
                    else
                        $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
                }
                $pagination.= "...";
                $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
                $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
            }
            //close to end; only hide early pages
            else
            {
                $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
                $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
                $pagination.= "...";
                for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
                {
                    if ($counter == $page)
                        $pagination.= "<span class=\"current\">$counter</span>";
                    else
                        $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
                }
            }
        }
        
        //next button
        if ($page < $counter - 1)
            $pagination.= "<a href=\"$targetpage?page=$next\"> next >></a>";
        else
            $pagination.= "<span class=\"disabled\"> next >></span>";
        $pagination.= "</div>\n";        
    }

// End Pagnination Script ------------------------------------------------------------------------------------------------------------------------------
?>
  1. <html>
  2. <head><title>Visit My Site - The Next Generation of Web Advertising!</title>
  3. <link href="style.css" rel="stylesheet" type="text/css">
  4. </head>
  5. <body>
  7. <?php
  9. // Pagnination Script ------------------------------------------------------------------------------------------------------------------------------
  10.     include('config.php');    // include your code to connect to DB.
  12.     $tbl_name="ap_form_1";        //your table name
  13.     // How many adjacent pages should be shown on each side?
  14.     $adjacents = 1;
  15.     
  16.     /*
  17.       First get total number of rows in data table.
  18.       If you have a WHERE clause in your query, make sure you mirror it here.
  19.     */
  20.     $query = "SELECT COUNT(*) as num FROM $tbl_name";
  21.     $total_pages = mysql_fetch_array(mysql_query($query));
  22.     $total_pages = $total_pages[num];
  23.     
  24.     /* Setup vars for query. */
  25.     $targetpage = "page.php";     //your file name (the name of this file)
  26.     $limit = 6;             //how many items to show per page
  27.     $page = $_GET['page'];
  28.     if($page)
  29.         $start = ($page - 1) * $limit;             //first item to display on this page
  30.     else
  31.         $start = 0;                                //if no page var is given, set start to 0
  32.     
  33.     /* Get data. */
  34.     $sql = "SELECT * FROM $tbl_name ORDER BY element_4 LIMIT $start, $limit";
  35.     $result = mysql_query($sql);
  37.   
  38.     /* Setup page vars for display. */
  39.     if ($page == 0) $page = 1;                    //if no page var is given, default to 1.
  40.     $prev = $page - 1;                            //previous page is page - 1
  41.     $next = $page + 1;                            //next page is page + 1
  42.     $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.
  43.     $lpm1 = $lastpage - 1;                        //last page minus 1
  44.     
  45.     /*
  46.         Now we apply our rules and draw the pagination object.
  47.         We're actually saving the code to a variable in case we want to draw it more than once.
  48.     */
  50.     $pagination = "";
  51.     if($lastpage > 1)
  52.     {    
  53.         $pagination .= "<div class=\"pagination\">";
  54.         //previous button
  55.         if ($page > 1)
  56.            $pagination.= "<a href=\"$targetpage?page=$prev\"><< previous </a>";
  57.         else
  58.             $pagination.= "<span class=\"disabled\"><< previous </span>";    
  59.         
  60.         //pages    
  61.         if ($lastpage < 7 + ($adjacents * 2))    //not enough pages to bother breaking it up
  62.         {    
  63.             for ($counter = 1; $counter <= $lastpage; $counter++)
  64.             {
  65.                 if ($counter == $page)
  66.                     $pagination.= "<span class=\"current\">$counter</span>";
  67.                 else
  68.                     $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
  69.             }
  70.         }
  71.         elseif($lastpage > 5 + ($adjacents * 2))    //enough pages to hide some
  72.         {
  73.             //close to beginning; only hide later pages
  74.             if($page < 1 + ($adjacents * 2))        
  75.             {
  76.                 for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
  77.                 {
  78.                     if ($counter == $page)
  79.                         $pagination.= "<span class=\"current\">$counter</span>";
  80.                     else
  81.                         $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
  82.                 }
  83.                 $pagination.= "...";
  84.                 $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
  85.                 $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
  86.             }
  87.             //in middle; hide some front and some back
  88.             elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
  89.             {
  90.                 $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
  91.                 $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
  92.                 $pagination.= "...";
  93.                 for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
  94.                 {
  95.                     if ($counter == $page)
  96.                         $pagination.= "<span class=\"current\">$counter</span>";
  97.                     else
  98.                         $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
  99.                 }
  100.                 $pagination.= "...";
  101.                 $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
  102.                 $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";        
  103.             }
  104.             //close to end; only hide early pages
  105.             else
  106.             {
  107.                 $pagination.= "<a href=\"$targetpage?page=1\">1</a>";
  108.                 $pagination.= "<a href=\"$targetpage?page=2\">2</a>";
  109.                 $pagination.= "...";
  110.                 for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
  111.                 {
  112.                     if ($counter == $page)
  113.                         $pagination.= "<span class=\"current\">$counter</span>";
  114.                     else
  115.                         $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";                    
  116.                 }
  117.             }
  118.         }
  119.         
  120.         //next button
  121.         if ($page < $counter - 1)
  122.             $pagination.= "<a href=\"$targetpage?page=$next\"> next >></a>";
  123.         else
  124.             $pagination.= "<span class=\"disabled\"> next >></span>";
  125.         $pagination.= "</div>\n";        
  126.     }
  128. // End Pagnination Script ------------------------------------------------------------------------------------------------------------------------------
  129. ?>


Begin table output code

Code: [ Select ]
<div align="center">


<?php

// Table output code

$tr = 4;
$td = 5;

for($i = 0; $i < $tr; $i++)
{
   echo '<tr>';
   for($j = 0; $j < $td; $j++)
   {
   echo '<td>';

while($row = mysql_fetch_array($result))
echo "<img src=\"machform/data/form_1/files/".$row['element_3']."\" border=\"1\" alt=\"".$row['element_1']."\" title=\"".$row['element_1']."\">";
echo "<br />";
echo "Price: $$row[element_4]";

     echo '</td>';
   }
   echo '</tr>';
}

?>

</div>

<?=$pagination?>
<p />
  1. <div align="center">
  4. <?php
  6. // Table output code
  8. $tr = 4;
  9. $td = 5;
  11. for($i = 0; $i < $tr; $i++)
  12. {
  13.    echo '<tr>';
  14.    for($j = 0; $j < $td; $j++)
  15.    {
  16.    echo '<td>';
  18. while($row = mysql_fetch_array($result))
  19. echo "<img src=\"machform/data/form_1/files/".$row['element_3']."\" border=\"1\" alt=\"".$row['element_1']."\" title=\"".$row['element_1']."\">";
  20. echo "<br />";
  21. echo "Price: $$row[element_4]";
  23.      echo '</td>';
  24.    }
  25.    echo '</tr>';
  26. }
  28. ?>
  30. </div>
  32. <?=$pagination?>
  33. <p />
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 22nd, 2009, 8:36 am

  • Brian Jester
  • Beginner
  • Beginner
  • No Avatar
  • Joined: Jan 06, 2006
  • Posts: 61
  • Loc: Bayonne, New Jersey USA
  • Status: Offline

Post November 24th, 2009, 1:04 pm

Nevermind, figured this one out

Page 1 of 1

Post Information

  • Total Posts in this topic: 2 posts
  • Users browsing this forum: No registered users and 96 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.