Add custom pagination meta to Laravel Resources API

I have this custom pagination in AppServiceProvider.php Builder::macro('pagination', function($limit = null, $page = null){ $page = $page ?: 1; $limit = $limit ?: 50; $total = $this->count(); $items = $this->offset(($page - 1) * $limit)->limit($limit)->get(); $firstItem = count($items) > 0 ? ($page - 1) * $limit + 1 : null; return [

ahmeda's avatar
ahmeda's avatar martinbeanLaravel
4

Pagination styling does not work

Hello, I'm trying to use the tailwind pagination, I've got published the vendors assets with the command php artisan vendor:publish --tag=laravel-pagination then I've added the links in my blade view like this {{ $sessions->links('pagination::tailwind') }} But unfortunately all I got is unstyled previous and next buttons... It seems that "pagination:tailwind" has

Eloïse's avatar
Eloïse's avatar NakovLaravel
7

Progressive loading with Laravel's pagination

Can Laravel's pagination be modified to create progressive loading: https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps/Loading I was thinking to combine Laravel's pagination with JS as seen in the MDN article above. So for example trigger the page changes (page number) that the pagination creates when reaching the end of viewport But before I start trying to impl

Ligonsker's avatar
Ligonsker's avatar LigonskerCode Review
5

Laravel Default Tailwind Pagination with React

Hey guys, is it somehow possible to use the default tailwind.blade.php pagination view in React tsx components or do I have to create a pagination.tsx component to view my pagination in React components? Thanks and greetings! Felix

felixele217's avatar
felixele217's avatar SinnbeckReact
1

Pagination On DIfferent SQL Server Versions

Hello. I have a Laravel 9 application that must connect to 2 different sql servers, one is version 2012 and the other is 2008. When I use the pagination in 2012 it works fine but in the 2008 version I get the following error SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'offset'. The reason is that Eloquent uses OFFSET ... FETCH fo

achatzi's avatar
achatzi's avatar maxieayalaEloquent
12

Generating pagination links in the controller (not blade) and targeting a div using DomDocument

I'm hoping someone can help shed light on something I'm struggling with - its driving me crackers! Basically, I'm working on a page builder which stores the layout in a html file in storage. If you add a blog/testimonial feed, then - on save - it inserts an empty placeholder DIV (which has a unique ID) into the area the feed appears which will then be replaced with actual artic

idcreatv's avatar
idcreatv's avatar idcreatvCode Review
6

How to prevent Livewire pagination on wire:click?

I have a list of users that are paginated and shown on a page. Each user has a button that when click a short form is displayed. All of this works great on the first page but when I click on another page and click on the button the first pages gets rendered. How to prevent the pagination when I click one of these buttons? Livewire component: public $currentUser = null; public

jgaleano's avatar
jgaleano's avatar jgaleanoLivewire
9

Now I'm using relationships and collections my pagination and meta data has gone and I'm unable to paginate

Here is the method that should paginate my contacts... but since I have been messing about with relationships, pagination has stopped working and I'm unable to see data.meta in my JSON output in Postman?! public function index() { $contacts = Contact::paginate(15); return ContactResource::collection($contacts->load('company')); }

boyjarv's avatar
boyjarv's avatar Tray2Laravel
6

How can I get part of posts ordered by updated_at and other part by created_at with pagination

Hi! How can I get part of the posts ordered by updated_at and another part by created_at with pagination? For example: have 20 posts and I need to show on page 10 posts where 5 posts order by created_at and 5 posts order by updated_at.

dfinchenko's avatar
dfinchenko's avatar vincent150...Eloquent
19

Pre-rendering pagination view

Some people say that passing blank arrays to livewire and rendering them, is much faster than using objects due to serialization process. Sounds okay so far. The problem is, how would I get a pagination? I got used to this: Livewire //Livewire $users = Users::where('display',true)->paginate(10) Template //HTML @if($users->count()) <div class="row"> @f

Mikegk's avatar
Mikegk's avatar MikegkLivewire
4

Laravel pagination duplicating data

I'm using Laravel's pagination to display a list of follows using the below code: Follow::where('user_id', $user->id)->orderBy('created_at', 'desc')->paginate(10)->fragment('audience'); However, I keep noticing duplicate entires across multiple pages? I've taken a look at the data in the database and there are not duplicated entries in there. If I remove the orderB

brandymedia's avatar
brandymedia's avatar brandymedi...Laravel
2

Add pagination to Vue CLI app

Consider the code snippette below: How do I use the jw-pagination? import { createApp } from "vue"; import App from "./App.vue"; import router from "./router"; import store from "./store"; import JwPagination from 'jw-vue-pagination'; createApp(App).use(store).use(router).mount("#app"); I can't figure out how to include it wit

kenprogrammer's avatar
kenprogrammer's avatar kenprogram...Vue
6

XML Pagination

I am trying to create a custom sitemap like popular wordpress plugin Yoast which was created using PHP. But i am unsure how they create pagination for there sitemap like the one in this website https://www.naijavibes.com/sitemap_index.xml. Once the total sitemap passes 1000 another sitemap is created adding a number to the back. How can i do this using laravel. I know there is

monstajamss's avatar
monstajamss's avatar SinnbeckGeneral
8

Pagination error when trying to limit the query results. Method Illuminate\Database\Eloquent\Collection::links does not exist.

Pagination works perfectly when including ALL results of a query, but errors out with the following error (below) when I try to exclude a few results in a query. BadMethodCallException: Method Illuminate\Database\Eloquent\Collection::links does not exist Example #1: Here is the controller code that works class UserController extends Controller { public function index() {

Penkowsky's avatar
Penkowsky's avatar PenkowskyLaravel
3

Livewire Pagination in same links twice

I'm am using Livewire components in my project. It's working fine in most of area. but when I'm using Livewire pagination. It's showing same link twice. Please check the screen shot I have provided below. https://prnt.sc/uE4ecmvdQfz9 Here's my Pagination code. Please help <div> @if ($paginator->hasPages()) @php(isset($this->numberOfPaginatorsRen

Akash_kushwaha's avatar
Akash_kushwaha's avatar Akash_kush...Livewire
0

Laravel pagination with an anchor menu

Hello, it implements the Laravel pagination in a page, not in the home page, the issue is that when changing pages with the paginator, the menu cannot be used correctly, since the "page" http://127.0.0.1:8000/galeria?page=2 when selecting a menu item: galeria?page=2#about

eLekun's avatar
eLekun's avatar eLekunLaravel
0

Livewire Pagination is Conflicting with Laravel Pagination

Hello Everyone, In my blade file I have a Livewire pagination component. But now when I'm trying to add Laravel pagination in same blade file. I'm getting error from "/vendor/livewire/tailwind.blade.php" file. but laravel pagination file is "/vendor/pagination/bootstrap-4.blade.php".

Akash_kushwaha's avatar
Akash_kushwaha's avatar NihirLivewire
1

livewire default pagination buttons reloading page

I am using the livewire pagination, but on clicking the page buttons, page reloads use WithPagination; public $search = ''; public function clear(){ $this->search = ""; } public function render() { $searchTerm = '%'. trim($this->search) .'%'; return view('livewire.members-table', [ 'members' => Member::w

yashinfo's avatar
yashinfo's avatar yashinfoLivewire
32

How to use view component for pagination?

I am bit confuse how to use a view component for pagination? I mean my pagination component is called in view file like this <!--foreach loop to show items card--> <div id="pagination" class="p-4"> <!--below is pagination code--> <x-pagination></x-pagination> </div> And to show pagination we use below cod

sannjay's avatar
sannjay's avatar vincent150...Laravel
4

Pagination issue with Spatie Laravel tags (not returning original query)

I'm looking for help with pagination when using Spatie Laravel-Tags, please. Here's the setup… I've coded up a really simple form which has multiple options for types of tags, so there's a select menu with options for types of post(for example, 'company news' and 'industry news') and then there's another for 'Author' etc (I'm trying to make it flexible so I can add more filter

Devedge's avatar
Devedge's avatar SinnbeckCode Review
3

Filter pagination results

My previous posts asked about the query itself but led to problematic results so I thought maybe it's possible to filter results after query and before pagination, or after pagination? This is the problem: I need a complex query, so I have to use raw SQL which returns an array, thus I can't use paginate on it. What I need is to display is the oldest message of a user, example d

Ligonsker's avatar
Ligonsker's avatar LigonskerCode Review
6

AlpineJS with Livewire Pagination x-show stays open

Here is a simplified version of what I have @foreach($shows as $show) <div x-data="{ open: false }"> <li x-on:click="open = !open">CONTENT</li> <div x-show="open">CONTENT</div> </div> @endif This works fine and clicking on the <li> opens and closes the inner content <div>. My issue is that I'm

rubendn's avatar
rubendn's avatar rubendnJavaScript
1

Pagination and canonical

I have a page that Google has reported as "Duplicate without user-selected canonical" as it is domain.com/pagename/ that gets redirected to domain.com/pagename I have added a canonical tag with the following in my layout <link rel="canonical" href="@yield('canonical')" /> and this in my page @section('canonical'){{ URL::current() }}@endsecti

AndyMillne's avatar
AndyMillne's avatar AndyMillneLaravel
0

How to get pagination with groupBy in eloquent?

Dear, I have a query like this - return $query->get()->groupBy('date'); It works fine but I want to add pagination on it, while I use- return $query->get()->groupBy('date')->paginate(10) , it does not working. can anyone suggest how to make it okey?

md_imran's avatar
md_imran's avatar SinnbeckLaravel
6

Pagination in Laravel 9 using Bootstrap

I'm new to using pagination in Laravel. I'd like to use Bootstrap to handle it for me. The first page displays properly, but it fails on the next page. Here is the code from the controller: function show(Request $request) { $validInput = $request->validate([ 'itemName' => 'string|min:5|nullable', 'status' => 'string|min:5|nullable',

grozavule's avatar
grozavule's avatar grozavuleLaravel
13

Editing default laravel's bootstrap pagination results in an htmlspecialchars() error

Hello! I'm trying to edit the out of box laravel's bootstrap pagination design. Here is the default <ul class="pagination"> {{-- Previous Page Link --}} @if ($paginator->onFirstPage()) <li class="page-item disabled" aria-disabled="true" aria-label="@lang('pagination.previous')"&g

lat4732's avatar
lat4732's avatar SinnbeckLaravel
4

Query Builder -> middleware -> pagination

Hi, I don't understand how to work with data getting from query Builder to modify it. Here is something like: I get data and send to blade with pagination $invoices = $this ->startConditions() ->select($columns) ->orderBy('invoices.id', 'desc'); return view('livewire.invoice.list', [ 'invoices' => $this->invo

eddstep's avatar
eddstep's avatar eddstepLaravel
11

get link from last answer including pagination with fragment

I want to show the last reply of a thread, with pagination included Example: Thread win 76 replies, configure 10 per page in replies I need to generate the link from the last reply Suggest www.localhost.com/threads/{thread-title}?page=8#reply-76

Makoto0528's avatar
Makoto0528's avatar ItsClassif...Laravel
1

Adding checkbox filters on top of text search box to pagination

Currently I have the following search form to filter pagination result on the blade file: <form method="get" > <input name="search" id="search" type="text"> <button type="submit">Search</button> </form> And the query in the controller: $search = $request->input('search'); $use

Ligonsker's avatar
Ligonsker's avatar sr57Code Review
3

Can I filter pagination results in the frontend?

I've been using datatables so far so the results were returned to the frontend and then any filtering was done on the data that was fetched and it was quick. But now I'm looking at a piece of code that looks very not optimized: they used Laravel pagination and every filtering or searching re-calls the backend and it's very slow. (There are many records) Should I just refactor t

Ligonsker's avatar
Ligonsker's avatar LigonskerCode Review
18

links() pagination in Livewire doesn't work

the data and everything work okay but when use links function to pagination doesn't work in main view : @extends('layout',['html_tag_data'=>$html_tag_data, 'title'=>$title, 'description'=>$description]) @section('css') @livewireStyles @endsection @section('content') <div class="container"> <!-- List Items Start --> <d

enadabuzaid's avatar
enadabuzaid's avatar SnapeyLivewire
15

Pagination isn't working

Hello! I have a simple forum. On each topics the first post is the "topic" or the question, and under it the "replies" are listed. I'd like to paginate the replies, but it doesn't seem to work for me since all the replies are displayed on the page and they are not getting paginated. The paginator is displayed though. This is my controller, the query that sho

dtommy79's avatar
dtommy79's avatar SinnbeckLaravel
5

Pagination question with query()

Hi, I have a simple method that handles pagination with search. I was wondering why using Guild::query() does not with pagination. Using this method below gives me the error of Call to undefined method links(). However, not using query() and handling it separately works fine. What's the reason behind this? Is there a better way to write this method below? Thanks for any advice.

n212's avatar
n212's avatar n212Laravel
4

pagination numbers and search button do not stop refreshing simultaneously in laravel 8

I am using the below codes for the pagination without page reload using Ajax, it works fine, but I need the same thing for the search button when I click on it, it refresh the page. I used event.preventDefault() function on the button and it stops refreshing but the result of the search doesn't appears immediately and I need to click on the page number again. <div align=&quo

Aishan's avatar
Aishan's avatar jlrdwJavaScript
3

InertiaJS Pagination in bootstrap

All the examples of InertiaJS pagination are using Tailwind CSS. For those not familiar with Tailwind CSS ,this is an example pagination component using bootstrap. Am using Svelte thus if using Vue or React just replace the Svelte syntax with Vue or React Syntax. Pagination.svelte <script> import { inertia } from '@inertiajs/inertia-svelte' export let links = [

kenprogrammer's avatar
kenprogrammer's avatar kenprogram...Tips
0

How to testing pagination in laravel livewire

hello everyone, I want to ask. How to test pagination in laravel livewire. this is my code : public function testViewAllMyProjecWithPaginationLivewire() { $component = Livewire::test(ShowMyProject::class); $component->assertStatus(200) ->assertSee("paginator-page"); } So I checked with method assertSee(), especially

adnanerlansyah403's avatar
adnanerlansyah403's avatar vincent150...Livewire
1

How to check pagination in testing laravel livewire

hello everyone, could u all help me. How to check the pagination in testing laravel livewire. this my code : public function testViewAllMyProjecWithPaginationLivewire() { $component = Livewire::test(ShowMyProject::class); $component->assertStatus(200) ->assertSee("paginator-page"); } So I checked with method assertS

adnanerlansyah403's avatar
adnanerlansyah403's avatar martinbeanLivewire
1

pagination not show (links , meta)

I have this eloquent to return data as API public function index() { $questions = $this->questions() ->when(request('search'), function ($query) { return $query->where('title', 'LIKE','%'.\request('search').'%'); }) ->latest()->paginate(2); $categories = Category::select('id', 'name')->get

ethar's avatar
ethar's avatar vincent150...Laravel
1

How to use pagination with files list?

I am trying to paginate an array of files that I have on my local drive and searching the internet I found a way to generate the pagination manually. public function render(BackupService $backupService, Request $request): View { $files = $backupService->getAllBackups(); $backups = $this->getPaginator($request, $files); return view('livewire.index-backup', comp

ZoroCuba's avatar
ZoroCuba's avatar Tray2Livewire
1

Dynamic Pagination

Hey there! I wonder, how would you go about making the pagintion data dynamic, based on some parameters? So I have a layout that has a filtering menu and pagination, the only thing that's different is the content in between. So my question is, how do you make this dynamic: {{ $houses->links() }} {{ $flats->links() }} The variable would need to be dynamic. In my filteri

aurelianspodarec's avatar
aurelianspodarec's avatar aureliansp...Laravel
6

Pagination and AWS application load balancer

Hi guys, so I have an application routed through cloudflare, an application load balancer to an EC2. The pagination renders to URLs using its IP address, while other links are perfectly fine. Any ideas how to fix that? I tried to expose config/trustedproxies.php and I have put this in my applicationprovider: if (config('app.env') != 'local') { $this->app[

ChristophAust's avatar
ChristophAust's avatar ChristophA...Laravel
1

Laravel Pagination

Just wondering if there is a way to use the full pagination, not the SimplePagination(), but remove the first and last items in the links object where its Previous and Next Is there i built in method? Ir simple remove it manually before sending it back to the front? &laquo; Previous and Next &raquo; Thanks

movepixels's avatar
movepixels's avatar movepixelsLaravel
7

Pagination in Laravel that is connected to Woocommerce site

As the title says I'm trying to create pagination in Laravel that gets its data about the products from a Woocommerce site. Laravel is connected to that site via codexshare/laravel-woocommerce package. When i try to use paginate it returns all of the data about the pages just without the links and the method links() doesn't work it just says that the method doesn't exist (BadMe

MrDalmosh's avatar
MrDalmosh's avatar aureliansp...Laravel
5

Can you use laravel's pagination, but change the results into an accordion?

The goal was to try and solve a problem of a query being too big by separating it into parts, and pagination does a lot of that on it's own already. Now if there is some table, instead of the ->links(), is there a way to put each 'page' of results into section of the accordion and then have the user clicking to open another section be kind of like opening a different page so

UniqueHope's avatar
UniqueHope's avatar jlrdwLaravel
4

Links pagination redirecting me to index instead of keeping url

Hello, there's something strange happening with my pagination that never seen before. If i'm on index, page pagination works as it should (it adds ?page=2 to the url and works correctly). But if i'm in the admin dashboard (url has admin/discounts) instead of adding ?page=2 to that url (so it should be admin/discounts?page=2) it redirects me to /index.php?page=2. It's strange be

ignaaaam's avatar
ignaaaam's avatar MohamedTam...Laravel
8

Pagination and orderBy doesn't work correctly together

I'm using pagination and order data by timestamp (column's name is sort and it can be null). It works fine in local environment but when I'm using that in production, There is some duplicated record in different page. Also, after records that sort's column is filled, loaded. Then it should be ordered by id, but it doesn't work. Is there any solution to solve this? News::query()

seyyed_am7's avatar
seyyed_am7's avatar SilenceBri...Laravel
1

Page pagination links reload the entire page and goes on top

I have created my laravel project in which where I used pagination inside the blade everytime I click on the next page it reload the page that make a really annoying exprience for users. Is there anyone who could help me to solve this issue please? PS: I am new to laravel and I have very poor javascript exprience.

Aishan's avatar
Aishan's avatar johnDoe220Laravel
3

Relationship Pagination Error

Hi Guys, Having issue trying to paginate a "Product / Comments" relationship. Using the query below, its works in terms of paginating, only 4 results are displayed as expected. However when I use {{ $product->comments->links() }} with the blade file I get the following error: Method Illuminate\Database\Eloquent\Collection::links does not exist. Any ideas why th

AtomCoder's avatar
AtomCoder's avatar AtomCoderLaravel
4

How to generate Sitemap XML with Pagination in Laravel?

Hi, hope everyone is doing well. I'm looking for a way or a laravel package that allows Pagination in XML Sitemaps. How is data (URL) for posts stored? In the Database, we have the column for post slug, title, etc. Right now, I am using Laravel View to output an XML Page with all the URLs but the problem is that the website has over 15,000 posts which makes the page too laggy

alexui's avatar
alexui's avatar alexuiCode Review
2

Pagination laravel 9

There is any library need to be install when use pagination in laravel ??? i have used paginate and data get by paginate is ok but for design what should do ??

ANILAMUHAMMADASHRAF's avatar
ANILAMUHAMMADASHRAF's avatar foliumLaravel
2