Snippets Collections
<?php 				
$servername = "";
$username = "";
$password = "";
$dbname = "";
$conn = mysqli_connect($servername, $username, $password, $dbname);

$showRecordPerPage = 10;
	if(isset($_GET['page']) && !empty($_GET['page'])){
		$currentPage = $_GET['page'];
	}else{
		$currentPage = 1;
	}
	$startFrom = ($currentPage * $showRecordPerPage) - $showRecordPerPage;
	$totalEmpSQL = "SELECT * FROM sem";
	$allEmpResult = mysqli_query($conn, $totalEmpSQL);
	$totalEmployee = mysqli_num_rows($allEmpResult);
	$lastPage = ceil($totalEmployee/$showRecordPerPage);
	$firstPage = 1;
	$nextPage = $currentPage + 1;
	$previousPage = $currentPage - 1;
	$empSQL = "SELECT * FROM `sem` WHERE is_visible = 1 ORDER BY shortby LIMIT $startFrom, $showRecordPerPage ";
	$empResult = mysqli_query($conn, $empSQL);		
 ?>

<?php
	while($emp = mysqli_fetch_assoc($empResult)){
?>

<div class="reg-box1 mb-3">
	<a href="admin/<?php echo $emp["file_link"];?>" target="_blank">
		<div class="bg-grey02 ">
			<div class="reg-download-pdf">
				<span><i class="fa fa-file-pdf-o" aria-hidden="true"></i></span> <?php echo $emp["title"];?>
			</div>
		</div>
	</a>
</div>


<?php
	}
?>

<!-- pag -->
<nav aria-label="Page navigation example mt-5">
	<ul class="pagination justify-content-center">
		<li class="page-item <?php if($currentPage <= 1){ echo 'disabled'; } ?>">
			<a class="page-link"
			href="<?php if($currentPage <= 1){ echo '#'; } else { echo "?page=" . $previousPage; } ?>">Previous</a>
		</li>
		<?php for($i = 1; $i <= $lastPage; $i++ ): ?>
		<li class="page-item <?php if($currentPage == $i) {echo 'active'; } ?>">
			<a class="page-link" href="?page=<?= $i; ?>"> <?= $i; ?> </a>
		</li>
		<?php endfor; ?>
		<li class="page-item <?php if($currentPage >= $lastPage) { echo 'disabled'; } ?>">
			<a class="page-link"
			href="<?php if($currentPage >= $lastPage){ echo '#'; } else {echo "?page=". $nextPage; } ?>">Next</a>
		</li>
	</ul>
</nav>
star

Sat Jan 21 2023 07:23:21 GMT+0000 (Coordinated Universal Time) https://codingstatus.com/how-to-create-pagination-in-php-mysql/

#pagination #corephp

Save snippets that work with our extensions

Available in the Chrome Web Store Get Firefox Add-on Get VS Code extension