pagination within a html table

balamberas · #1 (**permalink**) 11-17-09, 05:24 PM

Hi, im trying to insert this code within a html script but the Prev 1 2 3 4 next is not displayed and also the DESC is to responding. Any Ideas?

PHP Code:


			
<?php

include ("connect.php");


// max display per page

$per_page = 50;

// get start variable

$start = $_GET ['start'];

// count record

$record_count = mysql_num_rows (mysql_query("SELECT * FROM flats ORDER BY date_posted DESC")); 

//count max pages

$max_pages = $record_count / $per_page; // may come out as a decimal

if (!$start)

  $start = 0;

// display data
$get = mysql_query("SELECT * FROM flats LIMIT $start, $per_page");
 
   while ($row = mysql_fetch_assoc($get))
   
 {
 
  // get data 

   $select= $row['type'];
   $title= $row['title'];
   $location= $row['location'];
  

    echo "<div><b>$title</b></div>";
    echo "<br>";
    echo "$select";
    echo "<br>";
    echo "$rent";
    echo "<br>";
    echo "$location";
  

}

// setup the prev and next variables

$prev = $start - $per_page; 

$next = $start + $per_page;

//show prev button

if (!($start<=0)) 

  echo " <a href='londonfc_flats.php?start=$prev'> << Prev </a> ";

//show page numbers

// set variable for first page

$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{

 if ($start!=$x)
   
  echo " <a href='londonfc_flats.php?start=$x'>$i |</a> ";

else 
  echo " <a href='londonfc_flats.php?start=$x'><b> $i|</b></a> ";

$i++;

}

//show next button

 if (!($start>=$record_count-$per_page))
 echo " <a href='londonfc_flats.php?start=$next'> Next >></a> "; 


?>

job0107 · #2 (**permalink**) 11-18-09, 09:05 AM

It works when I try it.
The only thing is, the Prev 1 2 3 4 next are being displayed on the same line as $location.
Put a <p> after that line and you will see the page navigation.

PHP Code:


			
echo "<div><b>$title</b></div>
      <br>
      $select
      <br>
      $rent
      <br>
      $location
      <p>";

Also you have your ORDER BY clause in the wrong query.
Remove it from the first query and put it in the second query.

I am sure you can do this with only one query if you think it through.

balamberas · #3 (**permalink**) 11-18-09, 04:03 PM

Hi, the pagination is ok when its outside this html table. but within it the Prev 1 2 3 4 Next is not showing. i tried the "<p>" but no luck.

PHP Code:


			
<table width="487" height="672"  border="1" align="left" cellpadding="3" cellspacing="3" background="/bgtr.gif">
                <tr align="center" valign="middle"> 
                  <td width="23%" height="28" bgcolor="#FFFFFF"> <h3 align="center">Available 
                     </h3></td>
                </tr>
                <tr align="center" valign="middle"> 
                  <td height="626" align="left" valign="top" bgcolor="#FFFFFF"> 
                             

<?php

include ("connect.php");


// max display per page

$per_page = 50;

// get start variable

$start = $_GET ['start'];

// count record

$record_count = mysql_num_rows (mysql_query("SELECT * FROM flats"));

//count max pages

$max_pages = $record_count / $per_page; // may come out as a decimal

if (!$start)

  $start = 0;

// display data 

$get = mysql_query("SELECT * FROM flats ORDER BY date_posted DESC LIMIT $start, $per_page");
 
   while ($row = mysql_fetch_assoc($get))
   
 {
 
  // get data 

   $select= $row['type'];
   $title= $row['title'];
   $location= $row['location'];
  

    echo "<div><b>$title</b></div>";
    echo "<br>";
    echo "$select";
    echo "<br>";
    echo "$rent";
    echo "<br>";
    echo "$location";
        "<p>";
}

// setup the prev and next variables

$prev = $start - $per_page; 

$next = $start + $per_page;

//show prev button

if (!($start<=0)) 

  echo " <a href='londonfc_flats.php?start=$prev'><b> «« Prev </b></a> ";

//show page numbers

// set variable for first page

$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{

 if ($start!=$x)
   
  echo " <a href='londonfc_flats.php?start=$x'>$i |</a> ";

else 
  echo " <a href='londonfc_flats.php?start=$x'><b> $i|</b></a> ";

$i++;

}

//show next button

 if (!($start>=$record_count-$per_page))
 echo " <a href='londonfc_flats.php?start=$next'><b> Next »»</b></a> "; 


?>




                  </td>
                </tr>
              </table>

job0107 · #4 (**permalink**) 11-19-09, 11:40 AM

Try it like this:

PHP Code:


			
<html>
<head>
<style>
.table1
{
 border-collapse:collapse;
 }
.table2
{
 width:100%;border:none;border-collapse:collapse;
 }
.table3
{
 height:20px;
 width:100%;
 }
.title
{
 text-align:center;
 font-size:18px;
 font-weight:bold;
 background:#fff;
 }
.td_header
{
 width:25%;
 text-align:center;
 font-size:16px;
 font-weight:bold;
 }
.div_header_1
{
 margin-left:2px;
 margin-right:1px;
 background:#fff;
 }
.div_header_2
{
 margin-left:1px;
 margin-right:1px;
 background:#fff;
 }
.div_header_3
{
 margin-left:1px;
 margin-right:2px;
 background:#fff;
 }
.row_style_tr
{
 text-align:center;
 font-size:14px;
 }
.row_style_td
{
 width:25%;
 background:#fff;
 border:1px solid #000;
 }
span
{
 background:#fff;
 }
</style>
<?php
include ("connect.php");
$per_page = 50;
$start = $_GET ['start'];
$record_count = mysql_num_rows (mysql_query("SELECT * FROM flats "));
$max_pages = $record_count / $per_page; // may come out as a decimal
if(!$start){$start = 0;}
$get = mysql_query("SELECT * FROM flats ORDER BY date_posted DESC LIMIT $start, $per_page");
?>
</head>
<body>
<table width="487px" height="672px" border="0" cellpadding="3" cellspacing="0" background="/bgtr.gif" class="table1">
 <tr>
  <td>
   <table cellpadding="0" cellspacing="0" class="table2">
    <tr class="title">
     <td>Available</td>
    </tr>
   </table>
  </td>
 </tr>
 <tr height="20px">
  <td>
   <table cellpadding="0" cellspacing="0" class="table2">
    <tr>
     <td class="td_header"><div class="div_header_1">Title</div></td>
     <td class="td_header"><div class="div_header_2">Type</div></td>
     <td class="td_header"><div class="div_header_2">Rent</div></td>
     <td class="td_header"><div class="div_header_3">Location</div></td>
    </tr>
   </table>
  </td>
 </tr>
 <tr valign="top" height="592px">
  <td>
   <table cellpadding="0" cellspacing="0" class="table2">
    <?php
    $prev = $start - $per_page;
    $next = $start + $per_page;
    while ($row = mysql_fetch_assoc($get))
    {
     // get data
     $select= $row['type'];
     $title= $row['title'];
     $location= $row['location'];
     $rent = $row["rent"];
     echo "<tr class='row_style_tr'>
            <td class='row_style_td'><b>$title</b></td>
            <td class='row_style_td'>$select</td>
            <td class='row_style_td'>$$rent</td>
            <td class='row_style_td'>$location</td>
           </tr>";
     }
    ?>
   </table>
  </td>
 </tr>
 <tr>
  <td>
   <table class="table3">
    <tr align="right">
     <td><span>
      <?php
      if($start>0){echo "<a href='londonfc_flats.php?start=$prev'> << Prev </a>";}
      $i=1;
      for ($x=0;$x<$record_count;$x=$x+$per_page)
      {
       if($start!=$x){echo "<a href='londonfc_flats.php?start=$x'>$i |</a>";}
       else{echo "<a href='londonfc_flats.php?start=$x'><b> $i|</b></a>";}
       $i++;
       }
      if($start<$record_count-$per_page){echo "<a href='londonfc_flats.php?start=$next'> Next >></a>";}
      ?>
     </span></td>
    </tr>
   </table>
  </td>
 </tr>
</table>

You should be able to see the navigation links on the bottom.

balamberas · #5 (**permalink**) 11-24-09, 05:28 AM

thanks man. its working fine now.

job0107 · #6 (**permalink**) 11-24-09, 08:09 AM

Your welcome. Glad I could be of assistance.

codehelper · #7 (**permalink**) 04-21-11, 11:03 AM

Please follow the link below, which will help providing google style paging e.g. 1 to 10, 20 to 30. Below is the link.

Features it will provide:
1. google style pagination.
2. number of records.
3. will hide next and previous when not required.

Follow this link :
Codehelper: Html Table Pagination