Tag: eloquent

Laravel: Collections gives error because of appends when that perticular field is not selected

Laravel version: 5.7 I have one class Sessions. where I have used appends for the attribute. My query: Here I have selected fields that I need but it gives me the following error. So here appends are giving error because I have not selected start_time. How to solve this issue? Answer Here I got a solution. I make it optional

Multiline Eloquent query

eloquent laravel php

I’m trying to filter my products based on selected filters and possibly a search term/word. My filters have a relationship with categories, which in their turn have a relation ship with my products. My code below only works (without the if statement checking for a search term/word) when everything is chained together, but when I try to break the query

Laravel: prevent updated_at from filling on record creation

eloquent laravel php

In recent versions of Laravel >=5.8 I’ve noticed when you create a new model record, the column updated_at from table is filled automatically with the same value as created_at. While it makes sense …

How to use nested foreach loop in laravel for populating submenus?

e-commerce eloquent laravel php

I need to populate the menubar submenus using Laravel. Menus are populating but submenus are not working. This is my blade file. @foreach($categories as $c)

Directory issue in laravel

eloquent laravel laravel-5 laravel-7 php

As I am leaning laravel I am facing directory issues. I have made a navbar in which a create option is given to access the create file which is located in my resources/views/posts/create directory. …

Resource Controller Concept

eloquent laravel laravel-5 laravel-7 php

I am unable to find the issue. It is showing 404|Not Found update.blade.php PostController.php (a resource controller) route: please tell me what is the issue in this. one of the advice I got is to change the name of view file i.e update.blade.php to edit.blade.php. I don’t know how does it help Answer First you should change edit.blade.php instead of

Laravel select records with pivot table

database eloquent laravel php sql

I have a little problem with eloquent. I have 3 tables. Users, phrases, and phrase_user. phrase user contains columns: id, phrase_id, user_id I need to select phrases with pivot table for example. This action with SQL will be like this… This is my index function in controller I also have written these functions in models… Phrase model: User model: In

how to stop adding more data in array in foreach loop

eloquent laravel laravel-5 php

i looping 2 array a date and the data i am expecting this result What actually getting Adding old $r to results array How to fix it i am trying to break it but can’t figure it out Answer I have some untested code, as I do not have your data but I think this code below should work, you

Laravel Eloquent concat and groupBy() AND return one title of each group

eloquent laravel php

I have a table that contains, amongst other columns, a column of browser versions. And I simply want to know from the record-set, how many of each type of browser there are. my code is : output : I want to group all browsers, without the browser version like this: Answer One way you can pull this off is to

Laravel eloquent how to get relationships relationship?

eloquent laravel php

I have Users table,Jobs table and JobStatus table. I get user jobs using relationship return User::find($dto->getUserId()) ->jobs() This will return all user jobs as collection, not …