Dans ce tutoriel, nous apprenons comment créer une pagination en utilisant PHP et MySQLi

Structure des fichiers pour ce tutoriel:

• config.php (fichier de configuration de la base de données)
• index.php (fichier principal)
• pagination.sql (structure de table SQL avec des données factices)

Créez d’abord une table pagination. Structure de pagination:

CREATE TABLE `pagination` (
  `id` int(10) NOT NULL,
  `FullNme` varchar(250) DEFAULT NULL,
  `EmpCode` int(10) DEFAULT NULL,
  `Department` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Insérez des données factices dans ce tableau.
Nous utiliserons le LIMIT clause de génération de la pagination.LIMIT La clause utilise deux arguments, l’un est OFFSET et le second est le nombre d’enregistrements renvoyés par la base de données.
Obtenir le numéro de page actuel
Nous utiliserons $_GET tableau pour obtenir le numéro de page actuel. Le numéro de page par défaut sera 1.

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

Formule de pagination

$total_records_per_page = 10;
    $offset = ($page_no-1) * $total_records_per_page;

Obtention du nombre total de pages

	$result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM pagination ");
	$total_records = mysqli_fetch_array($result_count);
	$total_records = $total_records['total_records'];
  $total_no_of_pages = ceil($total_records / $total_records_per_page);

Requête SQL pour la pagination

 $result ="SELECT * FROM pagination LIMIT $offset, $total_records_per_page";

Numérotation de pagination

>
 1){ echo "href="https://phpgurukul.com/?page_no=$previous_page""; } ?>>Previous


$counter";
}else{
echo "
$counter
";
}
}
}
elseif($total_no_of_pages > 10){

if($page_no <= 4) {
for ($counter = 1; $counter < 8; $counter++){
if ($counter == $page_no) {
echo "
$counter
";
}else{
echo "
$counter
";
}
}
echo "
...
";
echo "
$second_last
";
echo "
$total_no_of_pages
";
}

elseif($page_no > 4 && $page_no < $total_no_of_pages - 4) {
echo "
1
";
echo "
2
";
echo "
...
";
for ($counter = $page_no - $adjacents; $counter <= $page_no + $adjacents; $counter++) {
if ($counter == $page_no) {
echo "
$counter
";
}else{
echo "
$counter
";
}
}
echo "
...
";
echo "
$second_last
";
echo "
$total_no_of_pages
";
}

else {
echo "
1
";
echo "
2
";
echo "
...
";

for ($counter = $total_no_of_pages - 6; $counter <= $total_no_of_pages; $counter++) {
if ($counter == $page_no) {
echo "
$counter
";
}else{
echo "
$counter
";
}
}
}
}
?>

= $total_no_of_pages){ echo "class='disabled'"; } ?>>
>Next

Last ››";
} ?>

Voici le code complet que nous avons écrit au cours de ce tutoriel:

How to Create  Pagination Using PHP and MySQLi
";
        }
	mysqli_close($con);
    ?>



ID
Name
Employee Code
Department




			  
".$row['id']."
			  
".$row['FullNme']."
	 		  
".$row['EmpCode']."
		   	  
".$row['Department']."
		   	  



Page 



    
	
>
	 1){ echo "href="https://phpgurukul.com/?page_no=$previous_page""; } ?>>Previous
	
       
    $counter";	
				}else{
           echo "
$counter
";
				}
        }
	}
	elseif($total_no_of_pages > 10){
		
	if($page_no <= 4) {			
	 for ($counter = 1; $counter < 8; $counter++){		 
			if ($counter == $page_no) {
		   echo "
$counter
";	
				}else{
           echo "
$counter
";
				}
        }
		echo "
...
";
		echo "
$second_last
";
		echo "
$total_no_of_pages
";
		}

	 elseif($page_no > 4 && $page_no < $total_no_of_pages - 4) {		 
		echo "
1
";
		echo "
2
";
        echo "
...
";
        for ($counter = $page_no - $adjacents; $counter <= $page_no + $adjacents; $counter++) {			
           if ($counter == $page_no) {
		   echo "
$counter
";	
				}else{
           echo "
$counter
";
				}                  
       }
       echo "
...
";
	   echo "
$second_last
";
	   echo "
$total_no_of_pages
";      
            }
		
		else {
        echo "
1
";
		echo "
2
";
        echo "
...
";

        for ($counter = $total_no_of_pages - 6; $counter <= $total_no_of_pages; $counter++) {
          if ($counter == $page_no) {
		   echo "
$counter
";	
				}else{
           echo "
$counter
";
				}                   
                }
            }
	}
?>
    
	
= $total_no_of_pages){ echo "class='disabled'"; } ?>>
	>Next
	
    Last ››";
		} ?>

Voir la démo ————————————————————————-

Pagination avec les boutons suivant et précédent

Tutoriels recommandés pour vous