X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/4678f209fb04682d0981cadb566d63f5726f9e09..8db41c98817b1b48532dc3cebf4bea166e42bb70:/admin/summary.php diff --git a/admin/summary.php b/admin/summary.php new file mode 100644 index 0000000..345f5a0 --- /dev/null +++ b/admin/summary.php @@ -0,0 +1,27 @@ +query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY lastname"); + + print "
First name | Last name | Matr.nummer | Examples | Blackboard | "; + while ($student = $result->fetch(PDO::FETCH_ASSOC)) { + $exdone = $db->query("SELECT manydone FROM workdone WHERE mnumber=" . $student['mnumber'])->fetch(PDO::FETCH_NUM); + $totexdone = 0; + foreach($exdone as $subdone) { $totexdone += $subdone; } + print "
" . $student['firstname'] . " | "; + print "" . $student['lastname'] . " | "; + print "" . $student['mnumber'] . " | "; + print "" . $totexdone . "/" . $SESSIONS_totex . " | "; + print "" . $student['blackboard'] . " | "; + print "