Row count and sum in laravel

$count = DB::table('is_profile_completed')->where('userd', $userid)->count();
$sum = DB::table('is_profile_completed')->where('userd', $userid)->sum('salary');

$data = DB::table('posts')->where('post_status_for_frontend', 1)->orderBy('updated_at', 'desc')->paginate(4);
{{count($data)}}

 

Leave a Reply