Many-to-many relationship - it doesn't display elements

I want to have many-to-many relationship. So i created:
Into Game model

public function category(){

      return $this->belongsToMany('AppCategory');

  }

Into Category model

public function games(){

          return $this->hasMany('AppGame');

    }

Into controller

$category = Category::where('slug', $slug)->first();

      dd($category->games());

      return view('frontend.game.gamelist')->with('elements', $category->games());

Generally, I try display all games belongs to particular category. I see something like this
enter image description here

If I remove dd() view won't display any elements.But it doesn't problem with view.

@foreach($elements as $element)

//...

@endforeach

Why it doesn;t work?

asked Nov 20 '18 at 13:49

MrBelongsTo

186

It must be $category->games not $category->games(), Call it like a property.

– ako
Nov 20 '18 at 13:56

add a comment |

I want to have many-to-many relationship. So i created:
Into Game model

public function category(){

      return $this->belongsToMany('AppCategory');

  }

Into Category model

public function games(){

          return $this->hasMany('AppGame');

    }

Into controller

$category = Category::where('slug', $slug)->first();

      dd($category->games());

      return view('frontend.game.gamelist')->with('elements', $category->games());

Generally, I try display all games belongs to particular category. I see something like this
enter image description here

If I remove dd() view won't display any elements.But it doesn't problem with view.

@foreach($elements as $element)

//...

@endforeach

Why it doesn;t work?

asked Nov 20 '18 at 13:49

MrBelongsTo

186

It must be $category->games not $category->games(), Call it like a property.

– ako
Nov 20 '18 at 13:56

add a comment |

I want to have many-to-many relationship. So i created:
Into Game model

public function category(){

      return $this->belongsToMany('AppCategory');

  }

Into Category model

public function games(){

          return $this->hasMany('AppGame');

    }

Into controller

$category = Category::where('slug', $slug)->first();

      dd($category->games());

      return view('frontend.game.gamelist')->with('elements', $category->games());

Generally, I try display all games belongs to particular category. I see something like this
enter image description here

If I remove dd() view won't display any elements.But it doesn't problem with view.

@foreach($elements as $element)

//...

@endforeach

Why it doesn;t work?

asked Nov 20 '18 at 13:49

MrBelongsTo

186

I want to have many-to-many relationship. So i created:
Into Game model

public function category(){

      return $this->belongsToMany('AppCategory');

  }

Into Category model

public function games(){

          return $this->hasMany('AppGame');

    }

Into controller

$category = Category::where('slug', $slug)->first();

      dd($category->games());

      return view('frontend.game.gamelist')->with('elements', $category->games());

Generally, I try display all games belongs to particular category. I see something like this
enter image description here

If I remove dd() view won't display any elements.But it doesn't problem with view.

@foreach($elements as $element)

//...

@endforeach

Why it doesn;t work?

laravel many-to-many relationship

asked Nov 20 '18 at 13:49

MrBelongsTo

186

asked Nov 20 '18 at 13:49

MrBelongsTo

186

asked Nov 20 '18 at 13:49

MrBelongsTo

186

asked Nov 20 '18 at 13:49

MrBelongsTo

186

asked Nov 20 '18 at 13:49

MrBelongsTo

186

It must be $category->games not $category->games(), Call it like a property.

– ako
Nov 20 '18 at 13:56

add a comment |

It must be $category->games not $category->games(), Call it like a property.

– ako
Nov 20 '18 at 13:56

It must be $category->games not $category->games(), Call it like a property.

– ako
Nov 20 '18 at 13:56

add a comment |

4 Answers
4

active

oldest

votes

You Category model also needs to have belongsToMany in its games() relation.

public function games() {

    return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:51

Jerodev

19k84572

add a comment |

You are using lazy loaded data

Laravel eloquent Lazy Vs. Eager Loaded

Update your controller method:

$category = Category::with('games')->where('slug', $slug)->first();

dd($category->games);



return view('frontend.game.gamelist')->with('elements', $category);

You have to get all the category with games, so that you can get those data with an query also see them in dd function.

If you only get category and then do category->games() it will execute another query in your view.

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

add a comment |

When you do:

$category->games();

you are accessing the relationship itself (useful to attach contraints), not the elements of the relation. Check this other answer for a detail explanation.

Try this instead:

$category->games;

OBS

When doing a Many-to-Many relationship, the belongsToMany method needs to be specified in both models.

Category.php

public function games()

{

      return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:58

HCK

3,58911035

add a comment |

You need to have a belongsToMany relationship in your Category model as well to have a many-many relationship. You can achieve this by doing:

public function games() 

{

    return $this->belongsToMany('AppGame');

}

Then in your category controller, you have:

$category = Category::with('games')->where('slug', $slug)->get();



return view('frontend.game.gamelist', compact('category');

Then in your view, you can access the list of games by

@foreach($category->games as $game)

//...

@endforeach

edited Nov 20 '18 at 14:10

answered Nov 20 '18 at 14:04

Peter Sowah

445211

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53394478%2fmany-to-many-relationship-it-doesnt-display-elements%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

4 Answers
4

active

oldest

votes

4 Answers
4

active

oldest

votes

You Category model also needs to have belongsToMany in its games() relation.

public function games() {

    return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:51

Jerodev

19k84572

add a comment |

You Category model also needs to have belongsToMany in its games() relation.

public function games() {

    return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:51

Jerodev

19k84572

add a comment |

You Category model also needs to have belongsToMany in its games() relation.

public function games() {

    return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:51

Jerodev

19k84572

You Category model also needs to have belongsToMany in its games() relation.

public function games() {

    return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:51

Jerodev

19k84572

answered Nov 20 '18 at 13:51

Jerodev

19k84572

answered Nov 20 '18 at 13:51

Jerodev

19k84572

answered Nov 20 '18 at 13:51

Jerodev

19k84572

add a comment |

You are using lazy loaded data

Laravel eloquent Lazy Vs. Eager Loaded

Update your controller method:

$category = Category::with('games')->where('slug', $slug)->first();

dd($category->games);



return view('frontend.game.gamelist')->with('elements', $category);

You have to get all the category with games, so that you can get those data with an query also see them in dd function.

If you only get category and then do category->games() it will execute another query in your view.

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

add a comment |

You are using lazy loaded data

Laravel eloquent Lazy Vs. Eager Loaded

Update your controller method:

$category = Category::with('games')->where('slug', $slug)->first();

dd($category->games);



return view('frontend.game.gamelist')->with('elements', $category);

You have to get all the category with games, so that you can get those data with an query also see them in dd function.

If you only get category and then do category->games() it will execute another query in your view.

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

add a comment |

You are using lazy loaded data

Laravel eloquent Lazy Vs. Eager Loaded

Update your controller method:

$category = Category::with('games')->where('slug', $slug)->first();

dd($category->games);



return view('frontend.game.gamelist')->with('elements', $category);

You have to get all the category with games, so that you can get those data with an query also see them in dd function.

If you only get category and then do category->games() it will execute another query in your view.

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

You are using lazy loaded data

Laravel eloquent Lazy Vs. Eager Loaded

Update your controller method:

$category = Category::with('games')->where('slug', $slug)->first();

dd($category->games);



return view('frontend.game.gamelist')->with('elements', $category);

You have to get all the category with games, so that you can get those data with an query also see them in dd function.

If you only get category and then do category->games() it will execute another query in your view.

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

answered Nov 20 '18 at 13:56

Emtiaz Zahid

1,043616

add a comment |

When you do:

$category->games();

you are accessing the relationship itself (useful to attach contraints), not the elements of the relation. Check this other answer for a detail explanation.

Try this instead:

$category->games;

OBS

When doing a Many-to-Many relationship, the belongsToMany method needs to be specified in both models.

Category.php

public function games()

{

      return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:58

HCK

3,58911035

add a comment |

When you do:

$category->games();

you are accessing the relationship itself (useful to attach contraints), not the elements of the relation. Check this other answer for a detail explanation.

Try this instead:

$category->games;

OBS

When doing a Many-to-Many relationship, the belongsToMany method needs to be specified in both models.

Category.php

public function games()

{

      return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:58

HCK

3,58911035

add a comment |

When you do:

$category->games();

you are accessing the relationship itself (useful to attach contraints), not the elements of the relation. Check this other answer for a detail explanation.

Try this instead:

$category->games;

OBS

When doing a Many-to-Many relationship, the belongsToMany method needs to be specified in both models.

Category.php

public function games()

{

      return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:58

HCK

3,58911035

When you do:

$category->games();

you are accessing the relationship itself (useful to attach contraints), not the elements of the relation. Check this other answer for a detail explanation.

Try this instead:

$category->games;

OBS

When doing a Many-to-Many relationship, the belongsToMany method needs to be specified in both models.

Category.php

public function games()

{

      return $this->belongsToMany('AppGame');

}

answered Nov 20 '18 at 13:58

HCK

3,58911035

answered Nov 20 '18 at 13:58

HCK

3,58911035

answered Nov 20 '18 at 13:58

HCK

3,58911035

answered Nov 20 '18 at 13:58

HCK

3,58911035

add a comment |

You need to have a belongsToMany relationship in your Category model as well to have a many-many relationship. You can achieve this by doing:

public function games() 

{

    return $this->belongsToMany('AppGame');

}

Then in your category controller, you have:

$category = Category::with('games')->where('slug', $slug)->get();



return view('frontend.game.gamelist', compact('category');

Then in your view, you can access the list of games by

@foreach($category->games as $game)

//...

@endforeach

edited Nov 20 '18 at 14:10

answered Nov 20 '18 at 14:04

Peter Sowah

445211

add a comment |

You need to have a belongsToMany relationship in your Category model as well to have a many-many relationship. You can achieve this by doing:

public function games() 

{

    return $this->belongsToMany('AppGame');

}

Then in your category controller, you have:

$category = Category::with('games')->where('slug', $slug)->get();



return view('frontend.game.gamelist', compact('category');

Then in your view, you can access the list of games by

@foreach($category->games as $game)

//...

@endforeach

edited Nov 20 '18 at 14:10

answered Nov 20 '18 at 14:04

Peter Sowah

445211

add a comment |

You need to have a belongsToMany relationship in your Category model as well to have a many-many relationship. You can achieve this by doing:

public function games() 

{

    return $this->belongsToMany('AppGame');

}

Then in your category controller, you have:

$category = Category::with('games')->where('slug', $slug)->get();



return view('frontend.game.gamelist', compact('category');

Then in your view, you can access the list of games by

@foreach($category->games as $game)

//...

@endforeach

edited Nov 20 '18 at 14:10

answered Nov 20 '18 at 14:04

Peter Sowah

445211

You need to have a belongsToMany relationship in your Category model as well to have a many-many relationship. You can achieve this by doing:

public function games() 

{

    return $this->belongsToMany('AppGame');

}

Then in your category controller, you have:

$category = Category::with('games')->where('slug', $slug)->get();



return view('frontend.game.gamelist', compact('category');

Then in your view, you can access the list of games by

@foreach($category->games as $game)

//...

@endforeach

edited Nov 20 '18 at 14:10

answered Nov 20 '18 at 14:04

Peter Sowah

445211

edited Nov 20 '18 at 14:10

answered Nov 20 '18 at 14:04

Peter Sowah

445211

answered Nov 20 '18 at 14:04

Peter Sowah

445211

answered Nov 20 '18 at 14:04

Peter Sowah

445211

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Cfrgtkky

Many-to-many relationship - it doesn't display elements

4 Answers
4

OBS

Your Answer

Post as a guest

4 Answers
4

4 Answers
4

OBS

OBS

OBS

OBS

Post as a guest

Popular posts from this blog

How to change which sound is reproduced for terminal bell?

Can I use Tabulator js library in my java Spring + Thymeleaf project?

Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

Many-to-many relationship - it doesn't display elements

4 Answers 4

OBS

Your Answer

Sign up or log in

Post as a guest

Post as a guest

4 Answers 4

4 Answers 4

OBS

OBS

OBS

OBS

Sign up or log in

Post as a guest

Post as a guest

Sign up or log in

Post as a guest

Sign up or log in

Post as a guest

Sign up or log in

Post as a guest

Popular posts from this blog

How to change which sound is reproduced for terminal bell?

Can I use Tabulator js library in my java Spring + Thymeleaf project?

Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

4 Answers
4

4 Answers
4

4 Answers
4