+++ /dev/null
-<?php
- include 'nav.inc';
- include 'lecture.inc';
-
- if(isset($_POST['submit']) && $_POST['mnumber']!="") {
- require 'createdb.inc';
- require 'session.inc';
-
- $mnumber = trim($_POST['mnumber']);
- $password = trim($_POST['password']);
-
- $sessionid = strtotime(end($sessions)[0]);
-
- if (! ( $mnumber == 007 AND $password == 007 )) {
- require 'usercheck.inc';
- $result = $db->query("SELECT thisdone FROM workdone WHERE mnumber = $mnumber AND session = $sessionid")->fetch(PDO::FETCH_NUM)[0];
- if ($result == "") {
- print "<table bgcolor=\"red\">";
- print "<tr><th><b><font color=\"white\">no submit</font></b></th><tr>";
- print "</table>";
- print "No results were submitted for " . end($sessions)[0] . ".";
- break;
- }
- else {
- print "<table bgcolor=\"lightgreen\">";
- print "<tr><th><b><font color=\"white\">Last submit of $mnumber for " . end($sessions)[0] . "</font></b></th><tr>";
- print "</table>";
- print $result;
- }
- }
- else {
- $result = $db->query("SELECT students.firstname, students.lastname, students.mnumber, workdone.manydone, workdone.thisdone FROM workdone, students WHERE workdone.session = $sessionid AND workdone.mnumber = students.mnumber");
-
- print "<table bgcolor=\"lightgreen\">";
- print "<tr><th><b><font color=\"white\">Last submits for " . end($sessions)[0] . "</font></b></th><tr>";
- print "</table>";
-
- print "<table>";
-
- while ($row = $result->fetch(PDO::FETCH_NUM)) {
- print "<tr>";
- echo "<td>$row[0] $row[1] </td> <td>$row[2] </td> <td>$row[4] </td> <td>$row[3]/$lstsession_nex </td>";
- print "</tr>";
- }
-
- print "</table>";
- }
-
- break;
- }
-?>
-
-<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
- <table bgcolor="black">
- <tr><th><b><font color="white">Last submission</font></b></th><tr>
- </table>
-
- <table>
- <tr>
- <th align="left">Mat.nummer:</th> <th align="left"><input type="text" name="mnumber"></th>
- </tr>
- <tr>
- <th align="left">Password:</th> <th align="left"><input type="text" name="password"></th>
- </tr>
- <tr><th colspan=2></th></tr>
-
- <tr>
- <th align="left"><input type="submit" name="submit" value="Show"></th> <th></th>
- </tr>
- </table>
-</form>