Join our fast growing Clever Techie patreon community of 182+ members:

UPDATE! (9/13/19) New features and improvements for Clever Techie Patreons:

1. Download full source code with detailed comments – easy to learn and understand code
2. Weekly source code file updates by Clever Techie – every time I learn new things about a topic I will add it to the source file and let you know about the update – keep up with the latest coding technologies
3. Library of custom Clever Techie functions with descriptive, easy to understand comments – skyrocket coding productivity, code more efficiently by using Clever library of custom re-usable functions
4. Syntax code summary – memorize and review previously learned code faster
4. Organized file structure – access all Clever Techie lessons, source code, graphics, diagrams and cheat sheet from a single workspace – no more searching around for previously covered material and source code – save enormous amount of time and effort
5. Outline of topics the source file covers – fast review of all previously learned coding lessons
6. Access to all full HD 1080p videos with no ads
7. Console input examples – interactive examples that make it easier to understand and learn coding
8. Access to updated PHP Programming Book by Clever Techie
9. Early access to Clever Techie videos

Download this video’s files here:

Incorporating Paginator class on any PHP page that needs to list MySQL data records on multiple pages takes minutes. However, understanding what’s going on under the hood takes some time. In this PHP Pagination with Bootrap tutorial, we explore the mechanics of a Paginator class and how the MySQL limit keyword is used to limit the amount of records we want to be returned from our query. We then go over how all the links are created which is the most complex part about pagination. There are many subtle details that go into creating pagination but our class takes care every little thing that we throw at it. To make things look pretty, we incorporate Bootstrap which gives us a beuatiful, user friendly pagination links that we can use on any web site. Please like the video if you found it useful and subscribe to the channel, I hope you guys enjoy learning from this PHP pagination with Bootstrap tutorial as much as I enjoyed making it. Cheers.

Comments (27)

  1. Hey clever techie do you have breadcrumb (like Home > Series > power > season 5 > episode 10) or like (
    Home > Home & Kitchen > Home D�cor > Clocks > Alarm Clocks ) tutorials with categories saved in mysql database. If not please make one…..

  2. if no result to show its echoing this::::::::::Notice: Undefined variable: results in G:xampphtdocsmatrimonyincludesclassesPaginator.php on line 64

    Warning: count(): Parameter must be an array or an object that implements Countable in G:xampphtdocsmatrimonylist.php on line 263

  3. I think you should pass your query into your class, otherwise the class can only be used for one query. I use a pagination function rather than a class, and I pass in my query and number of pages rather than having them in the function. It then makes your function or class more useable for different datasets.

  4. when the query outputs 0 rows you can click through emtpy pages, since the next page button isn't blocked then ^^

    When adding the option to show only online users for example, when there is nobody online then.

  5. Thank ypu very much for this class. Was exactly what i was searching for. I just added a goto dropdown which also checks for max and min page. Happy new Year

  6. hey bro can you email me the final full copy of your project please at need it for my project.. the link you provided shows split coding , i want all

  7. Hello! I'm a newbie in PHP, so my question is: Why do you store the _ variables ($_page, $_query,$_total,etc) like $page, $query, $total, etc? Why can't you use them directly? Thanks!

  8. hey celver techie, thanks for the video tutorial, i'd like to modify the pagination links by my own e.g. to make the numbers red how can i do it?

  9. Огромное спасибо, Clever Techie! Наконец получилось релизовать пагинацию на сайте.
    Thanks a lot, Clever Techie! Finally got to realize pagination.

    Hello from Latvia. :))

  10. Hi,
    Clever Techie, I do support you and highly appreciate your efforts and guide. I would be so grateful to you and would also suggest you that you should have done it from scratch rather than explaining script because there are a lot of pre-build scripts available across internet but so many peoples like me don't know how to manage them from start to finish like which steps comes when and does what? hope you get it i did like and subscribed to your channel.

    One thing i would also immensely request you to do is to do a tutorial on custom functions in php especially how its Arguments work as Arguments are still kinda confusing for me, Can you do it?

  11. Would be nice to hear feedback from the person who disliked this video so I can improve future videos, let me know if you reading this 🙂

Comments are closed.