query("SELECT COUNT(*) FROM workdone WHERE mnumber=$up_mnumber AND session=$up_sessionid AND tstamp=$up_tstamp")->fetch(PDO::FETCH_NUM)[0] == 0 ) { $db->query("UPDATE workdone SET thisdone='$up_editsub', manydone=" . count(explode(",",$up_editsub)) . ",tstamp=$up_tstamp WHERE mnumber=$up_mnumber AND session=$up_sessionid"); block("lightgreen", "modified submit"); } } print "

"; print ""; foreach($SESSIONS as $session) { $note = ""; if( $session['id'] == $SESSIONS_actual ) { $note = "(next)"; } if( $session['id'] == $SESSIONS_last ) { $note = "(last)"; } if( $showsession != $session['id'] ) { print "" . $session['timestr'] . " " . $note . ""; } else { print "" . $session['timestr'] . " " . $note . ""; } } print ""; print "

"; block("black", "summary for session " . $SESSIONS[$showsession]['timestr'] . " (" . $SESSIONS[$showsession]['examples'] . ")"); $result = $db->query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY LOWER(lastname)"); print ""; print ""; if( $showsession == $SESSIONS_actual ) { print ""; } else { print ""; } while ($student = $result->fetch(PDO::FETCH_ASSOC)) { $result2 = $db->query("SELECT manydone, thisdone FROM workdone WHERE mnumber=" . $student['mnumber'] . " AND session=" . $showsession)->fetch(PDO::FETCH_NUM); $exdone = $result2[0]; if ($exdone == "") { $exdone=0; } $thisdone = $result2[1]; print ""; print ""; print ""; print ""; print ""; if( $showsession != $SESSIONS_actual ) { print ""; } else { print ""; } print ""; } print "

First name	Last name	Matr.nummer	Examples	Blackboard	Modify
" . $student['firstname'] . "	" . $student['lastname'] . "	" . $student['mnumber'] . "	" . $thisdone . " (" . $exdone . "/" . $SESSIONS[$showsession]['nexamples'] . ")	"; if( isset($_GET['sessionselected']) ) { print ""; } print ""; print ""; print ""; print ""; print "	" . $student['blackboard'] . "

"; ?>