Horizontal row, odd logic

Yesterday, I learned how to implement a "space-filler" logic within a foreach loop (Thank you, @ftiersch), which checks if the number of the $collection is odd. If it is the case, it implements a "space-filler" to the current pagination, as I paginate(2). (Vertical loop) // if odd $users->count() % 2 != 0 This logic is super for a vertical foreach loop.

kendrick's avatar
kendrick's avatar splendidke...Laravel
2

How To Only Return Collections Where no other relationship

use App\User; use App\Task; use App\Join; public function tasks(Request $request) { $user = auth::user(); $query = Task::query(); $query->with('User')->with('task_type'); $q = $query->paginate($tasksPerPage); foreach($q as $task) { $status = Join::where('user_id',$user->id)-

atmaboy's avatar
atmaboy's avatar SnapeyEloquent
20

Ordering results by relationship field without fetching all records

Hello, I'm building an API using Laravel and facing a problem with ordering model results by a relationship field. Let's imagine I have a User model, and a Profile model. Profile belongs to a User. Profile table has an 'age' field. Can I order Users by the age field in Profile table and paginate result without fetching all Users from the database? As for now, the only option I

kovbo's avatar
kovbo's avatar SnapeyEloquent
4

Trait/Scope for my custom laravel paginate method

Hi everybody, I want to implement my own pagination for vue and laravel, instead of using get like laravel I want to make use POST ajax requests from my custom vue pagination component. For that I want to implement something similar to a scope I can apply to my Eloquent models, I want that scope to return the total number of records from my model in database and a specific numb

Gabotronix's avatar
Gabotronix's avatar MaverickCh...General
1

How to manually do the onEachSide() function in Laravel 5.5 (this does exist in 5.7)

I need to limit the pagination to 5 posts in total, 2 left, active, 2 right, in 5.7 this is easily doable with this function onEachSide(), but in 5.5 it does not yet exist. any help is appreciated

Desory's avatar
Desory's avatar patrickadv...General
4

Slow queries/connections with Eloquent, always over 1600ms

I have two Lumen apps in production (both AWS, EC2) and from time to time I see random queries that take exactly over 1600ms. I am using DB::listen to log the query including the time it takes to complete. I've been looking into the Eloquent code but I don't find anything. Maybe the reconnect if someone the connection was lost could cause a delay but why is it always over 1600m

cristian9509's avatar
cristian9509's avatar kobearEloquent
14

Model::paginate() and then ->append('attribute')

Hello all, I'm using Laravel's Database Pagination (https://laravel.com/docs/5.8/pagination#basic-usage), everything work fine... I came to a dead-[I can't find it in Google]-end. So, let's get a User model with pagination: $users = User::paginate(15); If needed I can add query params to the links object: $users = User::paginate(15)->appends(['queryParam' => 'paramValue'

neeonline's avatar
neeonline's avatar neeonlineLaravel
2

Showing data and Button at Laravel Datatables Yajra

I following this tutorial : https://stackoverflow.com/questions/47828331/how-to-route-in-laravel-datatables its so simple , but i cant do it . after i set my controller and my route and view , its not showing data and and table. in the table i have a button like'action' how i can take this comand to this button ? can you check my faulth query Route::get('user/show1', 'userCont

adhik13th's avatar
adhik13th's avatar adhik13thLaravel
2

how to parse array in resource collections

this is my function public function test(Request $request){ $products = Product::with(['category', 'unit', 'ratings'])->where('quantity', '>', 0)->get(); if($request->wantsJson()) { // Return a collection of $users with pagination return ProductsResource::collection($products); }else{ return respons

eusapxai's avatar
eusapxai's avatar martinbeanLaravel
4

Foreach paginate pages Laravel

Hello. I have a code: $posts = Post::paginate(100); How I can foreach pages of pagination and show results? I need in every file write a posts. foreach($posts as $page => $post) { //put on file current posts of page with file name: file-posts-$page.txt } How I can do it?

Fluber's avatar
Fluber's avatar luis_carlo...Laravel
6

How to use extend Vue in blade file with like we do in vue components ?

I want to know how to extend the vue default inside the blade file like we do in .vue file. The reason is that i don't want my main app.js file to have big file size. for example there are 5 vue component i want to use in a single blade file which i will be only using it in this single file / url, why should i load it on every other request ? How to keep it short and simple. ex

princeoo7's avatar
princeoo7's avatar princeoo7Laravel
2

where to use vue in laravel

hello, i want to know where and how to use vue in laravel, because for now i'am using only ressource/views folder for showing pages, but i don't know the use of ressource/sass and ressource/js , i have tried to search for an answer but i did not find something to really help me to understand how use them from scratch. for example i want to integrate pagination in tables, i know

kisaw88's avatar
kisaw88's avatar TalinonVue
5

I Have Problems Implementing Infinite-Scroll Functionality

Hello, with https://infinite-scroll.com/ plugin in my laravel 5.7 / Bootstrap v4.1. / blade / jquery-3.3.1 / Infinite Scroll PACKAGED v3.0.5 application I implemented infinite-scroll functionality It works, but not fully. The problem is that when I scroll more pages than I have rows pagination still continues working and I got invalid rows loaded label. Please look live https:

PetroGromovo's avatar
PetroGromovo's avatar PetroGromo...General
0

SPA Vs Multi Page Application

How can i decide between SPA Vs Multi page application ? Which would be better choice for my application ? I know it is totally depends on my type of application, but still i have a doubt regarding performance like page loading? which would be faster ? html or js ? i am already using SPA (We have created our web services (back end)), some times Components loading is very slow d

Guru5005's avatar
Guru5005's avatar YeZawHeinTips
6

Laravel Api | Social networking | Vuejs

Hi I'm new in development . i learn laravel 5.7 . need help to complete my sample project . A Social Networking site Users , Friends , Posts , Chat System , likes , Share . 1 ) how can i design db . 2 ) How to create api with custom auth and token multiple devices . 3 ) How Chat system design for 1-1 chat and group 4 ) Add settings in users for posts , public , private and fri

talhaatsix's avatar
talhaatsix's avatar Palak27Laravel
5

addRow and editRow not working with Laravel 7.4 and slow the systme

I'm using Laravel 5.4 and Yajra dataTable, everything working well if I'm retrieve the data normally. However, Once I start to use addRow and editRow, my page become very fast, I dont know why. This is my controller: return Datatables::of($allClients) ->addColumn('lead', function ($allClient) { return '<a href="leads/' . $allClient->id

LYiub's avatar
LYiub's avatar LYiubLaravel
2

what's the best vue js table?

Hello , I would like to create a table witch will use a Rest json API (developed with lumen), this table should : List items Search by every column (Ajax) pagination (Ajax) Whats the best Vue table in your opinions ? Thanks

GodziLaravel's avatar
GodziLaravel's avatar Rav23Vue
1

Vue reactivity question

Hi There. I am starting to build a pagination component in Vue. I have the following code: <template> <div class="pagination"> <div class="next" @click="updateCurrentPage(currentPage++)" > <i class="fas fa-chevron-right"></i> </div> </div> </template> <s

Equalizee's avatar
Equalizee's avatar EqualizeeVue
4

How can i re-use Query Builder result to create multiple collections?

Hi, I am trying to find a way to not write hardcoding to solve an issue. I got this index method as: public function index() { $posts = Post::where('status','published')->paginate(4); $featured = Post::where('featured',true)->get(); return view('posts.list', compact('posts','featured')); } As you can see i made 2 query on Post model

muzafferdede's avatar
muzafferdede's avatar lexionluLaravel
3

Get URL changed by pushstate

When I change url by: history.pushState(null, null, '#/' + $(this).attr('href').substring(1)); And when I want to change this pushstate with: function updateUrl() { history.pushState(null, null, `${location.href}/?page=` + this.page); } And when I click to pagination buttons. I get link like this: http://example.com/foo/bar/#revs/?page=1/?page=2/?page3 <button oncl

Fluber's avatar
Fluber's avatar BraunsonJavaScript
1

Endless scrolling

Really sucks. It's fine for short threads that are only less than one page in length, but for posts that are multiple pages, there is no way to just get to the last post without scrolling through them all. I really like being able to click on the timestamp from the main forum index view and going straight to the last post. That's a big time saver, and how the last forum worked

Cronix's avatar
Cronix's avatar jlrdwFeedback
10

Paginate hasMany Relation data

I am retrieving some data using eager loading, But now i need to add pagination on that. My query is: $certificateData = Certificate::with(['student_certificates', 'student_certificates.user', 'student_certificates.student_certificate_courses', 'student_certificates.student_certificate_courses.course']) ->where('id', $id) ->first(); Now i need to pagination student_certif

Hello_World's avatar
Hello_World's avatar staudenmei...Eloquent
1

Creating a manual Simple Paginator

Hi, I was wondering if someone can explain how to create a manual simple paginator? I've got my data, which uses a groupBy statement so I believe I need to create a manual paginator. I've just got no idea how to do this and from looking around online, there's no simple concrete examples I can find I think I'm supposed to pass the data to the Illuminate\Pagination\Paginator con

matttonks11's avatar
matttonks11's avatar jlrdwLaravel
4

How to use repository in complex queries ?

Hello, We use repositories to abstract the database logic okay ?? I have a simple interface for my repository like this one. public function create($data = array()); public function deleteWhere($conditions = array(), bool $first = true); public function updateWhere($conditions = array(), $data = array(), bool $first = true); public function findWhere($conditions

ahmedalahmed's avatar
ahmedalahmed's avatar Sergiu17Laravel
3

Vue and Paginate

Hello guys, i am trying to make a paginate in my reviews system, <script> var companyId = 1; export default { name: "Reviews", data() { return { reviews: [], login: false, review: { id: '', first_name: '', last_name: '',

gidaban79's avatar
gidaban79's avatar ekrist1Vue
1

AJAX lazy loading listing for laravel/jquery project

Hello! With new task description my client wrote AJAX lazy loading so we don’t have huge number of pagination based pages but we should show always show count of the number of results I suppose that is like scrolling on youtube ? When there is no pagination bar and scrolling down more data rows are retrieved? It was supposed to be laravel 5.7/jquery 3 project with using of ht

mstdmstd's avatar
mstdmstd's avatar mstdmstdGeneral
6

Laravel relationship methods

Hello Everybody, I had implemented user audit in one of my applications with laravel, but using DB facade since I had not much expertise in ORM relationship magic methods. Now I want to implement the same using ORM relationship methods like belongsTo() in my audit model. But I am facing issues for which I want to put some points below: I have to implement Server Side Paginatio

zahidnazirkhan's avatar
zahidnazirkhan's avatar zahidnazir...Laravel
11

Paginator another episode

I recently had a client who did not want the regular pagination links, so I set up Simple Pagination. But then they still wanted to see current page and number of pages. Simple Pagination was out due to no last page, from docs $results->lastPage() (Not available when using simplePaginate) Since I knew how to write custom pagination templates, I wrote this, actually some c

jlrdw's avatar
jlrdw's avatar jlrdwGuides
2

Laravel Chunk

I have data base table with thousands of rows, i am trying to use the chunk method in laravel to return the data to view , but it is returning array as true, can some one help me? $keys = LanguageMapper::where('lag_id_fk', 2)->where('module_id_fk', $mod_id) ->chunk(250, function ($keys) use($other) { foreach ( $keys as $i =>

Guru5005's avatar
Guru5005's avatar GururLaravel
2

Nova to display JSON data from external site API

How to use Nova to display JSON data from external site API with pagination? Please suggest me I'm very newbie with Laravel Thank you.

kokarat's avatar
kokarat's avatar kareem mak...Nova
4

Laravel Paginate on map

I want to use laravel pagination on map and i returned array collection my code is below $categories = Category::with(['children'=>function($query){ $query->select('name','parent_id'); }],'parent')->paginate(10)->map(function($item){ $category = collect($item->children)->map(function($chil_category) { return $ch

yusuf128's avatar
yusuf128's avatar realrandya...Laravel
1

Aloglia PHP Laravel Scout : How do I search in multiple indices in single API call?

How can I search in multiple indices in single API call ? currently we can search in single index vai Laravel Model level search method or create query search call in Algolia PHP client. I have found following for Laravel but it requires Laravel 5.6 and I am using Laravel 5.4 : https://github.com/algolia/scout-extended this allows to search in multiple indices using Aggregator

manishdexbytes's avatar
manishdexbytes's avatar manishdexb...PHP
0

Algolia Scout Search in multiple indices in single API call

How can I search Algolia using Laravel/Scout in multiple indices in single API call using multiple queries pushed in single client request as mentioned here ? : https://stackoverflow.com/questions/49846344/algolia-searching-multiple-indices-in-laravel and also deal with pagination ? How can I access Algolia client via Scout and create queries with pagination and push to search

manishdexbytes's avatar
manishdexbytes's avatar manishdexb...Laravel
0

Paginate a Laravel query with optional parameters?

I'm trying to make a search table with criteria for people to look up - name, surname, ID, course, etc. When they put in their specific values, laravel will paginate the results in a table and show them. Sounds straightforward, right? The trick is that every field is optional. So if a field is included, it must be searched based on that value. If a field is left blank, then th

uccdev's avatar
uccdev's avatar realrandya...Laravel
4

Laravel collection always returns an object instead of an array

I have a news page which is being loaded by Vue and Vue Isotope. Vue isotope requires that my data is an array so that I can append more articles to the isotope when the user clicks the "Load more" button. The way this works is, when the user clicks "load more", using Laravel's pagination function, I can simply append the next load of articles to my existing

Graeme1995's avatar
Graeme1995's avatar DeekshithLaravel
5

Paginate a database's complete results?

Hi, I need help with paginating my database. Basically, I want to do a complete query from my DB, and I want to chunk it off so that only certain sections of it are given at a time - the rest can be scrolled through via pagination. e.g: $dairies = DB::table('dairies') select('name', 'stock') ->get(); This would return every entry in the 'dairies' table, all 20,000+ of th

uccdev's avatar
uccdev's avatar jlrdwLaravel
11

How to handle multiple paginations with one link

In basic pagination we get some next url for loading more data, but if those data have more data with pagination as well, how can I customize and use different parameters for different data: ?page=2 to ?posts=2&comments=1 I am using api resource with main UserResource which returns posts with PostsResource which uses pagination and returns CommentsResource whicch uses pagi

HUGE_DICK_10_INCHES's avatar
HUGE_DICK_10_INCHES's avatar SnapeyLaravel
4

Sort by default on name ASC using Kyslik\ColumnSortable\Sortable

Is there a quick way to sort by ASC? View Table: <!-- Table of contacts --> <div class="container"> <div class="row" > <table class="table table-hover" id="contactsTable"> <thead> <tr> <th>@sortablelink('name', 'Co

vesunar's avatar
vesunar's avatar vesunarLaravel
2

Nova BelongsToMany breaks memory cap

In Nova 1.2.0 / Laravel 5.7.14 I have a BelongsToMany that is breaking the php memory when it is being pulled. I have a resource that I can see the count of (over 30000) from a BelongsToMany - when I click to the detail of the resource - it tells me that it hit a memory cap. According to the doc i can only find: https://nova.laravel.com/docs/1.0/resources/relationships.html#mor

beerbuddha's avatar
beerbuddha's avatar ntimyeboahNova
10

Need advice about optimization

Hi guys, I'm facing some optimizations problems through my laravel API. I work for a company which provide a suit of apps and we have in the main app some kind of feed with different kind of Threads. To make quickly, this is a kind of formation companion app. So in the feed, a user have access to thread that are posted by other users, to content set up in the course, to other t

DavidSprauel's avatar
DavidSprauel's avatar DavidSprau...Laravel
2

How to access length of total matched queries when using simplePaginate?

Hi! I want to use simple Paginate to display my query results because I like the minimalistic UI of just to buttons labeled "next" and "previous". My users do not need more than that. However, I would also like to be able to display the number of total rows matched to the search query. Normally using the pagination ->toal() method would give me that resul

biniyam20's avatar
biniyam20's avatar biniyam20Laravel
8

Infinite Scroll in Laravel 5

From a begginers point of view how can i implement infinite scroll into a laravel project. The pagination works perfectly but from there i am stuck The Controller: if ($books->isEmpty()) { $books= null; return view('landingpage')->withBooks($books); } return view('landingpage')->withBooks($books);``` The view <center><p clas

kamarujowie's avatar
kamarujowie's avatar aurawindsu...Laravel
1

Call to undefined method Illuminate\\Database\\Eloquent\\Builder::getFilter()

I created a filter with pagination inside of laravel, but when I use it in a query it shows me an error. What's wrong? "message": "Call to undefined method Illuminate\\Database\\Eloquent\\Builder::getFilter()", public function getFilter($filter = null, $field = null, $paginate = null){ if($filter && $field){ if($paginate){// se ho

romulo27's avatar
romulo27's avatar romulo27Laravel
5

PHP Laravel 5.4 Unresolvable dependency resolving [Parameter #0 [ $items ]] in class Illuminate\Pagination\LengthAwarePaginator

PHP Laravel 5.4 Unresolvable dependency resolving [Parameter #0 [ $items ]] in class Illuminate\Pagination\LengthAwarePaginator Illuminate\Contracts\Container\BindingResolutionException: Unresolvable dependency resolving [Parameter #0 [ $items ]] in class Illuminate\Pagination\LengthAwarePaginator in /var/www/html/valuable-app-new/valueable_rest_app/vendor/illuminate/container/

jitendrathakur007's avatar
jitendrathakur007's avatar munazzilPHP
5

Paginating Eloquent Relational Query Results - Eager Loading

I'm trying to have a section on my contact view that shows contact notes, 4 per page, in a box that goes through pages without refreshing the page. This may require AJAX, but I'm just trying to get the pagination to show at the moment. Here's my code. Since I'm using the "with" to eager load the "contactnotes", I don't know where to put the pagination functi

WallyJ's avatar
WallyJ's avatar usmanLaravel
3

Template not registering (or whatever is happening) the $route.query variable

Hey guys, im making a posts page and the thing in focus is pagination. I've created a pagination component that looks like this: <template> <nav aria-label="Pagination"> <ul class="pagination justify-content-end"> <li class="page-item" v-if="currentPage !== 1"> <a @click=&

mikoo's avatar
mikoo's avatar mikooVue
1

How to make 8 entries on a page

I want 8 rows to be printed on each page..i tried it with codeigniter pagination..but pagination is not working..Below i have attached my code..Please help me to achieve this public function Bill_Print() { $this->load->library('pagination'); $config['base_url'] = 'http://localhost:80/Yuva1//TipUp_Loan/Bill_Print/'; $config['total_rows'] = $this->db->get('salesitem')

laavanya's avatar
laavanya's avatar CronixTips
3

Paginate Eager Loaded Relationship

Hello, I am trying to get pagination working for Products here. Where I have the paginate(6) at the moment, the correct number of Products are returned, although I don't know if it's the correct place to put it. However, I have tried all sorts to get the links() to show in blade, and I can't figure it out. Is there a special way with Eager Loaded relations? class CategoryContro

elliotk's avatar
elliotk's avatar elliotkLaravel
2

Method links does not exist in Laravel 5.6 app?

working with laravel 5.6 and in My comtroller I have two tables like vehicles and uploads.relationship with both two tables are, Vehicle Model, public function uploads() { return $this->hasMany(Upload::class); } and Upload Model, public function vehicle() { return $this->belongsTo(Vehicle::class); } and I have following index function in

Msoft's avatar
Msoft's avatar GeorgLaravel
23

Searching two tables using Laravel and AJAX

Error while searching two tables using Laravel and AJAX Hello, I am developing a search field in my system and it needs to search data in two tables, but I can not in any way have tried all the tutorials and checked all the documentation, but I can not find the solution. Always error 500 when processing the request by Jquery. I believe the error is in the controller responsible

winiciuslima's avatar
winiciuslima's avatar shez1983Laravel
7