Pages

Sunday, 12 May 2013

Pagination using php

Pagination is used when number of rows are maximum then these rows are divided into pages.
pagination is the important part of web development.(pagination in php,how to apply pagination in table using php)
Now lets try

<?php

       //connect to database
       // now start with query
               $rs=mysql_query("select * from table_name");

       //how many rows  you wants to show in one page. define a variable limit
               $limit=30;

      //how many rows are fetch into database.
$totalpage=mysql_num_rows($rs);
if($totalpage>$limit){
$totalPages=($totalpage/$limit);

      //check if pages are in float then add 1
                   if(is_float($totalPages)){
$totalPages=$totalPages+1;
}
} // end if

       // page is variable that contain page number
$page=(isset($_GET['page']))?(int) $_GET['page']:1;
$start =($page==1)?0:($page - 1) * $limit;

       //again apply query using limit

              $rs=mysql_query("select * from table_name  limit $start,$limit");

       while($row=mysql_fetch_array($rs)){

     //show data into table
   echo "<table><tr>";
   echo "<td>".$row["id"]."</td>";
           echo "<td>".$row["name"]."</td>";
                   echo "</tr></table>";

      //start a loop using variable $i
               for($i=1;$i<=$totalPages;$i++) { 
    ?>
                   <a href="<?php echo "page_name.php?page=$i" ?>" title=""><?php echo $i;  ?></a>

      <?php }  ?>




No comments: