PHP Pagination with Bootstrap

Upgrade your Clever Techie learning experience:

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.

[bhaskarjyotideka]

Searched yt for almost 1hour on how to create links. This video is the exact solution to the problem that I was facing. Now, it is solved. Thank you.

[clevertechie]

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 :)

[CorreaLobo]

I like how your explaining the variables with the mechanics. sorry love it... thank you for taking your time to make this content, I appreciate your hard work!

[qub_global]

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

Hello from Latvia. :))

[williamjayinclino]

thank you for sharing your knowledge. You help me alot! You will be part in my speech during graduation :D

[Takio]

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.

Dude nice video. the best video about pagination with php so far on youtube. Congrats

[Takio]

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

[CoolBuys-ikeo]

I'm getting overlapping text when I use this to make it mobile friendly: <meta name="viewport" content="width=device-width, initial-scale=1" />. Please help me fix the CSS.
body {
background: #1f2739;
color: #fff;
font-family: "Arial";
font-size: 14px;
}
img {
border: 0;
padding: 0;
margin: 0;
}

#main-container {
padding: 20px;
}

.movie-container {
min-height: 200px;
background: #2c3446;
margin-top: 20px;
}

.left-column {
width: 88px;
float: left;
}

.right-column {
margin-left: 88px;
padding: 20px;
}

.header {
background: #363e4f;
padding: 15px;
}

h1 {
color: #fb667a;
font-size: 18px;
font-weight: bold;
display: inline;
}
.year {
color: #fff;
font-size: 18px;
}
.content {
background: #2c3446;
}
.content.description {
color: #9d99a7;
height: 85px;
margin-top: 15px;
}
.content.text {
color: #9d99a7;
}
.content.blue {
color: #4dc3fa;
}
.content.yellow {
color: #fff842;
}
.content.green {
color: #7ffc62;
}
a {
text-decoration: none;
color: #9d99a7;
}
#ratings {
font-size: 20px;
font-weight: bold;
text-align: center;
line-height: 38px;
color: #000;
width: 87px;
}
.imdb {
background: #f2cc70;
}
.metascore {
background: #61c74f;
}
.bottom {
margin-top: 15px;
}

Thanks

[swathikc]

Can you please share the source code? I am not able to access it.

[Kigris]

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!

[antwarior]

man how did you get the css up like how you did, thats exactly what im looking for, how did you get the content to show up in those display boxes

[ifrashable]

very good logic explanation and presentation, ,

[novatech]

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?

[suhrabahdi]

I really appreciate you! you are the best...

[Asimov]

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.

[rafaelafrico]

Hi, very good tutorial. Congratulations!

[vindesign]

if no result to show its echoing Undefined variable: results in on line 64

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

[avertry]

thanks.
FYI: it's queer-re or kweery Not Cure-re -y as your inquiring an answer or questioning.

[adilismail]

serously need to pay to unlock the files ??