Tag: eloquent

Error while adding Eloquent class to User in Laravel

I want to make an eloquent model out of two table, pekerjaan and user. User hasMany pekerjaan and pekerjaan belongsTo User. How do I add eloquent’s method to the User class in Laravel? I have an error that shows: Cannot declare class AppModelsUser, because the name is already in use Here is my User.php …

variable references & in Laravel

eloquent laravel php

In the following code, I noticed &$list is passed by reference in the loop, however $user and $request are passed by variables. Passing $list directly to the loop won’t change $list outside the loop scope. Why is this? Answer Actually its the core PHP functionality rather than Laravel itself, basica…

Totaling the values of columns and get the average to save it on another table

eloquent laravel php

I have a table work in a database that have columns score_1, score_2, score_3, and score_4. I want to get the total value and save it to database as a total_score. And from that total_score I want to get the average matching the work data with the vendor ID. How to achieve this? At the moment I have, the tota…

Query relationship table with column that its data is an parsed array(1,2,3,4,5,6)

eloquent laravel php

I have a string column in the table that have this kind of data // 1,2,3,4,5,6 comma separated data, supposedly this id has equivalent value to the another table. I have the solution that I can get the data of the mentioned ids but its a bit mess. This is the step that I have solution Get all data first

fill already available values into CRUD edit form in Laravel

eloquent laravel php

Let’s say, I have a Laravel application with articles which can have several tags associated (i.e. an n:m relation). Creating those records is working pretty fine and I can also retrieve the selected tags array. All the necessary relations are available and working in Eloquent or in the models. Now, I w…

Is there a better way to check for mandatory child in HasMany in Laravel?

eloquent laravel php

I have a class AdBannerModel with an HasMany relationship to BannerLocalizedContentModel. When validating the model I call the method alterRulesForSaving where i want to check that the given AdBanner has at least the mandatory localizedContents. This is how I handle the check now, looking for suggestions. Ans…

Laravel : Combine two tables using Model relations

eloquent laravel php

i have two tables :: shops and attachments . Shops has all the details for shop and attachments with all the pictures for shop with ref_id as FK . now for mobile app i have to list shops with Shop title and one image. I can achieve it using leftjoin as below. This returns just shop name and pictures ,

query inside with eloquent

eloquent laravel-5 laravel-blade php

image address has location and total number of users. this query will return all the users and on relation whose query did not match will be null .I want to pull only those users which do not null value on relation and order By accordingly. Answer You can use whereHas condition

store function laravel 8 not saving data to the database

database eloquent laravel-8 php

Thanks in advance for taking the time to read throw the question. so I have a form in a blade view where a user can add a name, a description, and upload an image but the data is not being passed to the database The blade view: store function in controller : The migration which I had used: and at

How to apply Eloquent where() to child in hasMany() relationship

eloquent laravel php

I want to get the results of this very simple, common SELECT statement: For the non-SQL fluent, this returns all of the columns for all parent and child rows where the child column named column contains the value 1. Using the Laravel models below, what’s the correct Eloquent way to do this? Answer You w…