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:
digitalfox-tut...
You can buy me a coffee and get the whole source code in a zip file.
www.patreon.co...

[@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...

[@DigitalFox-tutorials]

Glad to hear that! Thank you too.

[@NoelReinhardt]

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

[@DigitalFox-tutorials]

Glad it helped!

[@UrošSpasić-i3p]

Amazing tutorial, you explain things beautifully. Thank you!

[@DigitalFox-tutorials]

Thank you too

[@majeedpanahi5783]

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

[@DigitalFox-tutorials]

Glad it was helpful!

[@conradunderwood6742]

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

[@DigitalFox-tutorials]

Glad it helped!

[@lazybusylog5081]

Thanks! Quick and easy explanation! Nice job!

[@DigitalFox-tutorials]

Thank you

[@Ann-t1n]

thanks its really helpful

[@DigitalFox-tutorials]

Glad it helped

[@jpacs3738]

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

[@DigitalFox-tutorials]

Glad it was helpful!

[@VlkSamotar]

It was very useful for me. Thank you.

[@DigitalFox-tutorials]

Glad it was helpful!

[@aymdatenth1796]

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

[@DigitalFox-tutorials]

Glad you liked it

[@lordcarlocabangal5713]

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

[@DigitalFox-tutorials]

Thank you too.

[@marcofloriano]

Amazing tutorial nice job

[@DigitalFox-tutorials]

Thank you! Glad you liked it.

[@ngetsophea8812]

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.

[@sdsd-ec8rw]

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

[@DigitalFox-tutorials]

Hey, no i don't, but you are right. I will try to do a video on it.

[@dinidumadushan4749]

really helpful. thank you very much..

[@cecilbennett289]

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

[@DigitalFox-tutorials]

Glad you liked it!

[@abdulghaffar3110]

Hi! very nice video for my project thanks.

[@NtiranyibagiraFelicien]

tHANKS bUT yOU eXPLAIN qUIKLY.

[@DigitalFox-tutorials]

Sorry about that

[@d.o.balogun3228]

Good job

[@DigitalFox-tutorials]

Thanks

[@Iam_sami_8080]

Thanks alot

[@rodolfosgc1882]

Gracias me funciono

[@lowEndAppsAndGames]

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.

[@DigitalFox-tutorials]

Good idea, thanks, i will try.

[@majeedpanahi5783]

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?

[@DigitalFox-tutorials]

Hey, i know it's more convenient to use bootstrap, not only to create a pagination but other stuff to, but you must also know basic programming stuff like this one.

[@parakeetbird863]

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

[@DigitalFox-tutorials]

I will try

[@Japantalents]

Bruh I like ur voise 😂❤

[@photoinshot1355]

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

[@DigitalFox-tutorials]

Thank you. Yes, we can use javascript to fetch all the results, (titles), from the page and then search through them.

[@khalafnasirov]

i wrote For previous button ?page_num= For next button ?page_num=

[@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 if(!is_numeric($_GET["page-nr"]) || ($_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; }

[@PhongLan315]

Where to put that code?

[@OnyeStephen]

@@PhongLan315have the code where you set the page start point $page on the php scripts page

[@DigitalFox-tutorials]

@PhongLan315 Hey, replace the $page = $_GET['page-nr'] - 1; in the script.php file withe the clever solution that @OnyeStephen provided. I mean the whole if statement.

[@DigitalFox-tutorials]

@OnyeStephen Hey, nice, i had that in my mind but i forgot during the recording. Great work.

[@khalafnasirov]

For page of numbers