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-tutorials.com/tuto...
You can buy me a coffee and get the whole source code in a zip file.
www.patreon.com/Digitalfox13/...

[@NoelReinhardt]

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

[@DigitalFox-tutorials]

Glad it helped!

[@lazybusylog5081]

Thanks! Quick and easy explanation! Nice job!

[@DigitalFox-tutorials]

Thank you

[@user-yg1nm6vj4b]

Amazing tutorial, you explain things beautifully. Thank you!

[@DigitalFox-tutorials]

Thank you too

[@dinidumadushan4749]

really helpful. thank you very much..

[@conradunderwood6742]

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

[@DigitalFox-tutorials]

Glad it helped!

[@abdulghaffar3110]

Hi! very nice video for my project thanks.

[@jpacs3738]

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

[@DigitalFox-tutorials]

Glad it was helpful!

[@marcofloriano]

Amazing tutorial nice job

[@DigitalFox-tutorials]

Thank you! Glad you liked it.

[@lordcarlocabangal5713]

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

[@DigitalFox-tutorials]

Thank you too.

[@rodolfosgc1882]

Gracias me funciono

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

[@samuelagbo2947]

Thanks alot

[@cecilbennett289]

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

[@DigitalFox-tutorials]

Glad you liked it!

[@d.o.balogun3228]

Good job

[@DigitalFox-tutorials]

Thanks

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

[@NtiranyibagiraFelicien]

tHANKS bUT yOU eXPLAIN qUIKLY.

[@DigitalFox-tutorials]

Sorry about that

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

[@Animeheavens]

Bruh I like ur voise 😂❤

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

[@DigitalFox-tutorials]

Good idea, thanks, i will try.

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

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

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