Oh! Alex, Even after so many years, this tutorial trumps everything else like it on UA-cam. I wish you created a way to link this pagination with a Search field. It will be a lifesaver if you do. Remain blessed Bro., for sharing.
Thank you so much! I changed a few things better to my knowledge, but this was so helpful! I just started to code a few months ago and even 8 years later this tutorial was super helpful :D
I loved the intorduction to php mysqli videos. Those provided a fair start against previous versions of mysql. But this time I cannot agree that this is a Super Simple Pagination video to deal with! I believe that are some much more to use as guide to the proper needs. This post is only for those who seeking for faster ways to apply to their needs Thank you for your efforts so far...
great Alex for your work. May God bless you genuinely ... I have never entered web design class but through php academy, i have got my future... am now a great and a big internet application programmer,,,, thanks Alex for your kindness
Great tutorial! I love your way of doing this, first I googled and found some articles, but they use deprecated way of connecting database, nice to watch and followed doing with this video.
Alex, if it wasn't for your teaching i doubt the last 1.5 years would have been anywhere near as productive. Even though i don't need to implement pagination, i like to watch your videos just to find better ways of coding. I know this is very broad, but i think a video detailing best pactises and tips for efficiency at an intermediary level would be popular. Great vids
It would be nice to limit number of pages to 5 at a time ex. 1 2 3 4 5 , and then as you click 5 - the pages change to 5 6 7 8 9, then as you click 9, pages change to 9 10 11 12 13, similarly on the downside.. and have a next previous buttons which do the same thing... perhaps in another tutorial or maybe a link to guide us...
Great video, I have only one question... in the video you selected "per-page = 1" and it showed 56 pagination results, so... how could I limit that to show for example, only 10 results instead of 56 ?
Hi Alex, very helpful tutorial. I've just followed your procedure and everything's working great one little problem. I had a counter variable that I used to display the serial numbers for each rows. But that counter variable isn't display the correct row number anymore. Every time I'm on a new page, the counter variable resets back to 1. Any idea how I can fix that? Thanks again!!
how can you make a page list of atleast 5 example: 1 2 3 4 5, then when user clicked page 5 it will result like this: 3 4 5 6 7. So that the pagination will not be too long?
For finding the positioning where your setting start instead of doing: ($page * $perPage) - $perPage Wouldn't be quicker and easier to do: ($page-1) * $perPage Better efficiency as system doesn't have to retrieve $perPage twice from memory.
You can absolutely do it like that. I just wanted to be very explicit in the way I explained it. Thanks for the comment, useful to many people I'm sure.
***** I like Alex far better. Nothing personal against Adam Khoury, but his monotone voice and metronome-like cadence has me nodding off at the computer. To each his own as they say.
i accidentally wrote $start without curly brackets. and i got values in -ve. so i declared in curly brackets then i didn't get -vr values so i guess that's why curly brackets been used.
Sir, if i run a query using SELECT * FROM table WHERE id LIKE '%anything%'. results in 1st page are ok but on the next pages its just blank pages...
8 років тому
When I apply the CSS, it has no impact on the numbers, i've checked multiple times, it is the same and correct file. I've also use "List-style-type = none" But still nothing Did anyone encoutered this problem ? Thank you
Doesn't this leave security issue where user can exploit get requests and send dozens of them at the same time ? Sounds like good way to ddos the server since php would have to query each of those requests from mysql. Btw I know this is made just for the sake of this tutorial just asking.
My god, don't be like that kind of guy, just watch the video while coding it, you will learn from that way. You won't learn from just watching doing nothing, especially if you're a newbie. -_-
Phpacademy you are... AWESOME! I've been looking for this my whole life! It is hard when you are from none english speaking country and you dont know how to say what you are looking for. Thank you :D
This is best UA-cam channel to learn php. I am started watching php academy daily basis. Alex is a great teacher
Very kind of you, thanks!
Oh! Alex,
Even after so many years, this tutorial trumps everything else like it on UA-cam.
I wish you created a way to link this pagination with a Search field. It will be a lifesaver if you do.
Remain blessed Bro., for sharing.
Thank you so much! I changed a few things better to my knowledge, but this was so helpful! I just started to code a few months ago and even 8 years later this tutorial was super helpful :D
Nice tutorial. the best YT channel
I loved the intorduction to php mysqli videos. Those provided a fair start against previous versions of mysql.
But this time I cannot agree that this is a Super Simple Pagination video to deal with!
I believe that are some much more to use as guide to the proper needs.
This post is only for those who seeking for faster ways to apply to their needs
Thank you for your efforts so far...
I Like that you didn't stop at the 2011's pagination tutorial, you came with another idea for it, and that's cool as usual from you :) thanks alot.
great Alex for your work. May God bless you genuinely ... I have never entered web design class but through php academy,
i have got my future... am now a great and a big internet application programmer,,,, thanks Alex for your kindness
Thank you so much. You learned me how to make such pagination at such an easy way of explaining. You're amazing!
hi alex garret . You are really a boss public.I have actually learnt php implementation from you.thanks a lot again :)
Simple, clear and on point!!! Thanks
Hi,
You can erase the if statement on the $start variabile, because if the $page is 1, $start will be even zero... (1 * 5) - 5 = 5-5 = 0 ;)
Wow really Super.... Thank you very much!!! May God bless you! The Very best tutorial i ever seen! Thank You again.
Very clearly explained.You are doing a great job.
Great tutorial! I love your way of doing this, first I googled and found some articles, but they use deprecated way of connecting database, nice to watch and followed doing with this video.
Alex, your videos rock!
Thx for you tutorial. I didn't find anything new for me, but it was very interesting. Good job!
Yeez, big thanks for this! :) you've earned yourself a new follower for sure. Trying to learn php a bit more in depth and this was next on my agenda
I love this channel!
Alex, if it wasn't for your teaching i doubt the last 1.5 years would have been anywhere near as productive. Even though i don't need to implement pagination, i like to watch your videos just to find better ways of coding.
I know this is very broad, but i think a video detailing best pactises and tips for efficiency at an intermediary level would be popular.
Great vids
Best tutorial on php pagination. Thanks
Great tutorial...many thanks!
Alex is back!!
where?
Great tutorial and easy to understand, your super awesome!. Keep it up.
ALEX ... OUR PHP HERO....
Very good tutorial, Thanks.
i was waiting for this kind of video. thank you :)
It's very very helpful for me. Thank you so much.
thank you very much!! this tutorial is so helpful :)
Thank you very much!
Thanks Sir, for your great services
Awesome! Cool to see some new videos flowing. Although I feel like we need some new small projects like the URL shorten er you did a while back! :)
Great!
I'm really like this channel, please upload more videos in php social network
Many thanks dear!
very good, thank you very much.
Thank you for this tutorial, I hope you do a tuto for us using slim3. thank you
awesome!!! keep making cool videos
It would be nice to limit number of pages to 5 at a time ex. 1 2 3 4 5 , and then as you click 5 - the pages change to 5 6 7 8 9, then as you click 9, pages change to 9 10 11 12 13, similarly on the downside.. and have a next previous buttons which do the same thing... perhaps in another tutorial or maybe a link to guide us...
Thanks A LOT !
Thank you Alex
This help me lot of things
Big Thank you!
Great video, I have only one question... in the video you selected "per-page = 1" and it showed 56 pagination results, so... how could I limit that to show for example, only 10 results instead of 56 ?
Instead of isset() I'd use !empty() due to the fact, that such url is possible: /?page=&per-page=
Very good point.
***** :D
Good lesson
Thank you so much
Thank you:)
this is very good lesson:)
ok this is very good thanks a lot
Nice video. Thank you =)
hell yeah guys alex garrett is a legend, go to his website if you want to learn more and get a job as a developer
It turns out that running 2 query's one with limit and one without is much faster then using SQL_CALC_FOUND_ROWS
Hi Alex, very helpful tutorial. I've just followed your procedure and everything's working great one little problem. I had a counter variable that I used to display the serial numbers for each rows. But that counter variable isn't display the correct row number anymore. Every time I'm on a new page, the counter variable resets back to 1. Any idea how I can fix that? Thanks again!!
I'm still wondering why aren't you fetching data with fetchObject method?
Wonderful video
good to see
You are awesome
I love this tutorial! Is there a way to block the users from changing the amount of results they want to see per page in the url?
Alex, thank you. I guess you know PHP almost 100%. :)
how can you make a page list of atleast 5 example: 1 2 3 4 5, then when user clicked page 5 it will result like this: 3 4 5 6 7. So that the pagination will not be too long?
For finding the positioning where your setting start instead of doing:
($page * $perPage) - $perPage
Wouldn't be quicker and easier to do: ($page-1) * $perPage
Better efficiency as system doesn't have to retrieve $perPage twice from memory.
You can absolutely do it like that. I just wanted to be very explicit in the way I explained it. Thanks for the comment, useful to many people I'm sure.
***** what?
*****
expression we was talking about would be X in the case of the sql statement "LIMIT X,Y" and where Y would be X+$perPage etc
What happened with the "PHP Social Network" series?
PS: Love your videos
where is the link where someone doesn't use OOP?
Just one question, is this PDO, OO or Procedural?
if i input per-page = 0 then it shows can't division by zero .. how i solve this problem
Alex, I've got to say, usually you give the best content with every little feature etc, but on this one Adam Khoury has a better tutorial.
***** I like Alex far better. Nothing personal against Adam Khoury, but his monotone voice and metronome-like cadence has me nodding off at the computer. To each his own as they say.
Dark Nawg Yeah, but I was talking about this specific topic and their explanation video's.
Ah yes. True. I actually like both Alex and Adam. Plus points for Adam for providing source code for you to play around with :)
can you do an advance tutorial on loading new content when you reach the bottom of the page, using Laravel please :) amazing videos btw :D
When did you switched from windows to Apple ? :O
Thank you Sir.... anyway, how to make previous and next function, sir?
Hi thank you, would be interesting to see Ajax Pagination with Laravel PHP. thanks
Great idea, thanks.
did you have a security measurements to proect against, ddos, file inclusion, spam, bots, etc. ?
!Starter
i am using mysqli and if i use it will be some problems?
thanks
Why did you use {$start} and not just $start? Wouldn't that be the same?
i accidentally wrote $start without curly brackets. and i got values in -ve. so i declared in curly brackets then i didn't get -vr values so i guess that's why curly brackets been used.
awesome
Sir, if i run a query using SELECT * FROM table WHERE id LIKE '%anything%'. results in 1st page are ok but on the next pages its just blank pages...
When I apply the CSS, it has no impact on the numbers, i've checked multiple times, it is the same and correct file.
I've also use "List-style-type = none" But still nothing
Did anyone encoutered this problem ?
Thank you
Alex can i make smth like this without MYSQL? I just want add some stuff like "pagination" to my simple static html site without database.
No offence but why PDO? not mysql or mysqli? I don't know PDO
Doesn't this leave security issue where user can exploit get requests and send dozens of them at the same time ? Sounds like good way to ddos the server since php would have to query each of those requests from mysql. Btw I know this is made just for the sake of this tutorial just asking.
So how would you improve the code to avoid being hacked... I'm learning PHP and am new to the language, help a newbie
What does everyone recommend as a testing database software? I can't seem to get WAMP to work anymore.
I'm not sure what you mean by testing database software, but WAMP, XAMPP, etc., come with MySQL. Otherwise, you might want to look into using Vagrant.
I'll check out Vagrant. WAMP doesn't work at all for me.
nice
Hi Alex I am new in php ...
Please let me know how to get your source code to practice your tutorials
My god, don't be like that kind of guy, just watch the video while coding it, you will learn from that way. You won't learn from just watching doing nothing, especially if you're a newbie. -_-
ua-cam.com/video/8WoxPWVxXHI/v-deo.html
Phpacademy you are... AWESOME! I've been looking for this my whole life! It is hard when you are from none english speaking country and you dont know how to say what you are looking for. Thank you :D
Hey which font do you use in Sublime?
The default.
For those who have a huge number of results you can use 'next' and 'previous' to display results. code below, not perfect but does the trick.
"
SEEXYYYY
Yes im not doing oop programming yet. So it wont help me
This isn't OOP :)
Object Oriented Programming Programming
i dont do that either :D
Lucas Snel Uhm, this isn't oop... :)
Lucas Snel If you meant this video, of course.
Djangokillen I was mocking the other guy cuz he said "oop programming"
i love you Alex (no homo)
Thank you Sir.... anyway, how to make previous and next function, sir?