How to access a column in laravel query result

Question

I'm getting an error in my controller Undefined property: Illuminate\Database\Eloquent\Collection::$created_at

How can I access a column created_at from a result of laravel query?

Controller Code:

    public function getDashboard() {
        $posts=Post::latest('created_at')->get();
        dd($posts->created_at);
  //      $posts->created_at=Carbon::parse($posts->created_at)->diffForHumans(Carbon::now());
        return view('dashboard',compact('posts'));
    }

It works with findOrFail(some_id) but not with this, why?

If that code works with findOrFail then something is wrong. Also, instead of setting Post::created_at in a controller you could use an accessor in your model. Look here — Peter Chaula
– Peter Chaula, Commented Dec 29, 2016 at 13:44

Alexey Mezenin · Accepted Answer · 2016-12-29 13:35:03Z

8

get() returns collection, so you need to iterate over it:

foreach ($posts as $post) {
    echo $post->created_at;
}

Or you could use first() to get object instead of collection. In this case this would work:

$post = Post::latest()->first();
$post->created_at;

Also, you don't need to pass created_at to latest(), because this column is defined as default:

public function latest($column = 'created_at')

edited Dec 29, 2016 at 13:35

answered Dec 29, 2016 at 13:33

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

4 Comments

Jaskaran Singh Puri Over a year ago

will first() return all rows?

Alexey Mezenin Over a year ago

No, it will return only one object (first one). If you have multiple items, using foreach is the only option.

Jaskaran Singh Puri Over a year ago

It's throwing an error A two digit month could not be found Data missing. Code updated!

Alexey Mezenin Over a year ago

@JaskaranSinghPuri it's not related to original question and you should create another question, post the error etc. I think you can't do $post->created_at= and also you don't need to parse created_at since it's already an instance of Carbon.

Amit Gupta · Accepted Answer · 2016-12-29 13:48:28Z

2

As $post is an instance Collection you have to use foreach as:

foreach ($posts as $post) {
    dd($post->created_at);
}

Or you can use first to get first object or last to get last object as

dd($posts->first()->created_at);

dd($posts->last()->created_at);

Update

Try it as:

foreach ($posts as $post) {
    $post->diff_for_humans = $post->created_at->diffForHumans();
}

Then your can access it as:

foreach ($posts as $post) {
    dd($post->diff_for_humans);
}

edited Dec 29, 2016 at 13:48

answered Dec 29, 2016 at 13:33

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

2 Comments

DevK Over a year ago

Or better yet, call the ->first() method on the query rather than collection itself, if 1 result is all that is needed.

Jaskaran Singh Puri Over a year ago

It's throwing an error A two digit month could not be found Data missing. Code updated!

meda · Accepted Answer · 2016-12-29 13:46:00Z

0

when you call get() you can pass an array of fields to select:

$posts = Post::latest()->get(['created_at']);

then dump to see, what is inside with dd($post)

answered Dec 29, 2016 at 13:46

meda

45.5k14 gold badges96 silver badges123 bronze badges

Collectives™ on Stack Overflow

How to access a column in laravel query result

3 Answers 3

4 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related