How to create Pagination with PHP and MySQL
<html> <head> <title>Pagination</title> <!– Bootstrap CDN –> <link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css”> <script src=”https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js”></script> <script src=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js”></script> </head> <body> <?php if (isset($_GET[‘pageno’])) { $pageno = $_GET[‘pageno’]; } else { $pageno = 1; } $no_of_records_per_page = 10; $offset = ($pageno-1) * $no_of_records_per_page; $conn=mysqli_connect(“localhost”,”my_user”,”my_password”,”my_db”); // Check connection if (mysqli_connect_errno()){ echo “Failed to connect to MySQL: ” . mysqli_connect_error(); die(); } … Read more