query("SELECT COUNT(*) FROM students WHERE mnumber=" . trim($_GET['mnumber']) . " AND lastblackboard=" . trim($_GET['tstamp']))->fetch(PDO::FETCH_NUM)[0] == 0) { if( $_GET['sign'] == 0 ) { $db->query("UPDATE students SET blackboard=blackboard+1, lastblackboard=" . $_GET['tstamp'] . " WHERE mnumber=" . trim($_GET['mnumber'])); } else { $db->query("UPDATE students SET blackboard=blackboard-1, lastblackboard=" . $_GET['tstamp'] . " WHERE mnumber=" . trim($_GET['mnumber'])); } } if ($db->query("SELECT COUNT(*) FROM students")->fetch(PDO::FETCH_NUM)[0] == 0) { block("red", "no students registered"); exit; } ?> query("SELECT firstname, lastname, mnumber, blackboard FROM students ORDER BY LOWER(lastname)"); print ""; while ($student = $result->fetch(PDO::FETCH_ASSOC)) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } print "

" . $student['firstname'] . "

" . $student['lastname'] . "

" . $student['mnumber'] . "

" . $student['blackboard'] . "

" . "+1" . "

" . "-1" . "

"; ?>