mysql - PHP数据排序问题？
mysql
php
我正在做一个学生成绩排名的功能，导入原生成绩数据（语文、数学、英语、物理、化学、生物、历史、地理、政治）然后计算出每位同学的各科班级排名和各科年级排名情况，后期支持导出数据（原生成绩+成绩单科班级排名+成绩单科年级排名）。
举例
| 考号 | 年级 | 班级 | 语文 | 语文班名次 | 语文级名次 |
|---|---|---|---|---|---|
| 1 | 1 | 1 | 70 | ||
| 2 | 1 | 2 | 80 | ||
| 3 | 1 | 2 | 90 | ||
| 4 | 1 | 1 | 70 | ||
| 5 | 1 | 2 | 80 | ||
| 6 | 1 | 3 | 81 | ||
| 7 | 1 | 1 | 70 | ||
| 8 | 1 | 2 | 80 | ||
| 9 | 1 | 3 | 90 | ||
| 10 | 1 | 1 | 70 | ||
| 11 | 1 | 2 | 80 | ||
| 12 | 1 | 2 | 90 | ||
| 13 | 1 | 1 | 70 | ||
| 14 | 1 | 3 | 81 | ||
| 15 | 1 | 2 | 90 |
排名是在导入数据时php处理，还是导入原始数据后再用mysql处理，给一个示例一下，谢谢
相同分数名次相同如何处理
补充一个php做的分数排序，如何和排名序号结合起来？同分一样如何处理呢？（为了自己认识全是中文键名）
yuwenji:语文分数年级排序
yuwenban[1]:1班语文分数排序
依次类推
Array
(
[yuwenji] => Array
(
[111111000000000009] => 60
[111111000000000008] => 60
[111111000000000011] => 60
[111111000000000012] => 60
[111111000000000013] => 60
[111111000000000007] => 60
[111111000000000006] => 60
[111111000000000002] => 60
[111111000000000001] => 60
[111111000000000003] => 60
[111111000000000004] => 60
[111111000000000005] => 60
[111111000000000010] => 60
)
[yuwenban] => Array
(
[2] => Array
(
[111111000000000009] => 60
[111111000000000011] => 60
[111111000000000004] => 60
[111111000000000003] => 60
[111111000000000002] => 60
[111111000000000010] => 60
)
[1] => Array
(
[111111000000000008] => 60
[111111000000000007] => 60
[111111000000000006] => 60
[111111000000000005] => 60
[111111000000000001] => 60
)
[3] => Array
(
[111111000000000013] => 60
[111111000000000012] => 60
)
)
[shuxueji] => Array
(
[111111000000000009] => 65
[111111000000000008] => 65
[111111000000000011] => 65
[111111000000000012] => 65
[111111000000000013] => 65
[111111000000000007] => 65
[111111000000000006] => 65
[111111000000000002] => 65
[111111000000000001] => 65
[111111000000000003] => 65
[111111000000000004] => 65
[111111000000000005] => 65
[111111000000000010] => 65
)
[shuxueban] => Array
(
[2] => Array
(
[111111000000000009] => 65
[111111000000000011] => 65
[111111000000000004] => 65
[111111000000000003] => 65
[111111000000000002] => 65
[111111000000000010] => 65
)
[1] => Array
(
[111111000000000008] => 65
[111111000000000007] => 65
[111111000000000006] => 65
[111111000000000005] => 65
[111111000000000001] => 65
)
[3] => Array
(
[111111000000000013] => 65
[111111000000000012] => 65
)
)
[englishji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[englishban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[wuliji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[wuliban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[huaxueji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[huaxueban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[shengwuji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[shengwuban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[lishiji] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000001] => 70
[111111000000000010] => 69
)
[lishiban] => Array
(
[2] => Array
(
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000010] => 69
)
[1] => Array
(
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000001] => 70
)
[3] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
)
)
[diliji] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000001] => 70
[111111000000000010] => 69
)
[diliban] => Array
(
[2] => Array
(
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000010] => 69
)
[1] => Array
(
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000001] => 70
)
[3] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
)
)
[zhengzhiji] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000001] => 70
[111111000000000010] => 69
)
[zhengzhiban] => Array
(
[2] => Array
(
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000010] => 69
)
[1] => Array
(
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000001] => 70
)
[3] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
)
)
[wenzongji] => Array
(
[111111000000000013] => 243
[111111000000000012] => 240
[111111000000000011] => 237
[111111000000000009] => 234
[111111000000000008] => 231
[111111000000000007] => 228
[111111000000000006] => 225
[111111000000000005] => 222
[111111000000000004] => 219
[111111000000000003] => 216
[111111000000000002] => 213
[111111000000000001] => 210
[111111000000000010] => 207
)
[wenzongban] => Array
(
[2] => Array
(
[111111000000000011] => 237
[111111000000000009] => 234
[111111000000000004] => 219
[111111000000000003] => 216
[111111000000000002] => 213
[111111000000000010] => 207
)
[1] => Array
(
[111111000000000008] => 231
[111111000000000007] => 228
[111111000000000006] => 225
[111111000000000005] => 222
[111111000000000001] => 210
)
[3] => Array
(
[111111000000000013] => 243
[111111000000000012] => 240
)
)
[lizongji] => Array
(
[111111000000000009] => 297
[111111000000000008] => 297
[111111000000000011] => 297
[111111000000000012] => 297
[111111000000000013] => 297
[111111000000000007] => 297
[111111000000000006] => 297
[111111000000000002] => 297
[111111000000000001] => 297
[111111000000000003] => 297
[111111000000000004] => 297
[111111000000000005] => 297
[111111000000000010] => 297
)
[lizongban] => Array
(
[2] => Array
(
[111111000000000009] => 297
[111111000000000011] => 297
[111111000000000004] => 297
[111111000000000003] => 297
[111111000000000002] => 297
[111111000000000010] => 297
)
[1] => Array
(
[111111000000000008] => 297
[111111000000000007] => 297
[111111000000000006] => 297
[111111000000000005] => 297
[111111000000000001] => 297
)
[3] => Array
(
[111111000000000013] => 297
[111111000000000012] => 297
)
)
[zongfenji] => Array
(
[111111000000000013] => 764
[111111000000000012] => 761
[111111000000000011] => 758
[111111000000000009] => 755
[111111000000000008] => 752
[111111000000000007] => 749
[111111000000000006] => 746
[111111000000000005] => 743
[111111000000000004] => 740
[111111000000000003] => 737
[111111000000000002] => 734
[111111000000000001] => 731
[111111000000000010] => 728
)
[zongfenban] => Array
(
[2] => Array
(
[111111000000000011] => 758
[111111000000000009] => 755
[111111000000000004] => 740
[111111000000000003] => 737
[111111000000000002] => 734
[111111000000000010] => 728
)
[1] => Array
(
[111111000000000008] => 752
[111111000000000007] => 749
[111111000000000006] => 746
[111111000000000005] => 743
[111111000000000001] => 731
)
[3] => Array
(
[111111000000000013] => 764
[111111000000000012] => 761
)
)
)
Salin selepas log masuk
Salin selepas log masuk
回复内容：
我正在做一个学生成绩排名的功能，导入原生成绩数据（语文、数学、英语、物理、化学、生物、历史、地理、政治）然后计算出每位同学的各科班级排名和各科年级排名情况，后期支持导出数据（原生成绩+成绩单科班级排名+成绩单科年级排名）。
举例
| 考号 | 年级 | 班级 | 语文 | 语文班名次 | 语文级名次 |
|---|---|---|---|---|---|
| 1 | 1 | 1 | 70 | ||
| 2 | 1 | 2 | 80 | ||
| 3 | 1 | 2 | 90 | ||
| 4 | 1 | 1 | 70 | ||
| 5 | 1 | 2 | 80 | ||
| 6 | 1 | 3 | 81 | ||
| 7 | 1 | 1 | 70 | ||
| 8 | 1 | 2 | 80 | ||
| 9 | 1 | 3 | 90 | ||
| 10 | 1 | 1 | 70 | ||
| 11 | 1 | 2 | 80 | ||
| 12 | 1 | 2 | 90 | ||
| 13 | 1 | 1 | 70 | ||
| 14 | 1 | 3 | 81 | ||
| 15 | 1 | 2 | 90 |
排名是在导入数据时php处理，还是导入原始数据后再用mysql处理，给一个示例一下，谢谢
相同分数名次相同如何处理
补充一个php做的分数排序，如何和排名序号结合起来？同分一样如何处理呢？（为了自己认识全是中文键名）
yuwenji:语文分数年级排序
yuwenban[1]:1班语文分数排序
依次类推
Array
(
[yuwenji] => Array
(
[111111000000000009] => 60
[111111000000000008] => 60
[111111000000000011] => 60
[111111000000000012] => 60
[111111000000000013] => 60
[111111000000000007] => 60
[111111000000000006] => 60
[111111000000000002] => 60
[111111000000000001] => 60
[111111000000000003] => 60
[111111000000000004] => 60
[111111000000000005] => 60
[111111000000000010] => 60
)
[yuwenban] => Array
(
[2] => Array
(
[111111000000000009] => 60
[111111000000000011] => 60
[111111000000000004] => 60
[111111000000000003] => 60
[111111000000000002] => 60
[111111000000000010] => 60
)
[1] => Array
(
[111111000000000008] => 60
[111111000000000007] => 60
[111111000000000006] => 60
[111111000000000005] => 60
[111111000000000001] => 60
)
[3] => Array
(
[111111000000000013] => 60
[111111000000000012] => 60
)
)
[shuxueji] => Array
(
[111111000000000009] => 65
[111111000000000008] => 65
[111111000000000011] => 65
[111111000000000012] => 65
[111111000000000013] => 65
[111111000000000007] => 65
[111111000000000006] => 65
[111111000000000002] => 65
[111111000000000001] => 65
[111111000000000003] => 65
[111111000000000004] => 65
[111111000000000005] => 65
[111111000000000010] => 65
)
[shuxueban] => Array
(
[2] => Array
(
[111111000000000009] => 65
[111111000000000011] => 65
[111111000000000004] => 65
[111111000000000003] => 65
[111111000000000002] => 65
[111111000000000010] => 65
)
[1] => Array
(
[111111000000000008] => 65
[111111000000000007] => 65
[111111000000000006] => 65
[111111000000000005] => 65
[111111000000000001] => 65
)
[3] => Array
(
[111111000000000013] => 65
[111111000000000012] => 65
)
)
[englishji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[englishban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[wuliji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[wuliban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[huaxueji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[huaxueban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[shengwuji] => Array
(
[111111000000000009] => 99
[111111000000000008] => 99
[111111000000000011] => 99
[111111000000000012] => 99
[111111000000000013] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000002] => 99
[111111000000000001] => 99
[111111000000000003] => 99
[111111000000000004] => 99
[111111000000000005] => 99
[111111000000000010] => 99
)
[shengwuban] => Array
(
[2] => Array
(
[111111000000000009] => 99
[111111000000000011] => 99
[111111000000000004] => 99
[111111000000000003] => 99
[111111000000000002] => 99
[111111000000000010] => 99
)
[1] => Array
(
[111111000000000008] => 99
[111111000000000007] => 99
[111111000000000006] => 99
[111111000000000005] => 99
[111111000000000001] => 99
)
[3] => Array
(
[111111000000000013] => 99
[111111000000000012] => 99
)
)
[lishiji] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000001] => 70
[111111000000000010] => 69
)
[lishiban] => Array
(
[2] => Array
(
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000010] => 69
)
[1] => Array
(
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000001] => 70
)
[3] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
)
)
[diliji] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000001] => 70
[111111000000000010] => 69
)
[diliban] => Array
(
[2] => Array
(
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000010] => 69
)
[1] => Array
(
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000001] => 70
)
[3] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
)
)
[zhengzhiji] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000001] => 70
[111111000000000010] => 69
)
[zhengzhiban] => Array
(
[2] => Array
(
[111111000000000011] => 79
[111111000000000009] => 78
[111111000000000004] => 73
[111111000000000003] => 72
[111111000000000002] => 71
[111111000000000010] => 69
)
[1] => Array
(
[111111000000000008] => 77
[111111000000000007] => 76
[111111000000000006] => 75
[111111000000000005] => 74
[111111000000000001] => 70
)
[3] => Array
(
[111111000000000013] => 81
[111111000000000012] => 80
)
)
[wenzongji] => Array
(
[111111000000000013] => 243
[111111000000000012] => 240
[111111000000000011] => 237
[111111000000000009] => 234
[111111000000000008] => 231
[111111000000000007] => 228
[111111000000000006] => 225
[111111000000000005] => 222
[111111000000000004] => 219
[111111000000000003] => 216
[111111000000000002] => 213
[111111000000000001] => 210
[111111000000000010] => 207
)
[wenzongban] => Array
(
[2] => Array
(
[111111000000000011] => 237
[111111000000000009] => 234
[111111000000000004] => 219
[111111000000000003] => 216
[111111000000000002] => 213
[111111000000000010] => 207
)
[1] => Array
(
[111111000000000008] => 231
[111111000000000007] => 228
[111111000000000006] => 225
[111111000000000005] => 222
[111111000000000001] => 210
)
[3] => Array
(
[111111000000000013] => 243
[111111000000000012] => 240
)
)
[lizongji] => Array
(
[111111000000000009] => 297
[111111000000000008] => 297
[111111000000000011] => 297
[111111000000000012] => 297
[111111000000000013] => 297
[111111000000000007] => 297
[111111000000000006] => 297
[111111000000000002] => 297
[111111000000000001] => 297
[111111000000000003] => 297
[111111000000000004] => 297
[111111000000000005] => 297
[111111000000000010] => 297
)
[lizongban] => Array
(
[2] => Array
(
[111111000000000009] => 297
[111111000000000011] => 297
[111111000000000004] => 297
[111111000000000003] => 297
[111111000000000002] => 297
[111111000000000010] => 297
)
[1] => Array
(
[111111000000000008] => 297
[111111000000000007] => 297
[111111000000000006] => 297
[111111000000000005] => 297
[111111000000000001] => 297
)
[3] => Array
(
[111111000000000013] => 297
[111111000000000012] => 297
)
)
[zongfenji] => Array
(
[111111000000000013] => 764
[111111000000000012] => 761
[111111000000000011] => 758
[111111000000000009] => 755
[111111000000000008] => 752
[111111000000000007] => 749
[111111000000000006] => 746
[111111000000000005] => 743
[111111000000000004] => 740
[111111000000000003] => 737
[111111000000000002] => 734
[111111000000000001] => 731
[111111000000000010] => 728
)
[zongfenban] => Array
(
[2] => Array
(
[111111000000000011] => 758
[111111000000000009] => 755
[111111000000000004] => 740
[111111000000000003] => 737
[111111000000000002] => 734
[111111000000000010] => 728
)
[1] => Array
(
[111111000000000008] => 752
[111111000000000007] => 749
[111111000000000006] => 746
[111111000000000005] => 743
[111111000000000001] => 731
)
[3] => Array
(
[111111000000000013] => 764
[111111000000000012] => 761
)
)
)
Salin selepas log masuk
Salin selepas log masuk
导入到数据库，然后用mysql处理
2.同分的帅的往前
建议是存到数据库,然后取出来的时候再计算名次,否则数据库中写死了,以后再在增删改数据的时候,名次还要重新计算.
数据库语句:
<code>SELECT * FROM `成绩表` order by 分数,名次 ASC ,学号 DESC; 分数由小到大,当分数相同 名次有小到大,当名次相同 学号由大到小</code>
Salin selepas log masuk
同理可以通过数据库读出数据进行排名从而进行排名再存入数据库
php:
如果名次不存在,可以读取数据库,在php中计算名次
<code>$arr=array( '0' =>array('gobal' => 8,
'gobal1'=>2
),
'1' =>array('gobal' => 7,
'gobal1'=>6
) ,
'2' =>array('gobal' => 8,
'gobal1'=>6
) ,
'3' =>array('gobal' => 9,
'gobal1'=>8
) ,
'4' =>array('gobal' => 9,
'gobal1'=>9
) ,
);
$arr=array_sort($arr,'gobal');
echo '<pre class="brush:php;toolbar:false">';print_r($arr);
function array_sort($arr,$keys,$type='desc'){
$keysvalue = $new_array = array();
foreach ($arr as $k=>$v){
$keysvalue[$k] = $v[$keys];
}
if($type == 'asc'){
asort($keysvalue);
}else{
arsort($keysvalue);
}
reset($keysvalue);
foreach ($keysvalue as $k=>$v){
$new_array[$k] = $arr[$k];
}
return $new_array;
} </code>Salin selepas log masuk
1- 导入之后再update 2- 并列啊
update table as t1 set 班名次 = (select count() from table as t2 where t1.班级 = t2.班级 and t1.年级 = t2.年级 and t1.成绩 ) from table as t3 where t1.年级 = t3.年级 and t1.成绩
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Alat AI Hot
Undresser.AI Undress
Apl berkuasa AI untuk mencipta foto bogel yang realistik
AI Clothes Remover
Alat AI dalam talian untuk mengeluarkan pakaian daripada foto.
Undress AI Tool
Gambar buka pakaian secara percuma
Clothoff.io
Penyingkiran pakaian AI
AI Hentai Generator
Menjana ai hentai secara percuma.
Artikel Panas
R.E.P.O. Kristal tenaga dijelaskan dan apa yang mereka lakukan (kristal kuning)
4 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Tetapan grafik terbaik
4 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
Assassin's Creed Shadows: Penyelesaian Riddle Seashell
2 minggu yang lalu
By DDD
R.E.P.O. Cara Memperbaiki Audio Jika anda tidak dapat mendengar sesiapa
4 minggu yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: Cara Membuka Segala -galanya Di Myrise
1 bulan yang lalu
By 尊渡假赌尊渡假赌尊渡假赌
Alat panas
Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma
SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan
Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa
Dreamweaver CS6
Alat pembangunan web visual
SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)
Topik panas
Tutorial CakePHP
1378
52
1378
52
Masa Depan PHP: Adaptasi dan Inovasi
Apr 11, 2025 am 12:01 AM
Masa depan PHP akan dicapai dengan menyesuaikan diri dengan trend teknologi baru dan memperkenalkan ciri -ciri inovatif: 1) menyesuaikan diri dengan pengkomputeran awan, kontena dan seni bina microservice, menyokong Docker dan Kubernetes; 2) memperkenalkan pengkompil JIT dan jenis penghitungan untuk meningkatkan prestasi dan kecekapan pemprosesan data; 3) Berterusan mengoptimumkan prestasi dan mempromosikan amalan terbaik.
PHP vs Python: Memahami Perbezaan
Apr 11, 2025 am 12:15 AM
PHP dan Python masing -masing mempunyai kelebihan sendiri, dan pilihannya harus berdasarkan keperluan projek. 1.Php sesuai untuk pembangunan web, dengan sintaks mudah dan kecekapan pelaksanaan yang tinggi. 2. Python sesuai untuk sains data dan pembelajaran mesin, dengan sintaks ringkas dan perpustakaan yang kaya.
Mysql: Konsep mudah untuk pembelajaran mudah
Apr 10, 2025 am 09:29 AM
MySQL adalah sistem pengurusan pangkalan data sumber terbuka. 1) Buat Pangkalan Data dan Jadual: Gunakan perintah Createdatabase dan Createtable. 2) Operasi Asas: Masukkan, Kemas kini, Padam dan Pilih. 3) Operasi lanjutan: Sertai, subquery dan pemprosesan transaksi. 4) Kemahiran Debugging: Semak sintaks, jenis data dan keizinan. 5) Cadangan Pengoptimuman: Gunakan indeks, elakkan pilih* dan gunakan transaksi.
Cara membuka phpmyadmin
Apr 10, 2025 pm 10:51 PM
Anda boleh membuka phpmyadmin melalui langkah -langkah berikut: 1. Log masuk ke panel kawalan laman web; 2. Cari dan klik ikon phpmyadmin; 3. Masukkan kelayakan MySQL; 4. Klik "Login".
MySQL dan SQL: Kemahiran Penting untuk Pemaju
Apr 10, 2025 am 09:30 AM
MySQL dan SQL adalah kemahiran penting untuk pemaju. 1.MYSQL adalah sistem pengurusan pangkalan data sumber terbuka, dan SQL adalah bahasa standard yang digunakan untuk mengurus dan mengendalikan pangkalan data. 2.MYSQL menyokong pelbagai enjin penyimpanan melalui penyimpanan data yang cekap dan fungsi pengambilan semula, dan SQL melengkapkan operasi data yang kompleks melalui pernyataan mudah. 3. Contoh penggunaan termasuk pertanyaan asas dan pertanyaan lanjutan, seperti penapisan dan penyortiran mengikut keadaan. 4. Kesilapan umum termasuk kesilapan sintaks dan isu -isu prestasi, yang boleh dioptimumkan dengan memeriksa penyataan SQL dan menggunakan perintah menjelaskan. 5. Teknik pengoptimuman prestasi termasuk menggunakan indeks, mengelakkan pengimbasan jadual penuh, mengoptimumkan operasi menyertai dan meningkatkan kebolehbacaan kod.
PHP: Adakah ia mati atau hanya menyesuaikan diri?
Apr 11, 2025 am 12:13 AM
PHP tidak mati, tetapi sentiasa menyesuaikan diri dan berkembang. 1) PHP telah menjalani beberapa lelaran versi sejak tahun 1994 untuk menyesuaikan diri dengan trend teknologi baru. 2) Ia kini digunakan secara meluas dalam e-dagang, sistem pengurusan kandungan dan bidang lain. 3) Php8 memperkenalkan pengkompil JIT dan fungsi lain untuk meningkatkan prestasi dan pemodenan. 4) Gunakan OPCACHE dan ikut piawaian PSR-12 untuk mengoptimumkan prestasi dan kualiti kod.
Cara menggunakan redis berulir tunggal
Apr 10, 2025 pm 07:12 PM
Redis menggunakan satu seni bina berulir untuk memberikan prestasi tinggi, kesederhanaan, dan konsistensi. Ia menggunakan I/O multiplexing, gelung acara, I/O yang tidak menyekat, dan memori bersama untuk meningkatkan keserasian, tetapi dengan batasan batasan konkurensi, satu titik kegagalan, dan tidak sesuai untuk beban kerja yang berintensifkan.
PHPMyAdmin Connection MySQL
Apr 10, 2025 pm 10:57 PM
Bagaimana untuk menyambung ke MySQL menggunakan phpmyadmin? URL untuk mengakses phpmyadmin biasanya http: // localhost/phpmyadmin atau http: // [alamat ip pelayan anda]/phpmyadmin. Masukkan nama pengguna dan kata laluan MySQL anda. Pilih pangkalan data yang ingin anda sambungkan. Klik butang "Sambungan" untuk membuat sambungan.
