Laravel 5.6 time ago in views

Question

<?php

namespace project1\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use View;

class IndexController extends Controller
{
    public function index() 
    {
          $users  = DB::table('users')->orderBy('created_at','desc')->limit(5)->get();
          return View::make('pages.dashboard.dashboard',['users' => $users]);
    }
}

Is it possible to echo the Time Ago in my View ( pages.dashboard.dashboard ) Something Like,

{{ $user->created_at->diffForHumans() }}

Expecting output like,

1 min ago

Yes, it’s possible. Have you tried? – Martin Bean Jul 19 '18 at 11:52 — Martin Bean, Jul 19 '18 at 11:52

im-sunil · Accepted Answer · 2018-07-19T11:50:24.297

35

First, try an eloquent model.

$users = App\User::orderBy('created_at','desc')->limit(5)->get();

in view

@foreach($users as $user) {{$user->created_at->diffForHumans()}} @endforeach

In Terms for your case

$users = DB::table('users')->orderBy('created_at','desc')->limit(5)->get();

@foreach($users as $user) {{ Carbon\Carbon::parse($user->created_at)->diffForHumans()}} @endforeach

Explanation

The eloquent model automatically get casts to Carbon instance and you can use an all methods

In the case of DB query date (created_at) is not get parse so we have to parse manually.

edited Jul 19 '18 at 11:50

answered Jul 19 '18 at 11:43

im-sunil

434
4
9

It's only working for 'hours ago'. not showing in seconds or minutes. – Shariq Shaikh Oct 08 '20 at 11:05

score 4 · Answer 2 · edited Jul 19 '18 at 13:13

maybe it would help you

A nice semi-hidden feature of timestamps in Eloquent is that they don't just return strings from the database - they actually return an instance of Carbon, a great extension of PHP's DateTime library. What this means is that a heap of functions (and I mean a heap) are available right on your model's timestamps. It's worth having a read through the GitHub README to see what is available, but one of the coolest methods is diffForHumans(), a handy little function providing the long sought-after "time ago" format we often need.

$user = User::first();
echo $user->created_at->diffForHumans(); // 2 days ago

$user->touch();
echo $user->created_at->diffForHumans(); // a second ago

Or

If created_date is an instance of Carbon\Carbon, you can do:

$row->created_date->diffForHumans()

If it isn't an instance of Carbon, you can do:

(new Carbon\Carbon($row->created_date))->diffForHumans()

Or you add the model property to the $dates casting list in the model, which will cast the property to a Carbon instance whenever you access it (like $user->created_date):

class User
{
    protected $dates = [
        'created_date',
    ];
}

The fields created_at and updated_at are added to this casting list automatically if $timestamps of a model is set to true. Also deleted_at will be added if soft deletes are enabled.

score 1 · Answer 3 · answered Aug 08 '21 at 11:48

1

Laravel 5.5> just write

Returns whatever time ago

answered Aug 08 '21 at 11:48

Dennis Kipchumba

19
2

score 0 · Answer 4 · answered Feb 21 '19 at 06:59

0

just write ->diffForHumans(); after your time. like $record->created_date->diffForHumans();

answered Feb 21 '19 at 06:59

Imad Ullah

929
9
17

Laravel 5.6 time ago in views

4 Answers4