eloquent – Page 22 – Tarik Billa

Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance

December 8, 2022 by Tarik

When you’re using get() you get a collection. In this case you need to iterate over it to get properties: @foreach ($collection as $object) {{ $object->title }} @endforeach Or you could just get one of objects by it’s index: {{ $collection[0]->title }} Or get first object from collection: {{ $collection->first() }} When you’re using find() … Read more

How to select from subquery using Laravel Query Builder?

December 2, 2022 by Tarik

In addition to @delmadord’s answer and your comments: Currently there is no method to create subquery in FROM clause, so you need to manually use raw statement, then, if necessary, you will merge all the bindings: $sub = Abc::where(..)->groupBy(..); // Eloquent Builder instance $count = DB::table( DB::raw(“({$sub->toSql()}) as sub”) ) ->mergeBindings($sub->getQuery()) // you need to … Read more

Is there a way to “limit” the result with ELOQUENT ORM of Laravel?

November 29, 2022 by Tarik

Create a Game model which extends Eloquent and use this: Game::take(30)->skip(30)->get(); take() here will get 30 records and skip() here will offset to 30 records. In recent Laravel versions you can also use: Game::limit(30)->offset(30)->get();

Laravel where on relationship object

November 28, 2022 by Tarik

The correct syntax to do this on your relations is: Event::whereHas(‘participants’, function ($query) { return $query->where(‘IDUser’, ‘=’, 1); })->get(); This will return Events where Participants have a user ID of 1. If the Participant doesn’t have a user ID of 1, the Event will NOT be returned. Read more at https://laravel.com/docs/5.8/eloquent-relationships#eager-loading

Retrieve Laravel Model results based on multiple ID’s

November 28, 2022 by Tarik

That’s simple. Use findMany: $models = Model::findMany([1, 2, 3]); By the way, you can also pass an array to find() and it will internally call findMany: $models = Model::find([1, 2, 3]); Under the hood it just does a whereIn so you could do that too: $models = Model::whereIn(‘id’, [1, 2, 3])->get();

Laravel Eloquent Sum of relation’s column

November 28, 2022 by Tarik

Auth::user()->products->sum(‘price’); The documentation is a little light for some of the Collection methods but all the query builder aggregates are seemingly available besides avg() that can be found at http://laravel.com/docs/queries#aggregates.

Laravel Pagination links not including other GET parameters

November 22, 2022 by Tarik

I think you should use this code in Laravel version 5+. Also this will work not only with parameter page but also with any other parameter(s): $users->appends(request()->input())->links(); Personally, I try to avoid using Facades as much as I can. Using global helper functions is less code and much elegant. UPDATE: Do not use Input Facade … Read more

Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance

How to select from subquery using Laravel Query Builder?

Is there a way to “limit” the result with ELOQUENT ORM of Laravel?

Laravel where on relationship object

Retrieve Laravel Model results based on multiple ID’s

Laravel Eloquent Sum of relation’s column

How to Make Laravel Eloquent “IN” Query?

How to do this in Laravel, subquery where in

Laravel Eloquent groupBy() AND also return count of each group