Sort data for today only Laravel 8 - how?

Question

Laravel

Good afternoon. There is a conditional database - sessions with the last_activity date. It is

necessary to display in the blade only the data received for today.

Code for getting data from the sessions table:

$sessionDataActivityALl = DB::table('sessions')
                                ->select('last_activity')
                                ->get();

$newVisitsToday = $sessionDataActivityALl->count();

how to sort this data only for today?

Answer 1

DB::table('sessions')
    ->select('last_activity')
    ->whereDate('last_activity', today())
    ->get();

but if you just count, then you don’t need to create a collection (count on request)