Laravel - Undefined property in array

Question

I cant figure out why, but I can var_dump($cPage) and get the complete array, but I can't access my variable in the view. {{ $cPage->code }} allways gets me an "Undefined property: Illuminate\Database\Eloquent\Collection::$code" error. Can anyone explain me why?

Controller:

public function getPages($lang, $slug)
{

    $cPage = Page::join('langs', 'langs.id', '=', 'pages.lang_parent_id')
            ->where('slug', '=', $slug)
            ->where('code', '=', $lang)
            ->get();

    $mainPages = Page::where('parent_id', null)
                ->get();

    $allPages = $this->getAllPages($mainPages);

    return View::make('index')
    ->with('cPage', $cPage)
    ->with('mainPages', $mainPages)
    ->with('allPages', $allPages);

}

View

<ul class="nav">
  <li class="dropdown">
    <button type="submit" class="btn dropdown-toggle icon-white" data-toggle="dropdown"> {{ $cPage->code }} <b class="caret"></b></button>
    <ul class="dropdown-menu pull-right">
      <li><a href="#">Português</a></li>
      <li><a href="#">English</a></li>
    </ul>
  </li>
</ul>

var_dump($cPage)

array(1) { [0]=> array(9) { ["id"]=> string(1) "1" ["parent_id"]=> NULL ["lang_parent_id"]=> string(1) "1" ["translate_parent_id"]=> NULL ["title"]=> string(8) "Clientes" ["slug"]=> string(8) "clientes" ["sort"]=> NULL ["name"]=> string(10) "PortuguÃªs" ["code"]=> string(2) "pt" } }

Thanks, it worked with ->first(). Can you offer me an explanation for this? — Rui Silva
– Rui Silva, Commented Nov 4, 2014 at 18:07
Your query potentially returns multiple results so get returns a collection (even if its just one result). First limits the query to one result and returns that — lukasgeiter
– lukasgeiter, Commented Nov 4, 2014 at 18:11

Marcin Nabiałek · Accepted Answer · 2014-11-04 18:04:33Z

1

You need to use loop in your view, or if you expect only one result, you can change get into first:

$cPage = Page::join('langs', 'langs.id', '=', 'pages.lang_parent_id')
        ->where('slug', '=', $slug)
        ->where('code', '=', $lang)
        ->first();

answered Nov 4, 2014 at 18:04

Marcin Nabiałek

112k43 gold badges272 silver badges300 bronze badges

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

Collectives™ on Stack Overflow

Laravel - Undefined property in array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related