Total Users

@php $user = DB::table('users')->count(); echo $user; @endphp

Total Posts

@php use Illuminate\Support\Facades\DB; $post = DB::table('posts')->count(); echo $post; @endphp

New Users (7 days)

@php // $getusertoday = User::where('encoded_by', '=', $profile->name) // ->whereDate('created_at', '>=', date('Y-m-d H:i:s',strtotime('-7 days')) )->count(); use Carbon\Carbon; use App\Models\User; $startDate = Carbon::now()->subDays(7); $endDate = Carbon::now(); $count = User::whereBetween('created_at', [$startDate, $endDate])->count(); echo $count; @endphp

New Posts (7 days)

@php // use Carbon\Carbon; use App\Models\Post; $startDate = Carbon::now()->subDays(7); $endDate = Carbon::now(); $count = Post::whereBetween('created_at', [$startDate, $endDate])->count(); echo $count; @endphp