GetNumberOfRo"> GetNumberOfRo">

Pagination example with previous and next in php

$record = 75;
$condition = "";
if(isset($_GET['page_no']) && $_GET['page_no'])
{
 $page_no = $_GET['page_no'];
}else
{
    $page_no = 1;
}

$condition =""; 
$table = "table_name";

$rec = 0;
$reqpage = explode('?',$_SERVER['REQUEST_URI'])[0];
$total = $obj->GetNumberOfRows($table,$condition);
    $pages = $total / $record;

    $rec = ($page_no - 1) * $record;
    $prev = $page_no - 1;
    $next = $page_no + 1;
    $prevlinks = "";
    $nextlinks = "";
    $pages = ceil($pages);
    if($prev >= 1)
    {
    $prevlinks = "<li class='page-item'>
      <a class='page-link' href='$reqpage?page_no=$prev' aria-label='Previous'>
        <span aria-hidden='true'>&laquo;</span>
        </a>
    </li>";
    }
    if($next <= $pages)
    {
    $nextlinks = "<li class='page-item'>
      <a class='page-link' href='$reqpage?page_no=$next' aria-label='Next'>
        <span aria-hidden='true'>&raquo;</span>
        </a>
    </li>";
    }
  echo "<nav aria-label='Page navigation example' class='mt-3'>
  <ul class='pagination'>".$prevlinks." <li class='page-item'><a class='page-link bg-primary text-white'>&nbsp;$page_no&nbsp;</a></li> ".$nextlinks." </ul></nav>";
  }

$objresult=$obj->GerFunction($para1,$para2,$para3,$rec);



Leave a Reply