· 6 years ago · Mar 06, 2019, 03:04 AM
1<?php
2require_once "scripts/connect_to_mysql.php";
3$sq = mysql_query("SELECT DISTINCT course_code FROM tbl_result_400");
4//$r = mysql_fetch_assoc($sq);
5$k = 1;
6echo "<table border = 1 bgcolor = 'white' class='member_tableheader'><tr>";
7 echo "<td width = '50px' align='left' valign='top'>COURSES<BR>UNITS</td>";
8 while ($r = mysql_fetch_assoc($sq)){
9 $v=$r['course_code'];
10 $sq1 = mysql_query("SELECT course_unit FROM tbl_result_400 WHERE course_code = '$v'");
11 $rr = mysql_fetch_assoc($sq1);//$v = "sup";
12 echo "<td width = '100px' align='center' valign='top'>".$r['course_code']."<BR>"."(".$rr['course_unit'].")"."<BR>"."</td>";
13 ++$k;
14 }
15 echo "</tr>";
16
17 echo "<tr>";
18 $sq2 = mysql_query("SELECT DISTINCT matric_no FROM tbl_registered_courses_400 ORDER BY matric_no");
19 $rrr = mysql_fetch_assoc($sq2);
20
21 do{
22 $vv = $rrr['matric_no']; $t = 1;
23 $sq4 = mysql_query("SELECT * FROM tbl_result_400 where matric_no = '$vv'");
24 $n = mysql_num_rows($sq4);
25 $sq3 = mysql_query("SELECT score FROM tbl_result_400 where matric_no = '$vv'");
26
27 echo "<td width = '100px' align='center' valign='top'>".$vv."</td>";
28 while($rs = mysql_fetch_assoc($sq3)){
29 if($t <= $n){
30 if(empty($rs['score'])){
31 $emptyScore = " --- ";
32 echo "<td width = '100px' align='center' valign='top'>".$emptyScore."</td>";
33 }else{
34 echo "<td width = '100px' align='center' valign='top'>".$rs['score']."</td>";
35 }
36 };
37 if($t == $n ){echo "<tr>";}
38 /*if($t > $n){
39 echo "<td width = '100px' align='center'
40valign='top'>".$rs['score']."</td>";
41 }*/
42 ++$t;
43 }
44 }while($rrr = mysql_fetch_assoc($sq2));
45 echo "</tr>";
46 echo "</tr>";
47echo "</table>";
48?>
49
50--
51 -- Table structure for table `tbl_registered_courses_400`
52 --
53
54 CREATE TABLE IF NOT EXISTS `tbl_registered_courses_400` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `matric_no` varchar(15) NOT NULL,
57 `course_code` varchar(15) NOT NULL,
58 `course_unit` varchar(15) NOT NULL,
59 `semester_registered` varchar(6) NOT NULL,
60 `session_registered` varchar(15) NOT NULL,
61 PRIMARY KEY (`id`)
62 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
63
64 --
65 -- Dumping data for table `tbl_registered_courses_400`
66 --
67
68 INSERT INTO `tbl_registered_courses_400` (`id`, `matric_no`, `course_code`, `course_unit`, `semester_registered`, `session_registered`) VALUES
69 (1, '03/55ec101', 'CSC 402', '6', '1', '2015/2016'),
70 (2, '03/55ec101', 'CSC 499', '3', '1', '2015/2016'),
71 (3, '03/55ec101', 'CHM 401', '3', '1', '2015/2016'),
72 (4, '03/55ec101', 'CSC 470', '2', '1', '2015/2016'),
73 (5, '03/55ec101', 'CSC 414', '3', '1', '2015/2016'),
74 (6, '03/55ec101', 'CSC 411', '2', '1', '2015/2016'),
75 (7, '03/55ec101', 'CSC 403', '3', '1', '2015/2016'),
76 (8, '03/55ec101', 'BLY 401', '2', '1', '2015/2016'),
77 (9, '03/55ec101', 'PHY 152', '3', '1', '2015/2016'),
78 (10, '06/55ec101', 'CSC 402', '6', '1', '2015/2016'),
79 (11, '06/55ec101', 'CSC 499', '3', '1', '2015/2016'),
80 (12, '06/55ec101', 'CHM 401', '3', '1', '2015/2016'),
81 (13, '06/55ec101', 'CSC 470', '2', '1', '2015/2016'),
82 (14, '06/55ec101', 'CSC 414', '3', '1', '2015/2016'),
83 (15, '06/55ec101', 'CSC 411', '2', '1', '2015/2016'),
84 (16, '06/55ec101', 'CSC 403', '3', '1', '2015/2016'),
85 (17, '06/55ec101', 'BLY 401', '2', '1', '2015/2016'),
86 (18, '06/55ec101', 'PHY 152', '3', '1', '2015/2016');
87
88--
89 -- Table structure for table `tbl_result_400`
90 --
91
92 CREATE TABLE IF NOT EXISTS `tbl_result_400` (
93 `id` int(11) NOT NULL AUTO_INCREMENT,
94 `department_id` int(11) NOT NULL,
95 `matric_no` varchar(15) NOT NULL,
96 `session` varchar(15) NOT NULL,
97 `semester` varchar(15) NOT NULL,
98 `level` varchar(10) NOT NULL,
99 `course_code` varchar(10) NOT NULL,
100 `course_unit` varchar(10) NOT NULL,
101 `ca` varchar(4) NOT NULL,
102 `exam` varchar(4) NOT NULL,
103 `score` varchar(10) NOT NULL,
104 `grade` varchar(2) NOT NULL,
105 PRIMARY KEY (`id`)
106 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
107
108 --
109 -- Dumping data for table `tbl_result_400`
110 --
111
112 INSERT INTO `tbl_result_400` (`id`, `department_id`, `matric_no`, `session`, `semester`, `level`, `course_code`, `course_unit`, `ca`, `exam`, `score`, `grade`) VALUES
113 (1, 2, '03/55EC101', '2015/2016', '1', '400', 'CSC 499', '3', '', '', '51', ''),
114 (2, 2, '06/55EJ101', '2015/2016', '1', '400', 'CSC 499', '3', '', '', '69', ''),
115 (3, 2, '06/55EJ102', '2015/2016', '1', '400', 'CSC 499', '3', '', '', '60', ''),
116 (4, 2, '06/55EJ103', '2015/2016', '1', '400', 'CSC 499', '3', '', '', '54', ''),
117 (5, 2, '06/55EJ104', '2015/2016', '1', '400', 'CSC 499', '3', '', '', '73', ''),
118 (6, 2, '03/55EC101', '2015/2016', '1', '400', 'CSC 470', '3', '', '', '72', ''),
119 (7, 2, '06/55EJ101', '2015/2016', '1', '400', 'CSC 470', '3', '', '', '68', ''),
120 (8, 2, '06/55EJ102', '2015/2016', '1', '400', 'CSC 470', '3', '', '', '87', ''),
121 (9, 2, '06/55EJ103', '2015/2016', '1', '400', 'CSC 470', '3', '', '', '53', ''),
122 (10, 2, '06/55EJ104', '2015/2016', '1', '400', 'CSC 470', '3', '', '', '45', ''),
123 (11, 2, '03/55EC101', '2015/2016', '1', '400', 'CSC 414', '2', '', '', '55', ''),
124 (12, 2, '06/55EJ101', '2015/2016', '1', '400', 'CSC 414', '2', '', '', '65', ''),
125 (13, 2, '06/55EJ102', '2015/2016', '1', '400', 'CSC 414', '2', '', '', '76', ''),
126 (14, 2, '06/55EJ103', '2015/2016', '1', '400', 'CSC 414', '2', '', '', '59', ''),
127 (15, 2, '06/55EJ104', '2015/2016', '1', '400', 'CSC 414', '2', '', '', '77', ''),
128 (16, 2, '03/55EC101', '2015/2016', '1', '400', 'CSC 411', '2', '', '', '56', ''),
129 (17, 2, '06/55EJ101', '2015/2016', '1', '400', 'CSC 411', '2', '', '', '65', ''),
130 (18, 2, '06/55EJ102', '2015/2016', '1', '400', 'CSC 411', '2', '', '', '66', ''),
131 (19, 2, '06/55EJ103', '2015/2016', '1', '400', 'CSC 411', '2', '', '', '76', ''),
132 (20, 2, '06/55EJ104', '2015/2016', '1', '400', 'CSC 411', '2', '', '', '67', ''),
133 (21, 2, '03/55EC101', '2015/2016', '1', '400', 'CSC 403', '3', '', '', '66', ''),
134 (22, 2, '06/55EJ101', '2015/2016', '1', '400', 'CSC 403', '3', '', '', '65', ''),
135 (23, 2, '06/55EJ102', '2015/2016', '1', '400', 'CSC 403', '3', '', '', '68', ''),
136 (24, 2, '06/55EJ103', '2015/2016', '1', '400', 'CSC 403', '3', '', '', '79', ''),
137 (25, 2, '06/55EJ104', '2015/2016', '1', '400', 'CSC 403', '3', '', '', '90', ''),
138 (26, 2, '03/55EC101', '2015/2016', '1', '400', 'CSC 402', '4', '', '', '65', ''),
139 (27, 2, '06/55EJ101', '2015/2016', '1', '400', 'CSC 402', '4', '', '', '72', ''),
140 (28, 2, '06/55EJ102', '2015/2016', '1', '400', 'CSC 402', '4', '', '', '48', ''),
141 (29, 2, '06/55EJ103', '2015/2016', '1', '400', 'CSC 402', '4', '', '', '80', ''),
142 (30, 2, '06/55EJ104', '2015/2016', '1', '400', 'CSC 402', '4', '', '', '69', ''),
143 (31, 2, '03/55EC101', '2015/2016', '2', '400', 'CSC 498', '6', '', '', '61', ''),
144 (32, 2, '06/55EJ101', '2015/2016', '2', '400', 'CSC 498', '6', '', '', '55', ''),
145 (33, 2, '06/55EJ102', '2015/2016', '2', '400', 'CSC 498', '6', '', '', '59', ''),
146 (34, 2, '06/55EJ103', '2015/2016', '2', '400', 'CSC 498', '6', '', '', '52', ''),
147 (35, 2, '06/55EJ104', '2015/2016', '2', '400', 'CSC 498', '6', '', '', '60', ''),
148 (36, 2, '03/55EC101', '2015/2016', '2', '400', 'CSC 419', '4', '', '', '72', ''),
149 (37, 2, '06/55EJ101', '2015/2016', '2', '400', 'CSC 419', '4', '', '', '62', ''),
150 (38, 2, '06/55EJ102', '2015/2016', '2', '400', 'CSC 419', '4', '', '', '45', ''),
151 (39, 2, '06/55EJ103', '2015/2016', '2', '400', 'CSC 419', '4', '', '', '37', ''),
152 (40, 2, '06/55EJ104', '2015/2016', '2', '400', 'CSC 419', '4', '', '', '50', ''),
153 (41, 2, '03/55EC101', '2015/2016', '2', '400', 'MAT 412', '3', '', '', '56', ''),
154 (42, 2, '06/55EJ101', '2015/2016', '2', '400', 'MAT 412', '3', '', '', '45', ''),
155 (43, 2, '06/55EJ102', '2015/2016', '2', '400', 'MAT 412', '3', '', '', '46', ''),
156 (44, 2, '06/55EJ103', '2015/2016', '2', '400', 'MAT 412', '3', '', '', '57', ''),
157 (45, 2, '06/55EJ104', '2015/2016', '2', '400', 'MAT 412', '3', '', '', '67', ''),
158 (46, 2, '03/55EC101', '2015/2016', '2', '400', 'CSC 412', '3', '', '', '67', ''),
159 (47, 2, '06/55EJ101', '2015/2016', '2', '400', 'CSC 412', '3', '', '', '55', ''),
160 (48, 2, '06/55EJ102', '2015/2016', '2', '400', 'CSC 412', '3', '', '', '60', ''),
161 (49, 2, '06/55EJ103', '2015/2016', '2', '400', 'CSC 412', '3', '', '', '69', ''),
162 (50, 2, '06/55EJ104', '2015/2016', '2', '400', 'CSC 412', '3', '', '', '59', ''),
163 (51, 0, '06/55EC101', '2015/2016', '1', '400', 'PHY 152', '3', '20', '58', '78', 'A');
164
165<?php
166
167 $db = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'root', '');
168 $stmt = $db->query("SELECT DISTINCT course_code FROM tbl_result_400");
169
170 $k = 1;
171 echo "<table border = 1 bgcolor = 'white' class='member_tableheader'><tr>n";
172 echo "<td width = '50px' align='left' valign='top'>COURSES<BR>UNITS</td>n";
173 $coursesArray = array();
174 while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
175 $v = $row['course_code'];
176 $stmt2 = $db->query("SELECT course_unit FROM tbl_result_400 WHERE course_code = '$v'");
177 $rr = $stmt2->fetch(PDO::FETCH_ASSOC);
178 echo "<td width = '100px' align='center' valign='top'>".$row['course_code']."<BR>"."(".$rr['course_unit'].")"."<BR>"."</td>n";
179 $k++;
180 $coursesArray[$k] = $row['course_code'];
181 }
182
183 $flipArray = array_flip($coursesArray);
184 $createEmpty = array();
185 foreach($flipArray as $num => $value){
186 $createEmpty[$num] = 0;
187 }
188
189 echo "</tr><tr>";
190 $stmta = $db->query("SELECT DISTINCT matric_no FROM tbl_registered_courses_400 ORDER BY matric_no");
191
192 $z = 0;
193 $newDisplay = array();
194 while( $row = $stmta->fetch(PDO::FETCH_ASSOC)) {
195 $vv = $row['matric_no'];
196 $t = 1;
197 $stmt = $db->query("SELECT * FROM tbl_result_400 where matric_no = '$vv'");
198 $n = $stmt->rowCount();
199 echo "<td width = '100px' align='center' valign='top'>".$vv."a</td>n";
200
201
202 $newDisplay[$z] = $createEmpty;
203
204 while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
205 foreach($coursesArray as $num => $name){
206 if($row['course_code'] == $name){
207 $newDisplay[$z][$name] = $row['score'];
208 }
209 }
210 }
211
212
213 foreach($newDisplay[$z] as $num => $value){
214 if($value){
215 echo "<td width = '100px' align='center' valign='top'>".$value."</td>n";
216 } else {
217 echo "<td width = '100px' align='center' valign='top'> --- </td>n";
218 }
219 }
220
221 echo "</tr><tr>";
222
223
224 $z++;
225
226 }
227 echo "</tr>";
228 echo "</table>";
229
230?>