Level 122
do students have more than one class?
2 likes
Jun 20, 2022
7
Level 1
How to get rank student using laravel
I'm trying to get the rank of the student using the total marks, i.e. the student with higher marks than the other should be first and so on. Then when two or more students have the same total marks, they should have the same rank, help me. I have two tables. 1- table - students:
id name class_id created_at
1 Emma 1
2 Frank 3
3 Bright 4
4 Doe 1
2- table - marks:
id id_student class_id subject_id mark created_at
1 2 3 2 115
2 4 1 1 120
3 3 4 4 90
I want to get the rank for student the highly mark. How to make it please.
Level 1
@Snapey Thank you for your reply, Students have different classes. For example: the 1st class has 10 students and the 2nd has 20 students
Level 1
I need help, please. someone can help me?
Level 39
Level 1
your requirement is somewhat confusing. But if we proceed with your Table we could have something like this to get the total_score
$total_score = DB::table('YourTable')->select(DB::raw("SUM(mark) as total"))->where('id_student', '=',
$id_student)->get();
you should see the collection you can work with, if you dd($total_score);
1 like
Please or to participate in this conversation.