How to count query in Laravel Eloquent?

Dear Developers, I need to count and specific item from mysql using laravel eloquent query for current month. Like when i will count item it will count only for that month . but I unable to do that . I am just trying to count only but its not working too :(

$attendence= DB::table('students')
            ->join('attendences', 'attendences.student_username', '=', 'students.username')
            ->select(
            count('attendences.attendence'),
                     'attendences.created_at'
            )->where('username',$request->name)
            ->get();

I am getting error ""count(): Parameter must be an array or an object that implements Countable""

FareedR

6 years ago

Level 3

you can try this . it might be error . but i guess you can find something with that code ;)

$attendance = Attendance::with('student', function ($query) {
    $query->where('username',$request->name);
})->where('created_at')->count();

Sinnbeck

6 years ago

Level 102

Something like this

 ->selectRaw('count(attendences.attendence), attendences.created_at')

Please or to participate in this conversation.