Creating a Simple Pagination Using PHP and MySQL

[@NoelReinhardt]

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

[@DigitalFox-tutorials]

Glad it helped!

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

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

[@lazybusylog5081]

Thanks! Quick and easy explanation! Nice job!

[@DigitalFox-tutorials]

Thank you

[@conradunderwood6742]

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

[@DigitalFox-tutorials]

Glad it helped!

[@jpacs3738]

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

[@DigitalFox-tutorials]

Glad it was helpful!

[@bibliothecaEsoterica]

Thank you Sir, you helped me with my website

[@DigitalFox-tutorials]

Glad to hear that

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

[@aymdatenth1796]

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

[@DigitalFox-tutorials]

Glad you liked it

[@abdulghaffar3110]

Hi! very nice video for my project thanks.

[@cecilbennett289]

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

[@DigitalFox-tutorials]

Glad you liked it!

[@lordcarlocabangal5713]

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

[@DigitalFox-tutorials]

Thank you too.

[@VlkSamotar]

It was very useful for me. Thank you.

[@DigitalFox-tutorials]

Glad it was helpful!

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

[@marcofloriano]

Amazing tutorial nice job

[@DigitalFox-tutorials]

Thank you! Glad you liked it.

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

[@Ann-t1n]

thanks its really helpful

[@DigitalFox-tutorials]

Glad it helped

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

[@d.o.balogun3228]

Good job

[@DigitalFox-tutorials]

Thanks

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

[@nicodemoscarfo]

Nice tutorial, what would be the code for adding elipsis with a rang of 5 buttons like < 1... 5 6 7 8 9 10 ...99 >

[@rodolfosgc1882]

Gracias me funciono

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

[@NtiranyibagiraFelicien]

tHANKS bUT yOU eXPLAIN qUIKLY.

[@DigitalFox-tutorials]

Sorry about that

[@sam-j4zy]

Thanks alot

[@Japantalents]

Bruh I like ur voise 😂❤

[@lazy_coding]

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.

[@lazy_coding]

For page of numbers