How to get nested tables' data using Eloquent Relationships - Laravel?

Question

I've two tables: 1. categories, 2. Items

Categories.php

____________
id | name
___|________
 1 | shirt
 2 | shoes

Items.php

__________________________
id | categories_id | name
___|_______________|______
 1 |   1           | casual
 2 |   1           | dress
 3 |   2           | leather
 4 |   2           | jogar

Now I want to get the data of both tables using Eloquent relationship.

Desired array:

[
  'name' => 'shirts',
  'items' => ['casual', 'dress']
],
[
   'name' => 'shoes',
   'items' => ['leather', 'jogar']
 ]

Kenny Horna · Accepted Answer · 2018-10-18 22:25:32Z

3

First, you need to define your relationship.

By the look of your db structure, it seems that a Category has many Items. So in this case it can be a One-to-Many or Many-to-many relationship. I'll go for the first one in this answer.

Now, in your models, define the relationship.

Category.php

public function items()
{
    return $this->hasMany(Item::class);
}

Items.php

public function category()
{
    return $this->belongsTo(Category::class);
}

Now, when querying results, you can do as simple use the with() method to eager load the relationship items

// Perform your query and load the relationship
$categories = Category::with('items')->get();

or the load() one, to lazy eager loading the related items.

// Perform your query
$categories = Category::all();
// load the related items
$categories->load('items');

answered Oct 18, 2018 at 22:25

Kenny Horna

14.3k5 gold badges49 silver badges74 bronze badges

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

2 Comments

Zia Over a year ago

Thanks, its working. Actually I'm new on laravel and also on ORM.

Kenny Horna Over a year ago

@Zia Hi, if this was helpful to you, please accept the answer.

Kenny Horna · Accepted Answer · 2018-10-18 22:32:16Z

0

Link to the documentation: Eloquent Relationships.

in your Items.php

public function category()
{
    return $this->belongsTo('App\Categories', 'foreign_key');
}

From that on just use:

$items = new Items;
$category = $items->category;

edited Oct 18, 2018 at 22:32

Kenny Horna

14.3k5 gold badges49 silver badges74 bronze badges

answered Oct 18, 2018 at 21:41

Szucs Eduard

12510 bronze badges

Comments

amany alshalatoni · Accepted Answer · 2018-10-18 22:56:43Z

0

After make model Category and item you can go to Category controller and get the data from Category by

$cat = Category::all();

don not forget add

use App\Category;

and the same thing if you want Item , Best Regards

answered Oct 18, 2018 at 22:56

amany alshalatoni

471 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to get nested tables' data using Eloquent Relationships - Laravel?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related