Pagination In PHP

Written by     on    10 Sep, 2019     0      

I am going to explain how to create pagination using PHP and MySQLi

What is pagination?

You have a form which allows the user to browse through the rows in a database table, what do you do if that table has hundreds or even thousands of rows? It would not be a good idea to show all those rows in a single form, instead you should split the database output into more manageable chunks or ‘pages’. There are two things you must do:

  • Decide on the maximum number of database rows that can be included in each page. You may hard code this value, or you can define it in a variable so that the value may be changed at runtime.
  • You then need to inform the user that other ‘pages’ are available and provide a mechanism whereby the user is able to select a different ‘page’ of details.

Pagination in PHP only 3 steps

  1. connect to a database mysql.
  2. set Your table name.
  3. set $limit – how many show per page rows.

Below HTML & PHP Code (index.php) code COPY & PASTE in your text editor

 <!DOCTYPE html>
<html lang="en">
  <title>Pagination in php</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="">
  <script src=""></script>
  <script src=""></script>

<!-- jumbotron -->
<div class="jumbotron" style="padding:10px 0;">
      <h1>Pagination in PHP</h1>      
      <p>Guide how to create a pagination using PHP and MySQL.</p>

<!-- container start -->
<div class="container">

$link = mysqli_connect("localhost", "root", "","demo_load_data");
//Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());

//Default Limit = 15 && Page = 1
$limit = 15;
$page = 1;
//check url "n" to get value n and set var page;
if(isset($_GET['n']) && $_GET['n'] != "") {
  $page = $_GET['n'];

$start = ($page-1) * $limit;  
$query = "SELECT * FROM `tbl_country_master` LIMIT $start, $limit";  
$result = mysqli_query($link,$query);  

  <!-- Start Table -->
  <table class="table table-striped">  
      <tr style="background-color:#F26C37;color:#fff;"><th width="50">#</th><th>Country Name</th></tr>  

      //start loop
      while($data = mysqli_fetch_array($result)) {  

          <td><?php echo $data[0]; ?></td>  
          <td><?php echo $data[1]; ?></td>  

    <?php } //end loop ?>  

  <!-- End Table -->

//start page get
//Get table total recode number & set page number like (1,2,3,4...)
$query_row = "SELECT `countryId` FROM `tbl_country_master`";  
$result_row = mysqli_query($link, $query_row);  
$row = mysqli_num_rows($result_row);

//The ceil() function is a built-in function in PHP and is used to round a number to the nearest greater integer.
$total_pages = ceil($row / $limit);

  $page_html = "<ul class='pagination'>";  
  for ($i=1; $i<=$total_pages; $i++) {  
    //current page active start
    $active = "";
    if($page == $i){
      $active = 'class="active"';
    //current page active end
    $page_html .= "<li ".$active."><a href='index.php?n=".$i."'>".$i."</a></li>";  
  $page_html ."</ul>";  

echo $page_html;
//end page get

<!-- container end -->




Pagination-in-php Demo

Tags :  dynamic pagination in php with mysql exampleHow To Create a Paginationhow to create a pagination using PHP and MySQLHow to create Pagination with PHP and MySqlHow to make PHP Pagination With Example and DemoPHP PaginationSimple PHP Pagination script

Write a Reply or Comment

Your email address will not be published. Required fields are marked *

Submit Guest Post Content
Are you a passionate writer or expert in our categories? You can submit content on our website. Before writing content, you should read our guest posting guidelines.
Read More
Get the latest posts and awesome deals delivered to your inbox for free. 100% Privacy.