Level 70
You can try this in your controller-
$attendedStudents = Attendance::where('present', 1)->get();
$nonattendedStudents = Attendance::where('present', 0)->get();
Aug 21, 2017
1
Level 2
Help with Eloquent and Query builder/Blade
Hello all,
I could really use some help with the following:
I am building a class schedule with students that attend and dont attend class on a given day.
My database table has 4 columns:
class_id(foreign key) student_id(foreign key)
present(boolean 0/1)
date.
Writing sql at phpmyadmin I have achieved this:
SELECT student_id ,class_id
FROM attendance
WHERE present = 1(present) .
However, I don't know how to apply this using blade and eloquent,query builder to get to:
Class 1: student_id = 1 (present) student_id = 1 (present)
Class 2: student_id = 1 (present) student_id = 1 (present)
Please or to participate in this conversation.