"Nested pagination": Paginate (sub-)item in ApiResource

Hello everybody, I got an ApiResource like this: <?php namespace App\Http\Resources; use Illuminate\Http\Resources\Json\JsonResource; use Illuminate\Support\Facades\Gate; class UserResource extends JsonResource { /** * Transform the resource into an array. * * @param \Illuminate\Http\Request $request * * @return array */ public func

ahoi's avatar
ahoi's avatar jlrdwLaravel
3

Use pagination with lazy eager loading (load() method)

Hello Guys. I want to use paginate with lazy eager loading (load() method). Here my code: TelemarketerController.php public function index(Center $center) { $center->load(['telemarketers' => function ($query) { return $query->paginate(); }]); return view('centers.telemarketers.index', compact('center')); } telemarketers/index.php @if ($

iam_ryu's avatar
iam_ryu's avatar SnapeyLaravel
4

Filter and Pagination

Hi guys, i make a filter and it works but when i try to access to the second page of the filter response with 404 error This is my filter function at the controller public function filtrar(Request $request) { $reportes = Reporte::whereYear('created_at', '=', $request->input("año")) ->whereMonth('created_at', '=', $request->i

biktorrb's avatar
biktorrb's avatar jlrdwLaravel
4

how to add pagination to this code

$files = File::where('campaign_id', $id); if ($month = request('month')) { $files->whereMonth('created_at', Carbon::parse($month)->month); } if ($year = request('year')) { $files->whereYear('created_at', $year); } $files = $files->get()->sortByDesc('created_at'); I tried adding it on the firs

michalis's avatar
michalis's avatar RobstarEloquent
7

Dealing with huge tables and pagination

I have a table with more then 16000 records (see the update), I need to show it on a list and paginate, but even with simplePagination it takes 15s to query it, is there a better way to paginate it? Important thing is that I cant select the first 100 and page 2 the next 100 cause I have filters I'm using a google compute engine and sql with 1vCPU and 3,7GB ram Update I forgot t

spacedog4's avatar
spacedog4's avatar spacedog4Laravel
24

Have You any example of pagging using query builder without eloquent pagination() method as eloquent is slow for select query operation??

User::paginate(5);

kaushal's avatar
kaushal's avatar SnapeyLaravel
2

Manual pagination episode 3 (It is a guide not question)

A question came up how to paginate using the DB Facade. And since at times it's used instead of query builder or eloquent, here goes: You have to have a count of results. And just a simple example: public function indexdb() { $page = !empty(Request::input('page')) ? Request::input('page') : '1'; $search = !empty(Request::input('search')) ? Request::in

jlrdw's avatar
jlrdw's avatar rajivGuides
1

trouble with pagination with collection

this is my route: Route::get('/home', 'ForumsController@index')->name('home'); this is my index function: public function index() { switch (request('filter')) { case 'me': $user=Auth::user(); $discussions=$user->discussions('created_at','desc')->paginate(3); break; case 'unsol

fazlulkabir's avatar
fazlulkabir's avatar fazlulkabi...Laravel
5

DB::Select query with pagination ?

$users = DB::select('SELECT s.id,s.name,s.email,p.profile_for,p.date_of_birth,p.fname,p.lname, p.religion,p.marital_status,p.professional,p.salary,p.father_occupation, p.mother_occupation,p.sister,p.brother,p.address,p.address2,p.city,p.state,p.country, p.phone_number,p.education,p.caste,p.body,p.waist,p.height,p.weight, p.image,p.image_path,p.ag

UsmanFarzand's avatar
UsmanFarzand's avatar siangboonLaravel
3

Pagination on tag list

I'm having trouble paginating my tag page which lists all the products that are associated to a tag (many to many). The tag page is found on slug. I have the lists of products associated with the tag ordered on the the highest average rating from the reviews related to the products. Unfortunately i cannot seem to get the paginate working. What is the best way to do so? Tables:

dionarap's avatar
dionarap's avatar ftierschLaravel
1

Setting a Global Pagination Limit Variable in laravel

This is kinda stupid question, but anyway clearing out the doubt is better then keeping it to self. so currently i have set a varaible in config/app.php 'limit' => 20 then in any controller i need it, i do Config('app.limit') now in any controller i am doing it as protected $limit; public function __construct(Request $request) { ($request->has('lim

princeoo7's avatar
princeoo7's avatar princeoo7Laravel
8

Laravel 4 pagination links return empty pages

I am trying to paginate thousands of results from database using Laravel 4.2 Unfortunately the page shows page numbers, which after clicking just refresh page leaving only get parameter in my link "?page=2". Is there anything that I am missing? Controller $data = SavedValues::where('h_user', '=', $user->id)->orderBy('id', 'desc')->paginate(100); return View:

Terrorizer's avatar
Terrorizer's avatar munazzilLaravel
11

pagination without eloquent

i need to paginate response that return from another web service to show in my service. public function index() { $client = new Client(); $crashes = $client->request('GET', 'http://localhost:8000/crashes')->getBody()->getContents(); return view('crashes', ['crashes' => json_decode($crashes)]); } in this code i get a json response fro

esmaill23's avatar
esmaill23's avatar FatakhilLaravel
3

How to make pagination with different size for first page? ->paginate(X)

Hello, dear Laracast community. Never encountered such problem, but in need to implement this for sake of project. I have a model Article, as an example. And on the first page I'd like to present grid 3x4 of cards, but with "load more" card as last. So 11 Article cards and load more card. But for next page I need all 12 article cards. For now, I make ->paginate(12)

vladshoob's avatar
vladshoob's avatar yaroslawwwLaravel
3

How to do Laravel Eloquent get with a specific item appearing first for pagination

I have a use case where I need to get all the rows from a table with the currently selected row appearing first and show the rest as the user scrolls through the table. I currently have it setup where I use the eloquent find to fetch the individual item and then use the eloquent get and merge the results if the page number is 1. Is there a better way to handle this or is this t

anurock's avatar
anurock's avatar rodrigo.pe...Eloquent
1

Pagination for search results laravel 5.7

//It my query $product = Product::where('naam', 'LIKE', '%' . $q . '%') ->orWhere('beschrijving', 'LIKE', '%' . $q . '%') ->where('contact', 'LIKE', '%' . $contact . '%') ->paginate(6); // And I want to paginate like this parameter

majad.shohagh's avatar
majad.shohagh's avatar jlrdwLaravel
2

Laravel Pagination - changing the page makes my query vanish?

So I'm writing a page using Laravel that calls data from my database. First, lemme describe & show you my code, with the problem stated below it. The database returns all its data in the form of a paginated table. The user is given five fields and a submit box. Every field is optional, so they can be as specific as they like in their query. If no values at all are called, t

uccdev's avatar
uccdev's avatar uccdevLaravel
2

Change pagination URL query string

Hello, Is there a way to parameter name 'query' to another name? $resuls->nextPageUrl() generates search?query=test&page=2 How can we change this to tosearch?s=test&page=2

popcone's avatar
popcone's avatar habeebnetCode Review
4

Laravel Pagination causes MethodNotAllowedHttpException ?

So I am working on a site that paginates two different types of DB queries. The first is a generic "get everything" query. The second has specific checks (e.g "WHERE name = 'John'") Both are done with simplePaginate(num); I'll show my code if it's considered relevant. The first works perfectly fine. BUT the second throws an error whenever I use the Next or P

uccdev's avatar
uccdev's avatar uccdevLaravel
29

Pagination is over http instead of https

When paginating using {{ $posts->links() }}, Laravel is displaying the links as http:// instead of https://, even though I've specified https in the APP_URL inside .env, have set up URL::forceScheme('https'); in AppServiceProvider.php and am using SSL certs, not only from CloudFlare (using FULL), but have also installed a cert on the load balancer and am using LetsEncrypt on

timgavin's avatar
timgavin's avatar iotstudentGeneral
4

pagination on sortBy()

hey guys $member = auth()->guard('members')->user(); $doctors = Member::where('type', 0)->where('approve', 1)->where('city_id', '!=', null)->where('id', '!=', auth()->guard('members')->id())->orderByRaw("FIELD(city_id , $member->city_id) DESC")->paginate(10); foreach ($doctors as $doctor){ $doctor['rate'] = $

iki's avatar
iki's avatar ikiLaravel
1

Manual Pagination

$users_online = User::allOnline(); $users_online = $this->simple_paginate($users_online,1); private function simple_paginate($items, $perPage) { $pageStart = request('page',1); $offSet = ($pageStart * $perPage) - $perPage; $itemsForCurrentPage = $items->slice($offSet, $perPage); return new Paginator( $itemsForCurrentPage, $perPage, Paginator::resolveCurrentPage(), ['pa

GreenTeam1988's avatar
GreenTeam1988's avatar lostdreame...General
1

Cache and Pagination

$page = $request->has('page') ? $request->query('page') : 1; $user = Cache::rememberForever('user_'.$page, function () use ($course_id) { return User::where('course_id',$course_id)->pagination('5'); }); I wanna know if a user create or edit,how do I forget cache?

amk's avatar
amk's avatar munazzilLaravel
6

Add Pagination to This Collection

How can I make it to be paginated ?. Here is my code. $threads = Thread::has('replies')->latest()->get()->sortByDesc(function ($thread) { return $thread->replies_count; }); I try to make like this. $something = $threads->paginate(12); dd($something); But the error came like this. Method Illuminate\Database\Eloquent\Collection::paginate doe

irsyadadl's avatar
irsyadadl's avatar jlrdwEloquent
7

Include min max in pagination count query

Hey guys first time I ask something here. I have the following problem - I see, when I use the paginate() method on my eloquent models, Laravel makes 2 queries - a count query and select one. My goal is to get the min and max values in table for a specific column. Is there a way to add select min(),max() in the count query or I have to make a separate one. Thanks

blader4o's avatar
blader4o's avatar SnapeyLaravel
7

Running filter on Eloquent Collection removes pagination links() method?

I have the following code. $results = $user->paginate(3); if(\Auth::check()){ $results = $results->filter(function($item) { return $item->id != \Auth::user()->id; }); } On my blade page I get an error about $results->links() method not existing. If i just run this code I do not get that error. $results = $user-&g

Loach's avatar
Loach's avatar staudenmei...Eloquent
1

Laravel 5.6 - Custom pagination link

this is my controller $products = [ ... ];//this list of all my products in array $x= collect($products); $pageNum2 = \Illuminate\Pagination\Paginator::resolveCurrentPage('feedWooDetail2'); $dbProduk = new \Illuminate\Pagination\LengthAwarePaginator( $x->forPage($pageNum2,12), $x->count(), 12, $pageNum2,

Cheers02's avatar
Cheers02's avatar jlrdwLaravel
2

Filter a model and stay with the pagination

I have a list, let call it Tasks, I can get all the tasks and paginate Tasks::paginate(10); But I also have a filter so I can do something like this Tasks::where('name', 'LIKE', '%'.request('filter').'%')->paginate(10); But if I'm in second page, and filter starting from the second page, it will filter and try to return the tasks from the second page, being that after the

spacedog4's avatar
spacedog4's avatar jlrdwLaravel
1

Vue.js component not compiling when being loaded in via AJAX pagination

I have a comments section which works similar to Facebook in that it will load the first 5 and then if there are more than 5 it will display a "Load more comments" link. Upon clicking the link it will load the next 5 comments via a $.get() call. The first 5 load and compile just fine since they're not being loaded via AJAX. The problem I'm having is that the Vue code

Samer_J's avatar
Samer_J's avatar Samer_JVue
2

Pagination of data from a relation

$galeriaInfo = Galeria::where('slug', 'LIKE', $slug) ->with(['multimedia']) ->withCount('multimedia') ->paginate(15); Printing this $galeriaInfo I see the correct information on the screen ... info of the specific gallery and 15 images retrived from the other model. But how can I access the info on the blade

Penaf's avatar
Penaf's avatar staudenmei...Eloquent
5

Query with pagination does not work

I wanna search default, popular and recent on my articles table but I dont get this to work. Until now I tried it with recent and created_at but not even that works. If recent is in my url it only works for the first page. Someone knows what I have to do? Link <li class="nav-item"><a class="nav-link" href="/?recent">{{ __('Recent') }}&l

lara28580's avatar
lara28580's avatar clickLaravel
8

Vue search on pagination

Hello! I'm using https://github.com/gilbitron/laravel-vue-pagination but I can't write search. Could someone help me if it is possibile?

skreng's avatar
skreng's avatar pardeepkum...Vue
2

Pagination on Eager Load

The following works, but returns a Collection, not a Paginator. Any ideas on how to get the Paginator? $users = User::with([ 'books' => function($query) use ($orderby, $search){ $query ->where('books.title', 'LIKE', '%'. $search .'%') ->orWhere('books.isbn', 'LIKE', '%'. $search .'%') ->orderby($orderby, 'asc')

jabshire's avatar
jabshire's avatar crnkovicEloquent
11

Problem in pagination after ajax return in laravel

Guys I am working with a project milkfarm I am having a form with search box and text box. In the textbox event on change i wrote a jquery to search the value Everything is file it searches and appends with the But after search is done if I move to page 2 then it is refreshed the search option disappears and all the data are displayed Say for example I will seach time=”am” the

AbdulBazith's avatar
AbdulBazith's avatar AbdulBazit...Laravel
9

Pagination only in blades - Laravel 5.6

Hello, I have code like this below: @foreach($user->activities as $activity) <tr> <td>{{$activity->id}}</td> <td>{{$activity->duration}}</td> <td>{{$activity->date}}</td> <td>{{$transaction->created_at->diffForHumans()}}</td> <td>{{$transaction->updated_at->diffForHumans()}}</td> </tr&g

palak's avatar
palak's avatar bobbybouwm...Laravel
1

Why Pagination laravel ignores requests

Hi, My controller: public function index(Request $request) { $contractstatus=ContractsStatus::all(); if (($request->fromdatum == null)||($request->todatum == null)) { $value_stav_zakazky =1; $contracts = Contract::where('stav_zakazky', '1') ->orderBy('id', 'DESC') ->paginate(10); $from=('2018-06-01')

aurelo's avatar
aurelo's avatar aureloLaravel
1

Custom Pagination Name Using Repository Pattern

I have something like these: $order_blue = $this->orderRepository->findWhere(['color' => 'blue'])->paginate(5); $order_red = $this->orderRepository->findWhere(['color' => 'red'])->paginate(5); then i need to display them on the same window / blade on a separate html tables. my problem is, if I'll click the page 3, the other table also respond. my second

kapitan's avatar
kapitan's avatar kapitanLaravel
4

Pagination result change when user changes pagination page

Hello, I created this function witch is searching in a category based on a value a user have provided. public function specific(Request $request, $catname) { // Get the category name $category = Category::where('name',$catname)->first(); // Get all parent categories $categories = Category::where('p_id',0)->with('childs')->get(); // User search qu

Sidart's avatar
Sidart's avatar jlrdwEloquent
2

Cache Records Before pagination

I've a thread model which 'hasMany' replies. Now, in order to render a thread with all the replies, I'm fetching thread and replies separately. I'm trying to use the following logic to cache replies to any thread - $replies = Cache::store('redis')->tags(['thread_' . $thread->id . '_replies'])->rememberForever('thread_' . $thread->id . '_replies_' . $page, function

thebigk's avatar
thebigk's avatar thebigkEloquent
2

Problem in Use Union With Pagination in Eloquent

Hi, I Want To Union two Model And Paginate Result But Get Error, In Bellow See My Call Code And Result: $this->archive = $this->archive ->select (['id','property_id','plan_id','pay_id','price','period','start_at','expire_at']) ->whereHas('property',function ($query) use ($user){ $query->select(['user_id','type_id','title'])

mmasomi73's avatar
mmasomi73's avatar mmasomi73Eloquent
2

filter and pagination

when I select category or city it does not work !! public function index(Request $request) { $neighborhoods = Neighborhood::get(); $cities = City::get(); $categories = Category::select('id', 'single_name')->get(); $subCategories = SubCategory::select('id', 'key')->get(); $newProperties = new Prope

Smsma's avatar
Smsma's avatar fouladgar_...Laravel
3

pagination page 2 return page 1 on production server

I have this simple code, when I paginate to page 2, 3, 4... etc. it always shows the correct address in the address bar, but it shows ONLY the values of the first page. $users = User::where('id', '>', 2)->paginate(10); return view('users.index', compact('users')); NOTE: this code works fine on my development machine, this problem only occurs on production serv

AbdallahSabri's avatar
AbdallahSabri's avatar BorisuEloquent
1

Join pagination not working. getting error ```Method Illuminate\Database\Eloquent\Collection::paginate does not exist```

public static function getNumbersListing(){ return VicidialCallMenu::join('vicidial_call_menu_options','vicidial_call_menu.menu_id','vicidial_call_menu_options.menu_id') ->groupBy('vicidial_call_menu_options.menu_id') ->get(['vicidial_call_menu.menu_id','menu_name','user_group','menu_prompt','menu_timeout',DB::raw('count(vicidial_call_menu_options.menu_id) as options')])

rauttausif's avatar
rauttausif's avatar jlrdwLaravel
1

Send pivot table data to the view with pagination

Hi, I have three tables called allquestions, questions and exams betwen those there is a table exam_question. The pivot table has the question_id, exam_id, answer. This is the code of my controller: public function index() { $user = User::find(Auth::User()->id); $allquestion = Allquestions::where('id', $user->assigned_exam)->first(); $quest

ztioge's avatar
ztioge's avatar ztiogeEloquent
0

Error in Eloquent Pagination outside Laravel

I am using Illuminate/database package outside Laravel with my CodeIgniter setup. The initialization is done using Capsule class like this use Illuminate\Database\Capsule\Manager as CapsuleManager; use Illuminate\Events\Dispatcher; use Illuminate\Container\Container; class Capsule extends CapsuleManager { public function __construct() { parent::__construct(); require_

ehsanquddusi's avatar
ehsanquddusi's avatar eugenevdmEloquent
8

Pagination for xml data in laravel

I am displaying the information from simplexml api from 3rd party server. How do you do pagination/intinity scroll for xml data?

ncltours's avatar
ncltours's avatar jlrdwLaravel
1

pagination help

two tables: users attendances user model = hasMany('App/Attendance'); attendance model = belongsTo('App/User'); the problem is it displays error when using this in controller: $user_id = auth()->user()->id; $user = User::find($user_id)->attendance()->paginate(10); return view('/dashboard')->with('attendances', $user->attendances); dashboard view

blitzkin's avatar
blitzkin's avatar rin4ikCode Review
16

manual pagination without a model

Is it possible? I found this on manual, but isnt clear to me how to solve this: https://laravel.com/docs/5.6/pagination#manually-creating-a-paginator I've an array of things that is not related to a model, and i need to paginate the result... thanks

jahstation's avatar
jahstation's avatar jahstationLaravel
4

Order pagination result by pivot field

I have 2 table with many to many relationships : Films Tags Many films can have many tags (belongsToMany relationship) So from a controller, I want to get the films having a tag and paginate the results. How can I order my results with the field 'ordre' the pivot table film_tag ? So far I have : $films = Film::whereHas('tags', function($query) use ($tags){ $query->whe

morganThePirate's avatar
morganThePirate's avatar athulprajEloquent
3

Laravel Fractal Pagination

Hi all, I am using Laravel Fractal with one of my API's. I have a Thread that has many Replies and i want to paginate the Replies. The Replies are an include on the Thread Transformer. How would I go about paginating a transformers include? Is it possible? Thanks!

lara30453's avatar
lara30453's avatar lara30453Laravel
0