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
| <center>
<?php
$title = "Klas";
include("file:///C|/phpdev/www/project_ib5/beheer/html/header.inc");
echo "<br>";
if ($klas_id) {
$result = mysql_query("SELECT * FROM student WHERE klas_id=$klas_id",$db);
while ($myrow = mysql_fetch_array($result))
{
printf("<a href=\"%s?student_id=%s\">%s</a><br>\n", $PHP_SELF, $myrow["student_id"], $myrow["naam"]);
}
}
if ($student_id) {
$result = mysql_query("SELECT * FROM student WHERE student_id=$student_id",$db);
$myrow = mysql_fetch_array($result);
printf("<table bgcolor=000000 cellpadding=1 cellspacing=0><tr><td><table border=0 cellpadding=2 cellspacing=0>");
printf("<tr bgcolor=D7DEE4><td width=100 class=brood>naam:</td><td class=brood>%s</td></tr>", $myrow["naam"]);
printf("<tr bgcolor=FFFFFF><td width=100 class=brood>adres:</td><td class=brood>%s</td></tr>", $myrow["adres"]);
printf("<tr bgcolor=D7DEE4><td width=100 class=brood>postcode:</td><td class=brood>%s</td></tr>", $myrow["postcode"]);
printf("<tr bgcolor=FFFFFF><td width=100 class=brood>woonplaats:</td><td class=brood>%s</td></tr>", $myrow["woonplaats"]);
printf("<tr bgcolor=D7DEE4><td width=100 class=brood>telefoon:</td><td class=brood>%s</td></tr>", $myrow["telefoon"]);
printf("<tr bgcolor=FFFFFF><td width=100 class=brood>email:</td><td class=brood>%s</td></tr>", $myrow["email"]);
printf("<tr bgcolor=D7DEE4><td width=100 class=brood>nationaliteit:</td><td class=brood>%s</td></tr>", $myrow["nationaliteit"]);
printf("<tr bgcolor=FFFFFF><td width=100 class=brood>geboortedatum:</td><td class=brood>%s</td></tr>", $myrow["geboortedatum"]);
printf("<tr bgcolor=D7DEE4><td width=100 class=brood>wachtwoord:</td><td class=brood>%s</td></tr>", $myrow["wachtwoord"]);
printf("</table></td></tr></table>");
$result5 = mysql_query("SELECT * FROM absentie WHERE student_id=$student_id",$db);
$myrow5 = mysql_fetch_array($result5);
printf("<br>");
printf("<table bgcolor=000000 cellpadding=1 cellspacing=0><tr><td><table border=0 cellpadding=2 cellspacing=0>");
printf("<tr bgcolor=D7DEE4><td width=100 class=brood>Week:</td><td width=100 class=brood>Dag:</td><td width=100 class=brood>Lesuur:</td><td width=100 class=brood>Status:</td></tr>");
printf("<tr bgcolor=FFFFFF><td class=brood>%s</td><td class=brood>%s</td><td class=brood>%s</td><td class=brood>%s</td></tr>", $myrow5["week_id"], $myrow5["dag_id"], $myrow5["uur_id"], $myrow5["status"]);
while ($myrow5 = mysql_fetch_array($result5))
{
printf("<tr bgcolor=FFFFFF><td class=brood>%s</td><td class=brood>%s</td><td class=brood>%s</td><td class=brood>%s</td></tr>", $myrow5["week_id"], $myrow5["dag_id"], $myrow5["uur_id"], $myrow5["status"]);
}
printf("</table></td></tr></table>");
} else {
// show employee list
$result = mysql_query("SELECT * FROM klas",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
printf("<hr size=1 color=D7DEE4><p>");
do {
printf("<a href=\"%s?klas_id=%s\">%s</a><br>\n", $PHP_SELF, $myrow["klas_id"], $myrow["klas_naam"]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, geen studenten zijn gevonden!";
}
}
?>
<p>
<a href="<?php echo $PHP_SELF?>" class="brood">terug</a>
</center> |