Creating a simple pagination using php and mysql

In this tutorial we are going to explain step by step, how to create a
pagination using php and mysql.

You can read the article here:

You can buy me a coffee and get the whole source code in a zip file.

[HakanGalip]

Hey Digital Fox your video helps me solving a problem that i can not solve for a year... Thanks a lot and it is very good that teachers gives their inputs to others...

[majeedpanahi]

Thank you. Pagination is well explained in a professional-like manner.

[lazybusylog]

Thanks! Quick and easy explanation! Nice job!

[NoelReinhardt]

you explain this in a very easy understanding language! love this man! really helpful for my project

[ygnmvjb]

Amazing tutorial, you explain things beautifully. Thank you!

[jpacs]

Thank you so much! This is very helpful tutorial. You're awesome!

[abdulghaffar]

Hi! very nice video for my project thanks.

[conradunderwood]

Thanks for this video. It was easy to follow and helped me a lot

[aymdatenth]

thank you this was quick and easy without the use of bootstrap <3

[lordcarlocabangal]

very useful tutorial!!!! Thanks a lot!!!

[cecilbennett]

Wow this is a nice video man, thank you so much 💪💡

[ngetsophea]

I tested the style "active" in the JS on my end. I use +1 in stead of -1, it's working. I still don't know when I use -1, it's two steps behind the active page. For example, I am on page 4, but the active page show on page 2.

[YtResolver]

Hi thanks alot can you make the other one where you scroll to initiate the pagination to move to the next pages automatically without clicking do it with no frameworks like jquery and bootstrap as other youtubers have done it.

[parakeetbird]

can you make a video on how I can make it dynamic, where if I have more than 5 pages the next numbers would show us an ellipsis and the same if the first page number can't be seen

[sdsd-ecrw]

do you have a video for the case when there are a lot of pages that don't fit in the screen? I think it is important to address this case

[majeedpanahi]

I do have a question though. Why would a developer go through this long coding while he/she can use the Bootstrap 5 libraries? What is the advantage of one over another?

[photoinshot]

Great video thanks! Is there a way to search a paginated table?

[OnyeStephen]

Amazing tutorial, but as a curious student, if a user sets the page-nr = 0 or less than 0, it displays an error or says (showing -3434 of 10pages) is there a way to fix this so that if the value of the page-nr = 0 or less than 0 the page-nr is automatically set to 1. Used this code to fix it || ($_GET["page-nr"] <= 0) || ($_GET["page-nr"] > $pages) ){

//here we are making sure that if the user sets the page through the url a value that is not numeric, less than 0 or greater than the number of pages from the database, we referesh the page

header("Location:index.php");

} else {

$page = $_GET["page-nr"] - 1;
}