Fetch data from DB within last 24h, how can i do that?

Do you have timestamps on the tables you want to get the data for?

Sure! here is screenshot of my db https://www.dropbox.com/s/xovw4tjcv38xqc1/baza.png

Maybe something like:

$newMoods = Mood::where('created_at', '>=', Carbon::now()->subDay())->get();

Or, add a query scope, so that you can just do:

Mood::sinceDaysAgo(2)->get();

http://laravel.com/docs/eloquent#query-scopes

That works. Thanks again @jeffreyway, i had written something similiar, but i think that i didn't put ->get() at the end. Everything works just fine. Carbon is really awesome!

It is! Easily one of my favorite PHP packages.

If you want relative dates for when each mood was left, like "5 minutes ago," you can do $mood->created_at->diffForHumans().

In meantime, is it good to keep all my varibales like this? http://laravel.io/bin/9378G

And one more question, how can i provide single variable for two or more views in controller? Do i have to use something like this?

View::composer('profile', function($view)
{
  $view->with('count', User::count());
});

@jeffreyway i did this already check it out http://zimodigital.com/clients/howdoyou/mood, and yes i created fancy animated counter :)

You can do it - {{date("H", strtotime($variable))}}, you can use big H to your hour format be 24 hours and little h to your hour be 12 hours.