Skip to content

Instantly share code, notes, and snippets.

@tisuchi

tisuchi/laravel-fetch-results-grouped-days-way-1

Created June 30, 2017 07:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tisuchi/a705e6d81308d9d6133954a3827404f2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tisuchi/a705e6d81308d9d6133954a3827404f2 to your computer and use it in GitHub Desktop.
Download ZIP
Laravel fetch results grouped by days // larademy.com
Raw
laravel-fetch-results-grouped-days-way-1
$users =DB::table('users')
->select(DB::raw('DATE(created_at) as date'), DB::raw('count(*) as views'))
->groupBy('date')
->get();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment