Level 47
Get attribute in your model will set the get value every time you query the table.
Aug 13, 2015
5
Level 3
Passing query results to blade - edit date format
Hi everybody,
In my User table in DB I have column online where I store datetime. I pass results to blade:
$users = User::get(); return view('admin/user/index', compact('users'));
How can I format that online value before passing it to blade? I also need to add there condition to format date only when it's not NULL.
Level 8
You may consider:
- setting $dateFormat property on your model. This property determines how date attributes are stored in the database. Format is the same as in php's date functions
- define mutator in your model http://laravel.com/docs/5.1/eloquent-mutators#accessors-and-mutators
- using client side library like moment.js to format it via js
Personally I would go for the 2nd option
Level 13
In your User class add
class User extends Model
{
protected $dates = ['your_date'];
}
Now, you can simply in blade view (or controller if you want).
$user->your_date->format('d/m/Y');
// if null == empty value, dont worry
2 likes
Level 3
helmerdavila, could you tell me, why i have error if my date is NULL? If i have some value, it works, but if not, i have this error: "Call to a member function format() on a non-object"
Thats why i need to use this:
<td>{{ $user->birthday ? $user->birthday->format('d/m/Y') : '' }}</td>
but i think its not right
Level 80
@Nik0n This thread was nearly ** a decade** old.
Please create a new thread if you have an issue instead of replying to ancient ones where participants may not be around any more.
Please or to participate in this conversation.