根据学生的总分对学生进行排名 [英] Ranking students based on their total score

问题描述

问候，我需要一个关于如何根据他们的总分对学生进行排名的帮助，我有他们的分数存储的表格，因此，我希望能够根据他的分数确定个别学生的等级/位置/她的总分。



我的表：



student_regno | academic_session | academic_term | CLASS_NAME | class_group | total_score

OUT20267 2016/2017第一小学6 A 480

OUT20336 2016/2017第一小学6 B 520

OUT20139 2016 / 2017年第一学期小学6 A 593



当我拿到它时，我想要这样的东西：



OUT20267 =第3名; OUT20336 =第二名; OUT20139 = 1等等......



我尝试过的事情：



$ class_name = $ conn-> real_escape_string（$ _ POST ['h_class_name']）;

$ class_group = $ conn-> real_escape_string（$ _ POST ['h_class_group']）;

$ student_regno = $ conn-> real_escape_string（$ _ POST ['h_student_regno']）;

$ academic_session = $ conn-> real_escape_string（$ _ POST ['h_academic_session' ]）;

$ academic_term = $ conn-> real_escape_string（$ _ POST ['h_academic_term']）;





$ data =SELECT total_score FROM student_compile_result WHERE student_regno ='$ student_regno'AND class_name ='$ class_name'AND class_group ='$ class_group'AND academic_session ='$ academic_session'AND academic_term ='$ academic_term'ORDER BY abs （total_score）;

$ datas = mysqli_query（$ conn，$ data）;

$ row = $ datas-> fetch_assoc（）;



// wh ile（list（$ student_regno，$ class_name，$ class_group，$ academic_term，$ academic_session，$ total_score）= mysqli_fetch_row（$ datas））



$ student_rank = $ row ['total_score'];



echo $ student_rank;

Greetings, Please i need a help on how to rank students based on their total scores, i have table where their scores are stored, therefore, i want to be able to determine the rank/position of the individual student based on his/her total score.

My Table:

student_regno| academic_session| academic_term| class_name| class_group| total_score
OUT20267 2016/2017 First-Term Primary 6 A 480
OUT20336 2016/2017 First-Term Primary 6 B 520
OUT20139 2016/2017 First-Term Primary 6 A 593

I want something like this when i fetch it:

OUT20267 = 3rd; OUT20336 = 2nd; OUT20139 = 1st and so on...

What I have tried:

$class_name = $conn->real_escape_string($_POST['h_class_name']);
$class_group = $conn->real_escape_string($_POST['h_class_group']);
$student_regno = $conn->real_escape_string($_POST['h_student_regno']);
$academic_session = $conn->real_escape_string($_POST['h_academic_session']);
$academic_term = $conn->real_escape_string($_POST['h_academic_term']);


$data = "SELECT total_score FROM student_compile_result WHERE student_regno ='$student_regno' AND class_name = '$class_name' AND class_group='$class_group' AND academic_session = '$academic_session' AND academic_term = '$academic_term' ORDER BY abs(total_score)";
$datas = mysqli_query($conn,$data);
$row = $datas->fetch_assoc();

//while(list($student_regno, $class_name, $class_group, $academic_term, $academic_session, $total_score) = mysqli_fetch_row($datas))

$student_rank=$row['total_score'];

echo $student_rank;

推荐答案

class_name =

class_name =

conn-> real_escape_string（

conn->real_escape_string(

_POST ['h_class_name']）;

_POST['h_class_name']);

这篇关于根据学生的总分对学生进行排名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！