pagination

DataBase:

 <?php include("conn.php");
 ini_set ( 'max_execution_time', 1200);
 $tableName="messages";
 $targetpage = "index.php";
 $limit = 5;

 $query = "SELECT COUNT(*) as num  FROM $tableName";
 $total_pages = mysql_fetch_array(mysql_query($query));
 $total_pages = $total_pages[num];

 $stages = 3;
 $page = mysql_escape_string($_GET['page']);
 if($page){
  $start = ($page - 1) * $limit;
 }else{
  $start = 0;
  }

  // Get page data
 $query1 = "SELECT * FROM $tableName LIMIT $start, $limit";
 $result = mysql_query($query1);

 // Initial page num setup
 if ($page == 0){$page = 1;}
 $prev = $page - 1;
 $next = $page + 1;  
 $lastpage = ceil($total_pages/$limit);
 $LastPagem1 = $lastpage - 1;
?>

CSS:

.paginate {
font-family:Arial, Helvetica, sans-serif;
 padding: 3px;
 margin: 3px;font-weight:bold;
}
.paginate a {
 padding:2px 5px 2px 5px;
 margin:2px;
 border:0 solid #999;
 text-decoration:none;  background-color:#666;
 color: #fff;font-weight:bold;
}
.paginate a:hover, .paginate a:active {
 border: 0 solid #999;
 background-color:#79FF79; font-weight:bold;
}
.paginate span.current {
    margin: 2px;
 padding: 2px 5px 2px 5px;
  border: 0 solid #999;

  font-weight: bold;
  background-color:#0F0;
  color: #FFF;
 }
 .paginate span.disabled {
  padding:2px 5px 2px 5px;
  margin:2px;
  background-color:#666;
  border:0 solid #eee;
  color:#DDD;font-weight:bold;
 }

index.php:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<!--Head start -->
  <tr><td style="height:110px; background-color:#FEFEFE;" align="center"> <img src="images/2.gif" width="656" height="105" align="middle" alt="" /></td> </tr>
<!--Head end -->
<!--menu start -->
  <?php /*?><tr> <td><?php include("menu/index3.php"); ?></td></tr>
<?php */?>  <!--menu end -->
  <tr><td>&nbsp;</td></tr>
  <!-- description -->
  <tr> <td><table width="80%" cellpadding="5" align="center"><tr><td align="center" class="th">Parts Catalogue View</td></tr></table></td></tr>
 <tr><td>&nbsp;</td></tr>
 <tr><td align="center">
    <?php
 $paginate = '';
 if($lastpage > 1)
 {
  $paginate .= "<div class='paginate'>";
  // Previous
  if ($page > 1){
   $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
  }else{
   $paginate.= "<span class='disabled'>previous</span>"; }


  // Pages
  if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
  {
   for ($counter = 1; $counter <= $lastpage; $counter++)
   {
    if ($counter == $page){
     $paginate.= "<span class='current'>$counter</span>";
    }else{
     $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
   }
  }
  elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
  {
   // Beginning only hide later pages
   if($page < 1 + ($stages * 2))
   {
    for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
    {
     if ($counter == $page){
      $paginate.= "<span class='current'>$counter</span>";
     }else{
      $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
    }
    $paginate.= "...";
    $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
    $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
   }
   // Middle hide some front and some back
   elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
   {
    $paginate.= "<a href='$targetpage?page=1'>1</a>";
    $paginate.= "<a href='$targetpage?page=2'>2</a>";
    $paginate.= "...";
    for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
    {
     if ($counter == $page){
      $paginate.= "<span class='current'>$counter</span>";
     }else{
      $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
    }
    $paginate.= "...";
    $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
    $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
   }
   // End only hide early pages
   else
   {
    $paginate.= "<a href='$targetpage?page=1'>1</a>";
    $paginate.= "<a href='$targetpage?page=2'>2</a>";
    $paginate.= "...";
    for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
    {
     if ($counter == $page){
      $paginate.= "<span class='current'>$counter</span>";
     }else{
      $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
    }
   }
  }

    // Next
  if ($page < $counter - 1){
   $paginate.= "<a href='$targetpage?page=$next'>next</a>";
  }else{
   $paginate.= "<span class='disabled'>next</span>";
   }

  $paginate.= "</div>";


 }
 // pagination
 echo $paginate;?></td></tr>
 <tr><td style="background:none;">

 <BR />
 <table width="80%" border="0" cellspacing="2" class="tab1" cellpadding="5" align="center" style="text-align:center;">
  <tr class="tr"><td style="width:15px;">S.no</td><td style="width:50px;">Messages</td><td style="width:25px;">Edit</td><td style="width:25px;">Delete</td></tr>
       <?php
   
  $i=1;
    while($row1=mysql_fetch_array($result))
    {
     $messages=$row1['message'];
      $id=$row1['id'];
     ?>
      
     <tr class="tr1"><td><?php echo $i++; ?></td>
     <td><?php echo $messages; ?></td>
     <td><a href="edit_parts.php?edit=<?php echo $id; ?>"><img
      alt="edit" /></a></td>
     <td><a href="edit_parts.php?delete=<?php echo $id; ?>"> <img
     alt="delete"   onclick="return confirm('Really You want Delete this Parts');"  /></a></td></tr>
     <?php
    }
  
   
   
   ?>
 </table>
    </td></tr>
    <tr><td>&nbsp;</td></tr>
    <tr><td align="center">
    <?php
 $paginate = '';
 if($lastpage > 1)
 {

  $paginate .= "<div class='paginate'>";
  // Previous
  if ($page > 1){
   $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";
  }else{
   $paginate.= "<span class='disabled'>previous</span>"; }


  // Pages
  if ($lastpage < 7 + ($stages * 2)) // Not enough pages to breaking it up
  {
   for ($counter = 1; $counter <= $lastpage; $counter++)
   {
    if ($counter == $page){
     $paginate.= "<span class='current'>$counter</span>";
    }else{
     $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
   }
  }
  elseif($lastpage > 5 + ($stages * 2)) // Enough pages to hide a few?
  {
   // Beginning only hide later pages
   if($page < 1 + ($stages * 2))
   {
    for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)
    {
     if ($counter == $page){
      $paginate.= "<span class='current'>$counter</span>";
     }else{
      $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
    }
    $paginate.= "...";
    $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
    $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
   }
   // Middle hide some front and some back
   elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))
   {
    $paginate.= "<a href='$targetpage?page=1'>1</a>";
    $paginate.= "<a href='$targetpage?page=2'>2</a>";
    $paginate.= "...";
    for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)
    {
     if ($counter == $page){
      $paginate.= "<span class='current'>$counter</span>";
     }else{
      $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
    }
    $paginate.= "...";
    $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";
    $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";
   }
   // End only hide early pages
   else
   {
    $paginate.= "<a href='$targetpage?page=1'>1</a>";
    $paginate.= "<a href='$targetpage?page=2'>2</a>";
    $paginate.= "...";
    for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)
    {
     if ($counter == $page){
      $paginate.= "<span class='current'>$counter</span>";
     }else{
      $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}
    }
   }
  }

    // Next
  if ($page < $counter - 1){
   $paginate.= "<a href='$targetpage?page=$next'>next</a>";
  }else{
   $paginate.= "<span class='disabled'>next</span>";
   }

  $paginate.= "</div>";


 }
 // pagination
 echo $paginate;?></td></tr>
    <tr><td colspan="8" align="middle" style="line-height:2em;"> <img src="images/Actions-edit-add-icon.png" width="32" height="32" align="top" alt="" />
            <a href="add_parts.php"><span style="color:#FF0; font-weight:bold;">Add Parts</span></a></td></tr>
 </table>

Template Design Using Div Concept

home.php

<div id="container">
<!--Header start-->
<div class="header">
    <div class="header-left">
    <img src="TwinTower.gif" width="160" height="120"/>
     </div>
     <div class="header-center">TECHWISDOM</div>
     <div class="header-left">SEARCH<input type="text" name="search" />
  </div>
 
</div>
<!--Header end-->
<div style="clear:both;"></div>
<!--menu start-->
<div class="menu">
<ul class="menu1">
    <li><a href="home.php">HOME</a></li>
    <li><a href="about-us.php">ABOUT US</a></li>
    <li><a href="support.php">SUPPORT</a></li>
    <li><a href="service.php">SERVICE</a></li>
    <li><a href="contact-us.php">CONTACT US</a></li>
 </ul>
</div>
<!--menu end-->
<!--main start-->
<div class="main">
  <div class="main-left">
  <p main-left-para>Tamil Nadu is amongst the 28 states of India and is the 11th sate in the country and ranked 7th in terms of population. Tamil Nadu occupies the extreme south of the Indian peninsula and has a rich cultural heritage. Bharatnatyam and Carnatic Music have flourished here for centuries. The state is also famous for its handicrafts made of wood, stone and metal. This state is also the source of forest products like sandalwood, timber, fuel-wood and crops like, sugarcane, groundnut, potatoes and spices. Tamil Nadu state is divided into 32 districts.
  </ pmain-left-para>
</div>
  <div class="main-center"></div>
  <div class="main-right"></div>
 
</div>
<!--main end-->
<div style="clear:both;"></div>
<!--footer start-->
<div class="footer">
  <div class="footer-left">
        <p>website:</p>
        <p>suganjayaram@gmail.com</p>
        <p>&nbsp;</p>
  </div>
  <div class="footer-center">
        <p>gyfgoufgu<br />higuygu<br /><p>
  </div>
  <div class="footer-right">
        <p>sponsors:</p>
        <p>gihghi</p>
  </div>
 
<!--footer end-->
<div style="clear:both;"></div>
</div>