How To Implement Pagination in MySQL with PHP on Ubuntu 18.04
Pagination is the concept of constraining the number of returned rows in a recordset into separate, orderly pages to allow easy navigation between them, so when there is a large dataset you can configure your pagination to only return a specific number of rows on each page. In this tutorial, you’ll build a PHP script to connect to your database and introduce pagination to your script using the MySQL LIMIT clause.