Laravel eloquent with relation data (Eager Loading)

Question

I have two database tables items and measurement_units - item has measurement unit.

Now the problem is I want to select a particular column from items and some column from measurement_unit. I want to use Eager loading

e.g.

$items_with_mu = Item::with("measurement_unit")->select(["item_name", "item_stock"])->first();

When accessing measurement_unit. It returns null. Without the select function it returns data(measurement_unit).

$items_with_mu->measurement_unit;

can anyone help me and sorry for my English.

But I need to select column. I got my answer. BDW thanks for reply. — ThataL
– ThataL, Commented Mar 19, 2019 at 12:10

bhavinjr · Accepted Answer · 2019-03-19 12:12:17Z

1

Try this

Item::with(['measurement_unit' => function($q) { 
           $q->select('id','unit_column');   //specified measurement_unit column
      }])
     ->select('id','measurement_unit_id','item_name')
     ->get();

If your laravel version is >=5.5 then you can write in a single line

Item::with('measurement_unit:id,unit_column')
     ->select('id','measurement_unit_id','item_name')
     ->get()

edited Mar 19, 2019 at 12:12

answered Mar 19, 2019 at 12:05

bhavinjr

1,76315 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

bhavinjr Over a year ago

should be work select foreign key measurement_unit_id. check latest code

bhavinjr Over a year ago

Glade to help you. you should check updated answer if your laravel version is >=5.5

ThataL Over a year ago

now I got the point where I am missing. without foreign key how a table can be join.

narayansharma91 · Accepted Answer · 2019-03-19 11:56:01Z

0

You have to select the primary column of the main model like below.

 items_with_mu = Item::with("measurement_unit")->select(["item_name", "item_stock", "primary_key"])->first();

answered Mar 19, 2019 at 11:56

narayansharma91

2,3531 gold badge14 silver badges20 bronze badges

6 Comments

narayansharma91 Over a year ago

Can you please paste your relationship method?

narayansharma91 Over a year ago

Also database structure as well.

ThataL Over a year ago

primary_key should be foreing key. after adding foreign key it works.

narayansharma91 Over a year ago

@ThataL I'm talking about the primary column of Item model.

ThataL Over a year ago

Ok my mistake (primary key of another model). accept my edit I will vote as answer. Description is minimum that's why it make me confused.

|

Collectives™ on Stack Overflow

Laravel eloquent with relation data (Eager Loading)

2 Answers 2

3 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related