-
Notifications
You must be signed in to change notification settings - Fork 0
/
viewCourseData.php
128 lines (108 loc) · 4.47 KB
/
viewCourseData.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?
session_start();
include_once("connect.php");
include_once("heading.php");?>
<html>
<body>
<?
$q2=mysql_query("SELECT * FROM lecturer WHERE userName='".mysql_real_escape_string($_SESSION['user']['userName'])."'");
$row=mysql_fetch_array($q2);
$_SESSION['user']['course']=$row["course"];
echo "<br>";
echo $_SESSION['user']['course'];
//In course 1 assignmnet 1 being inserted to `course1` table
if($_SESSION['user']['course']=="Course1" or ($_SESSION['user']['level']==1) ){
$result=mysql_query("SELECT DISTINCT st_index FROM courses WHERE course_no='Course1'");
while($index=mysql_fetch_array($result)){
echo"<br>";
$result2=mysql_query("SELECT * FROM courses WHERE course_no='Course1' AND st_index='$index[0]'") ;
while($i2=mysql_fetch_array($result2)){
$ass_no=$i2['assignment_no'];
if($ass_no=='1'){
$result3=mysql_query("INSERT INTO course1(Student_Index,Assignment1) VALUES('$index[0]','$i2[marks]')");
}
if($ass_no=='2'){
$result4=mysql_query("UPDATE course1 SET Assignment2=$i2[marks] WHERE Student_Index='$index[0]'");
}
if($ass_no=='3'){
$result4=mysql_query("UPDATE course1 SET Assignment3=$i2[marks] WHERE Student_Index='$index[0]'");
}
if($ass_no=='4'){
$result4=mysql_query("UPDATE course1 SET Assignment4=$i2[marks] WHERE Student_Index='$index[0]'");
}
if($ass_no=='5'){
$result4=mysql_query("UPDATE course1 SET Assignment5=$i2[marks] WHERE Student_Index='$index[0]'");
}
}
}
if($_SESSION['user']['course']=="Course1"){
$sql="SELECT Student_Index,Assignment1,Assignment2,Assignment3,Assignment4,Assignment5,weighted_average,grade FROM weighted_course1";
$result=mysql_query($sql,$connect);
?><div class=course><?
echo "<table>";
$num_of_rows=mysql_num_rows($result);
for($k=0;$k<mysql_num_fields($result);$k++){
echo "<th>";
echo mysql_field_name($result,$k);
echo "</th>";
}
while($r=mysql_fetch_assoc($result)){
echo "<tr>";
echo "<td>".$r["Student_Index"]."</td><td>".$r["Assignment1"]."</td><td>".$r["Assignment2"]."</td><td>".$r["Assignment3"]."</td><td>".$r["Assignment4"]."</td><td>".$r["Assignment5"]."</td><td>".$r["weighted_average"]."</td><td>".$r["grade"]."</td>";
echo "</tr>";
}
echo "</table>";
?></div><?
}
}
if($_SESSION['user']['course']=="Course2" or ($_SESSION['user']['level']==1)){
$result=mysql_query("SELECT DISTINCT st_index FROM courses WHERE course_no='Course2'");
while($index=mysql_fetch_array($result)){
echo"<br>";
$result2=mysql_query("SELECT * FROM courses WHERE course_no='Course2' AND st_index='$index[0]'");
while($i2=mysql_fetch_array($result2)){
$ass_no=$i2['assignment_no'];
if($ass_no=='1'){
$result3=mysql_query("INSERT INTO course2(Student_Index,Assignment1) VALUES('$index[0]','$i2[marks]')");
}
if($ass_no=='2'){
$result4=mysql_query("UPDATE course2 SET Assignment2=$i2[marks] WHERE Student_Index='$index[0]'");
}
if($ass_no=='3'){
$result4=mysql_query("UPDATE course2 SET Assignment3=$i2[marks] WHERE Student_Index='$index[0]'");
}
if($ass_no=='4'){
$result4=mysql_query("UPDATE course2 SET Assignment4=$i2[marks] WHERE Student_Index='$index[0]'");
}
if($ass_no=='5'){
$result4=mysql_query("UPDATE course2 SET Assignment5=$i2[marks] WHERE Student_Index='$index[0]'");
}
}
}
if($_SESSION['user']['course']=="Course2"){
$sql="SELECT Student_Index,Assignment1,Assignment2,Assignment3,Assignment4,Assignment5,weighted_average,grade FROM weighted_course2";
$result=mysql_query($sql,$connect);
?>
<div class=course><?
echo "<table>";
$num_of_rows=mysql_num_rows($result);
for($k=0;$k<mysql_num_fields($result);$k++){
echo "<th>";
echo mysql_field_name($result,$k);
echo "</th>";
}
while($r=mysql_fetch_assoc($result)){
echo "<tr>";
echo "<td>".$r["Student_Index"]."</td><td>".$r["Assignment1"]."</td><td>".$r["Assignment2"]."</td><td>".$r["Assignment3"]."</td><td>".$r["Assignment4"]."</td><td>".$r["Assignment5"]."</td><td>".$r["weighted_average"]."</td><td>".$r["grade"]."</td>";
echo "</tr>";
}
echo "</table>";
?></div><?
}
}
if($_SESSION['user']['level']==1){
echo "Export table 'course1','course2' as CSV files with field names";
}
?>
</body>
</html>