Awesome tutorial, each and every step is so crystal clear. First I totally watched it and then tried, it doesn't require me to look back to the tutorial again, so nicely he has explained.
you are great this video is really helpfull.for two days i fall in trouble to paginate pages this video remove my troubleness.I love you brother God bless u and all of your family members.
WOW !!!! This is the BEST tutorial I have ever seen for pagination. I have been struggling with doing this for a long time until I came across your video. Everything works GREAT and I actually understand it now. THANK YOU !!!
Very nicely and simple explained. Thanks for sharing this. Just one minor yet crucial part - the usage of prepared statements are missing. SQL injection concern is always present no matter how you embed external part of the SQL string into the main SQL sentence (for example, in the video where the LIMIT part consists of external variables. That's just in case when in the future something not trusted might get pasted into the SQL string. And also XSS injection in case that happens might be good to be aware of (when echoing the $page number).
Logic is quite exciting. Thank you mate, I'm learning PHP now and these pagination things always seemed wonderfull for me, even though it's very simple.
I was creating a blog model from scratch in which I needed to create a pagination system, this video helps me perfectly step by step. Thanks, also would like to know how to keep them SEO Friendly.
Thank you so much for this video. This helped alot. It's quite inspiring how this video from 6 years ago is still helping today lol. Thanks tho and God bless!
I think you should improve your code to add PREV ,NEXT buttons also set limit for pagers...else if we have ...lets say 1,000 pages ...pagers will be echoed 1,000 times....which is very awful
Good job! What I do not understand is why some people use the database connection in two lines, selecting the database name in the second line and not this one which seems more simple $con = mysqli_connect('localhost','root', '', ''databasename) ;
my code works perfectly but only for the first page , immediately when i select the second page it shows me all the page numbers with results i didnt apply the filter to
hi this tutorial is clean and clear.my doubt is suppose say there are 20000 records in the databse.I would like to display 50 records per page.Then the total no of pages are 400.Then how to display pagination?
i am using these code with where clouse and it work but when i click on next button it doesn't show anything and just showiing undefined variable name...what to do...???
Sir, 1) If the Total number of selected records(parameterized) is less than $results_per_page, how to disable or hide the pagination? 2) What if the number of selected record is huge, say more than 100, will it display more than 100 pagination links? Please reply. Thank You.
This tutorial is grate. Please i need a help on a section your your snippet. How can i change the result to display from latest entry. That is to display form back (latest entry) to the first (old Entry) in descending order. Thanks
That's not the best way to create a pagination system. In this way, if you have 3000 posts you will have 300 links in your pagination. The hardest part of the pagination system is showing current page, its next page and its previous page along with first page and last page
@@geren_pulse I was also kind of thinking about the number of links in the pagination when the number of posts increases.... You're right, so now I'll have to figure the hard part, showing the first and last link and also hiding some of the links....
Hello, I really hope you can see my comment at this time, your tutorial is great, but, I have a little bit problem. I am using server host which is cPanel phpmyadmin. When trying to redirect back to index page, its not working, and not display any data. Can you help me?
Amazing tutorial, loudest keyboard in the whole universe
hahaha
Call me weird but I love keyboard sounds like that. Very soothing
@@jeremievoyer6093 Same, like asmr keyboard coding xd
u explained flue and plain.great thanks
This should’ve broke the internet! Great Work! Can’t find this anywhere..not even in any of the php books I’ve bought! Thank you again!
I've watched a lot of pagination tutorial, but this is the simplest of it
tu sei un grande, in poche righe di codice hai fatto ciò che altri hanno fatto in un centinaio di righe. Sei un grande
Awesome tutorial, each and every step is so crystal clear. First I totally watched it and then tried, it doesn't require me to look back to the tutorial again, so nicely he has explained.
Simplest tutorial on youtube to implement pagination... Thank you
I wish everyone was explaining stuff as you do.
Great tutorial man!
Thank you!
He really explained it to the simplest way it can
you are great this video is really helpfull.for two days i fall in trouble to paginate pages this video remove my troubleness.I love you brother
God bless u and all of your family members.
Watched too many tutorials, this is the best. Simple and easy.
it's not just helpful bro, it's amazing , the way you explain and code, great work.
WOW !!!! This is the BEST tutorial I have ever seen for pagination. I have been struggling with doing this for a long time until I came across your video. Everything works GREAT and I actually understand it now. THANK YOU !!!
In the hall of geniuses you definitely have a seat, fantastic tutorial!!!
One of the best video still..!!, since 2016
Thanks dear for sharing your advanced knowledge ;)
Very useful for me.....your teaching is very awesome....
Very nicely and simple explained. Thanks for sharing this. Just one minor yet crucial part - the usage of prepared statements are missing. SQL injection concern is always present no matter how you embed external part of the SQL string into the main SQL sentence (for example, in the video where the LIMIT part consists of external variables. That's just in case when in the future something not trusted might get pasted into the SQL string. And also XSS injection in case that happens might be good to be aware of (when echoing the $page number).
Any one who can explain this issue in detail, please?
Awesome explanation!!!! loved the keyboard sound !!!! Amazing
idea of pagination video was indeed long-term thinking. thanks brother keep up
One of the best pagination video i have watched on youtube
Logic is quite exciting. Thank you mate, I'm learning PHP now and these pagination things always seemed wonderfull for me, even though it's very simple.
Finally, a short and simple code that works, immediate subscribed
I was creating a blog model from scratch in which I needed to create a pagination system, this video helps me perfectly step by step. Thanks, also would like to know how to keep them SEO Friendly.
Awesome! I added some extra options to show only 10 records per page on the pagination.
the best tutorial in the whole universe
So easily and clearly explained
You made it easy to understand it. Thank you very much for the tutorial 🇿🇦
Thank you so much for this video. This helped alot.
It's quite inspiring how this video from 6 years ago is still helping today lol. Thanks tho and God bless!
Thanks for the explanation! One of the best videos of pagination out there!
very easy to understand and really helpful...
Best Tutorial and helpful. thanks buddy:)
Very good. Your code is working fine. Thank very much for sharing. Best regards
excellent man, love from India
Concise and clearly explained - brilliant. Thanks!
best tutorial i ever seen on pagination.thanks
Just for your clarity, I've subscribed. Thanks mate, very easy to follow tutorial. 100 thumbs up.
Really well structured tutorial. Thanks for that!
Great, very, very helpfull. Thanks from Mexico.
Best pagination tutorial ever.Thank you Less.
i wish for you all the best , the best tutorial better than indians tutorials :'D
Works just perfectly.Thank you very much, sir.
very nice tutorial man, i could recreate it using PDO because i understand the logic beside the programm, you explain very well
easily and clearly understandable...thank you very much
Just what I was looking for to learn, Voyager thanks.
no wonder,useful in 2021
tqsm Sir
You've earned a subscriber for this great and straight to the point tutorial.
Works perfectly, thanks
I converted to PDO. Works great! Thanks!
Great Explanation man Very very helpful thanks a lot man...
Watched it just now. and it helped me. very useful
Easy and helpfull. keep up the good work mate
Thanks for the great tutorial..Nice and simple...Please continue the part-2 video with style sheet and remaining portions.Make it a complete tutorial
You are the best man, it was so helpful in my work. Thanks
Awesome! So easily explained. Thanks a lot!
THE BEST tutorial in the world .. Thank you
Great Tutorial, very simple and with a good explanation. it works great. I trying to add previous and next links using bootstrap
i Love the keyboard
simple and superb video
watched many tutorials, this one helped me alot
very gooooood tutorial , you explain it very well , thank you
Great, but what happens if we upload something thats not image, how to send error message back to view incase of errors
it's work on local host but when i upload it on live server it don't work can you please help me to solve this problem ??
I think you should improve your code to add PREV ,NEXT buttons
also set limit for pagers...else if we have ...lets say 1,000 pages ...pagers will be echoed 1,000 times....which is very awful
Yeah thats what im thinking, i manage to make the next and prev links for this code but i still dont know hoe to limit my links😭
Very nice tutorial, its very helpful :)
HriedoPotettoGam
99okkkkk0 A
..
₩$--
You are good man! You just made my day.
Nice video, thank you for sharing it.
Thanks great tutorial still works 2020
Super helpful and really clear! Thank you very much!
thanks!!Great tutorial..Iam implementing it somewhere
For advanced users you need to do a count then a second query with limit and offset.
Good job! What I do not understand is why some people use the database connection in two lines, selecting the database name in the second line and not this one which seems more simple $con = mysqli_connect('localhost','root', '', ''databasename) ;
in fact this is a good tutorial , thanks for your spared time.
Thank you VERY much. This code WORKED PERFECTLY! God bless you.
my code works perfectly but only for the first page , immediately when i select the second page it shows me all the page numbers with results i didnt apply the filter to
You explain it so well, thank you.
great and clean guide
I resolve my mistake thanks so much😊 Ultimate video Great work
goodjob bro my salary was doubled because of this tutorial
thankyou so much again
watching in 2020, still very helpful :)
hi this tutorial is clean and clear.my doubt is suppose say there are 20000 records in the databse.I would like to display 50 records per page.Then the total no of pages are 400.Then how to display pagination?
very good explanation..only query i have is that can we change the page index number design somehow...?
Thank you so very much, I am grateful for this.
I love this man!
Well explained!
Commended sir.
i am using these code with where clouse and it work but when i click on next button it doesn't show anything and just showiing undefined variable name...what to do...???
very goood and easy tutorial thanks sir
Sir,
1) If the Total number of selected records(parameterized) is less than $results_per_page, how to disable or hide the pagination?
2) What if the number of selected record is huge, say more than 100, will it display more than 100 pagination links?
Please reply. Thank You.
This tutorial is grate. Please i need a help on a section your your snippet. How can i change the result to display
from latest entry. That is to display form back (latest entry) to the first (old Entry) in descending order. Thanks
how about if its random(1,20) and 1 question per page
Thanks you our brother! it is very helpful.
Aww what a wonderful tutorial awww again!
Thumps up , quick to the point.
Ok this code is smart, as i type it in my IDE, i keep on asking myself "HOW DID HE FIGURE THIS OUT"...thank you man
That's not the best way to create a pagination system. In this way, if you have 3000 posts you will have 300 links in your pagination. The hardest part of the pagination system is showing current page, its next page and its previous page along with first page and last page
@@geren_pulse I was also kind of thinking about the number of links in the pagination when the number of posts increases.... You're right, so now I'll have to figure the hard part, showing the first and last link and also hiding some of the links....
@@ved_ituas you found a solution for prev and next bro ?
@@hmza-themes4786 Yeah i did, but its got a bit more code.
@@ved_ituas can you please share with me ?
Outstanding! Thank you!
That was very helpful! thank you
Very good tutorial thank you so much!
Hello, I really hope you can see my comment at this time, your tutorial is great, but, I have a little bit problem. I am using server host which is cPanel phpmyadmin. When trying to redirect back to index page, its not working, and not display any data. Can you help me?
how create next and previous buttons???
Any reason you choose to go against the industry standard PSRs?
Best tutorial man, thumbs up !
Thanks! amazing tutorial