Home / Questions / 88514
Accepted
Soy César Mora
Asked: 2020-07-21 20:44:39 +0800 CST 2020-07-21 20:44:39 +0800 CST

Each returns null in relations laravel 5.4

  • 772

I have been practicing laraveland there is something that does not work for me and I do not finish understanding or reviewing the documentation.

It turns out that I want to call the related objects between tables to be able to get their other data, and when I do it findwith a specific id for an object it works, but when I do it with eachfor the entire list it returns the relationships as NULL.

//Here I return NULL

$articles = Article::orderBy('id','DESC')->paginate(5);
$articles->each(function($articles){
    $articles->categorie;
    $articles->user;
});
dd($articles);

// But if I try it like this, it returns the relationships well

$articles = Article::find(2);
$articles->categorie;
$articles->user;    
dd($articles);
php

3 Answers

  1. What if you do it with a normal foreach?

    $articles = Article::orderBy('id','DESC')->paginate(5);
foreach($articles as $article){
    $article->categorie;
    $article->user;
});
dd($articles);

    It may also be that you are overloading the $articles test variable like this:

    $articles = Article::orderBy('id','DESC')->paginate(5);
$articles->each(function($article){
    $article->categorie;
    $article->user;
});
dd($articles);
    • 0

  2. Take a look at the "with()" function that will basically save you what you're trying to do

    $articles = Article::with('categorie')->with('user')->orderBy('id','DESC')->paginate(5);

    I leave you the official link https://laravel.com/docs/5.4/eloquent-relationships#eager-loading

    • 0
  3. Best Answer

    It is not really each()the right option in this case, since it is simply a wrapper to iterate, but it is not the way to obtain the relationships.

    For that there is Eager Loading , which allows you to load one or several relationships when using Eloquent and before generating the query. The advantage with respect to the second method that you show in the question is that you make a single query with Eager Loading, while with a foreach or calling the collections later without preloading them, it generates additional queries:

    $articles = Article::with(['categorie', 'user'])->orderBy('id','DESC')->paginate(5);

    In case you need for some reason to load the relations after having made the first query, the best way is with load():

    $articles = Article::orderBy('id','DESC')->paginate(5);

$articles->load('categorie', 'user');

    Notice the slight difference in how input parameters should be passed in both methods.

    • 0