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 } ?>
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:
Post a Comment