...

[banana.git] / admin / blackboard.php

diff --git a/admin/blackboard.php b/admin/blackboard.php
new file mode 100644 (file)
index 0000000..b683221
--- /dev/null
+++ b/admin/blackboard.php
@@ -0,0 +1,39 @@
+<?php
+  require 'include/head.inc';
+  require 'include/db.inc';
+  require 'include/common.inc';
+  
+  if(isset($_POST['submit']) && $_POST['mnumber']!="") {
+    $db->query("UPDATE students SET blackboard=blackboard+1 WHERE mnumber=" . trim($_POST['mnumber']));
+    block("lightgreen", "added blackboard");
+  }
+
+  block("black", "add blackboard");
+?>
+
+<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
+  <table>
+    <tr>  
+      <th align="left">Matr.nummer:</th> <th><input type="text" name="mnumber"></th>
+      <th><input type="submit" name="submit" value="Add"></th>
+    </tr>
+  </table>
+</form>
+
+<?php
+  block("black", "blackboard overview");
+
+  $result=$db->query("SELECT firstname, lastname, mnumber, blackboard FROM students");
+
+  print "<table>";
+  while ($student = $result->fetch(PDO::FETCH_ASSOC)) {
+    print "<tr>";
+    print "<td>" . $student['firstname'] . "&nbsp;</td>";
+    print "<td>" . $student['lastname'] . "&nbsp;&nbsp;</td>";
+    print "<td>" . $student['mnumber'] . "&nbsp;&nbsp;</td>";
+    print "<td>" . $student['blackboard'] . "</td>";
+    print "</tr>";
+  }
+  print "</table>";
+     
+?>
\ No newline at end of file