Part 20 - Pagination in Laravel [How to Build a Blog with Laravel 5 Series]
HTML-код
- Опубликовано: 29 сен 2024
- We have finished up our CRUD for our posts controller and now its time to add a few features before we move on into our next major resource for authentication.
Today's feature is something you will find yourself doing a lot of when displaying large amounts of data. Pagination is the simple links at the bottom of the page that help us navigate large amounts of data.
Pagination in the Laravel Framework is easy. We can call the simple paginate() method and laravel does the rest.
We also learn how to order our results in descending order, to show the most recent items on top. This makes it easier to manage the posts we are working on now, which are the most recent posts.
Coming Up:
Pulling posts onto the homepage.
-- CODE SNIPPETS --
Pagination:
Post::paginate(10);
Order Results By:
Post::orderBy('id', 'desc');
-- DOWNLOAD SOURCE CODE --
github.com/jac...
-- LARAVEL DOCUMENTATION --
laravel.com/do...
-- MORE FROM THIS SERIES --
Previous Video [Part 19]: • Part 9 - Migration Bas...
Next video [Part 21]: • Part 21 - Query Builde...
Full Playlist for the "How to Build a Blog with Laravel" Series: • How to Build a Blog wi...
-- FOLLOW ME --
Subscribe for New Releases!
Twitter - / _jacurtis
(ask me questions!)
-- QUESTIONS? --
Leave a comment below and I or someone else can help you.
For quick questions you may also want to ask me on Twitter, I respond almost immediately.
You may email me hello@jacurtis.com
Thanks for all your support!
---
Tags: Pagination to paginate in Laravel 5.2 Framework Tutorial Easy to learn. We also orderBy with Eloquent ORM and mysql database. Best tut about Laravel. Build a blog with Laravel Tutorial. Beginner tutorial. How to video. PHP framework easy best tutorial. Laravel 5 coding in PHP with Alex.
![Part 21 - Query Builder [How to Build a Blog with Laravel Series]](http://i.ytimg.com/vi/xvPWtUpyHzM/mqdefault.jpg)
![Part 21 - Query Builder [How to Build a Blog with Laravel Series]](/img/tr.png)
![Part 22 - Adding Slug URLs to Our Blog [How to Build a Blog with Laravel Series]](http://i.ytimg.com/vi/XlPX3-lCkqU/mqdefault.jpg)
![Part 6 - Layouts with Blade [How to Build a Blog with Laravel 5 Series]](http://i.ytimg.com/vi/_F7pciOgSZ0/mqdefault.jpg)
If you have problems with how bootstrap pagination rendered,
following code might help you
{{ $posts->links(pagination::bootstrap-4) }}
Thank u for your lessons!!!
To populate the databases easily with Posts check out Laravel Factories! ;)
Keep Coding!
you are great man!!!!! thanks a lot
Many Thanks
Thanks Alex...Laravels pagination comes with Bootstrap 3, could you please explain how to use pagination with Bootstrap 4?
where can i find all the available methods of this particular post object? TY
Thanks
Converting Results To JSON in pagination, please show one example on this and explain what is the use of this...thanks
When I insert a new post it is saved in the database, but when i backSpace in Chrome, all my post is still available in the posts.create,
so, how do I avoid it (I mean when I backspace, it returns me the posts page) ???
sir do you have any video on search in laravel?
I get only "next" and "previous" no numbers.
Oops, i used simplePaginate() instead of paginate()
Hi, how can we customize the pagination? for example if there are a lot of pages i would like to put 3 page links at first , 3 at last and dot dot dot in between, instead of showing all page links.
Yes you can, check out the documentation it explains it all. You will basically want to do some math with the helpers to display it manually.
Hello, I am not using bootstrap. How can i customize the css for the pagination?
ok, I did it, but I do not know if its the right way to do it. I created a new class called mypresenter and changed the html there and referred to that class in laravel/framework/src/illuminate/pagination/LengthAwarePaginator.php. It works but seems like a wrong way to do it.
The function links() create a list with a class named "pagination" even if you're not use bootstrap, I think the easiest way to customize it, is just create your class in the stylesheet file. I've tested it just like it:
.pagination {
~~~~whatever
}
Call to undefined method stdClass::links()
you must stop speaking
I added this to index.blade.php Page {{ $posts->currentPage() }} of {{ $posts->lastPage() }} I hope that you don't mind Alex. Not trying to "one up you" by any means. Just experimenting while I wait for your next video.
You're the best! I'm following along to your videos on my work PC and when i get home i build it from memory which makes me retain the information a lot better. I cant wait until we get the user profile section. It would be really great if you can add a user profile picture option and a section to view/edit user account info. :) Thanks again!
+John Darville hahhahaha actually um doing exactly the same! :D
u can use $posts = Post::latest()->paginate(5);
latest() orders by date, not id though.
I am only getting the text for pagination like 1,2,3,4 links, but not the bar like Alex got. Laravel 5.5 can you help me
To help with other Front-end Framework on pagination!
@section('scripts')
$( ".pagination" ).find( "li" ).addClass('waves-effect');
@endsection
This add a custom class to link on pagination.
Thanks Jacurtis!
How to Paginate following type of html response return to Ajax from controller in laravel
foreach ($products as $key => $product) {
$output.=”.
”.$product->id.”.
”.$product->title.”.
”.$product->description.”.
”.$product->price.”.
”;
}
return Response($output);
why its showing Call to undefined method Illuminate\Database\Query\Builder::links()
can i ask u something sir, why while im using the links(), its doesnt show the style of pagination in the view like yours, im sorry if my grammar so bad, atleast u can understand me, its show without the styel, only a numbers and this symbol '< 123 >'
If anyone is interested in seeding the database to make creating multiple posts fast and easy, I added some code below that should get you up and running.
#Disclaimer: I'm running Laravel 5.4.13 so I'm not sure if this will work for older versions, I just thought it would be worth putting
it out here incase anyone was interested.
###FIRST: create a PostTableSeeder.php file in database/seeds and add the code below...
Great tips. I did that, too, but used fzaninotto/faker to create posts with lorem ipsum text, mainly because I'm lazy! Also, if you run the command "php artisan db:seed", artisan adds the new seeds to the existing data. It doesn't purge the existing data. At least in my version, which is 5.4.something. To purge and reseed in one step, you can run "php artisan migrate --seed", which rolls back, runs the migrations and then runs the master seeder.
What do you mean by escaping the url's or links at 12:12? by {!!
How to custom query create LIKE
pagination search form
can u please make a viedo about restful api for beginners?? :( or just post some link where i can learn because it is so important :/
+Ina Kacidhe yes i can. This is something ive had a lot of requests for.
i hope you can do it asap...:) :) :)
to show the pagination bar for laravel 5 you need to use $posts->render() instead of $posts->links()
excuse me..as I understand, for >5.0 versions we need to use links() instead of render()
is it means that ->render() and ->links() doing exactly same thing ??
Hamid el Abassi thanks that was helpful
instead of "SELECT `id` FROM `posts` ORDERED BY `id` DESC" its just "orderBy('id', 'desc')"! :D :D
amazing :D
I created an 'old school' pagination solution using PHP a while ago, but this built-in feature is ridiculously easy.
I cannot get pagination to work for me. I am using Laravel 5.7 and it is coming up with error "call to undefined method" with both render() and links()... Please Please help!
try {!! $posts->render() !!} or {!! $posts->links() !!} and use $posts - not $post , I made this mistake first)
sir i have a problem in search blade pagination...
how to customize the pagination style?
Alex YOU ARE THE BEST YOU ARE THE BEST
I created the following improvements: 1. I used nl2br filter to let the user insert blank lines; 2. I used bootstrap glyphicons for every button to make them look as nicer as they can be, as well as I used he "title" attribute for each of them. Question: Why you created a new route for "Read More" button, when you already have the posts.view (or posts.show)? Why not linking directly to that page?
Great tut!
I've a problem with the page=N.
No matter what, I will only get the first set of objects that I retrieve.
E.g.
→paginate(5)
?page=1 and ?page=4
gets the exact some results...
Hi, I added DELETE action button on index page using the same working DELETE code from another part of this tutorial series and i got an error saying undefined variable post. Why is that same DELETE code didn't work on index page? Is that because the "paginate(#)" from PostController?
Did anybody render the pagination with Semantic UI. I am also learning how to use Seamantic. So far I was able to complete what Alex teaches by using Semantic UI instead. However, at this point I am stuck. Laravel doesn't recognize my semantic formatting. As far as I understand, pagination feature in Laravel defaults to Bootsrap. I was't able force Laravel to use Semantic UI instead. If anybody has experience with this, I would greatly appreciate your input. This is a great course BTW, I've learned tons already. Thank you Alex.
I am shocked how easy pagination with Laravel.I was doing this just with php,bootstrap and jqyery....it's not simply at all...Lavarel is awesome! Once again,than you Alex!
Greetings from Serbia
Hi Alex, i have one problem when i use pagination with two tables i got just the first 5 records but if select more than 5 records i got error but when i use pagination with one table it's work perfectly this is my controller code:
$data = Posts::with('category')->paginate(5);
return view('temps.posts')->with('data', $data);
Indeed! Laravel is powerful!
And now he's dead maybe ?
+Jacurtis i don't know if this is important but i was thinking about creating a sort option, like a dropdown with Newest/Oldest or sort by alphabetical order is this possible is it? cuz i want to make it soon if i've master this hehe im new that's why .. btw Thanks for the tutorials More power.
This took me so loooong time, to figure out with pure/raw PHP. In Laravel not even 20 minutes...
Just want to let you know, I know there's a more updated series on your channel on how to build a blog but I really want to hear everything you have to say in every video you post!!!!! This is by far the best series I have ever followed (NETFLIX included) hahahaha
Hey Alex, first of all i would thank u a lot for making such an awesome series on laravel. You made it super easy to understand the basics of what laravel is. and em pretty excited to look whats interesting coming in the upcoming videos.
Secondly i would request you to please make a tutorial on how to use ajax with laravel. I want to learn that concept and the way you explain it , would be an bonus for many. So I hope you will look after my request and thanks again. cheers !!
Is there a video for showing just like 10 items and then displaying a "show more" button? It's kind of going into the same driection as pagination...
btw Alex, what is ->get( ) for anyway? why you didn't use it here in the postController, but you use it in the pagesController in the next video?
man you rock!!
Laravel pagination is absolutely awesome. And Alex, you are the best! Your explanations are so clear that I, who knew nothing about Laravel before starting following your tutorials, managed to insert serial numbers into the first col of the table instead of posts ids. To me it makes more sense b/c, some ids are missing after deleting a post.
Hi, can you make tutorial how to remove ?page= from pagination url ?
i have problem with this, please help
great stuff
hey curtis, Can't find the link to that video you discussed about in the beginning.
i worked with laravel 4 and i try to get some coding update for 5.2 i watched yor vids and they were very good tnx ;)
Than you man! It's very helping for me to learn Laravel basics.
Jacurtis(Alex) cool n perfect instructor for laravel learner like me .... excellent job bro
pagination is not working in laravel 5.5 while search record from ajax
no words. You are such a great man ! all the videos are very very helpful. Salute you sir !
Dude, it cannot be soo much easy like that :D Laravel
man your videos really helped me to learn new stuff
Great video! I like it
I'm just curious, what do you record your screen with?
and how do you create a paginate but using the union method.
hello it is awesome tutorial for me . thank you very much
amazing series. better than 99% of the paid sites.
Explicas muy muy bien !! xd saludos desde México
I have been following along. I had some problems with the session flash. But i have resolved. just wanna thank you. I love the way your tutorials are . soooooooo awesome. Looking forward to more from you. Expecially android apps.
Awseome, glad you got it working :)
awesome, thank you you made my day easy :-)
thanks alex again
tutorial is so easy
Thanks Alex
is links() default ?
Till this video is series there is a slight problem with titles column. If you try to add 255 characters in a title -- the column will be huge.
You can add a max-width in your css if this is a major concern. Then the title would wrap. Maybe do a max width of 25% and it would maintain it.
Alex, thanks! It was not a major concern, I just wanted to highlight this in order to make things clean for people following this series.
The beginning : 3:16
THANK YOU!!!
awesome!
thanks