if (db_check_larare($_SESSION['sendMe']['id'])) { // lärar-view ?> <h2>Att rätta</h2> <?php $sql = "SELECT id, namn FROM kurs WHERE skapad_av='" . $_SESSION['sendMe']['id'] . "' ORDER BY namn"; $q = mysql_query($sql); if (mysql_num_rows($q) > 0) { echo "<table border=1 style='width: 100%'>\n"; while ($r = mysql_fetch_array($q)) { echo "<tr><th colspan='6' style='width: 100%; background-color: #ccc; text-align: left'><strong>" . $r['namn'] . "</strong></th></tr>"; $s = "SELECT * FROM uppgifter WHERE kurs_id='" . $r['id'] . "' AND rattad='0' ORDER BY inlamnad DESC"; $qu = mysql_query($s); while ($row = mysql_fetch_array($qu)) { $file_url = $row['inlamnad'] . "-" . $row['name_orig']; printf("<tr><td><img src='icons/%s.gif' style='width: 20px'/></td><td><a href='showfile.php?file=%s'>%s</a></td><td>%s</td><td>%s</td><td>%s</td><td align='right'><a href='getfile.php?file=%s'><img src='icons/download.gif' title='H�mta' alt='H�mta' style='border: 0; width: 20px' /></a></td></tr>", file_to_icon($row['file_type']), $file_url, $row['name_orig'], db_get_user_name($row['user_id']), show_filesize($row['file_size']), show_date($row['inlamnad']), $file_url); } } echo "</table>\n"; } else { echo "<p>Du har inga kurser upplagda än.</p>"; } ?> <?php } else { // elev-view ?> <h2>Dina inlämnade uppgifter</h2> <h2>Dina rättade uppgifter</h2>
function table_att_ratta($id) { $ret = ""; $id = db_clean($id); $sql = "SELECT id, namn FROM kurs WHERE skapad_av='" . $id . "' AND active='1' ORDER BY namn"; $q = mysql_query($sql); if (mysql_num_rows($q) > 0) { $ret .= "<table border=0 style='width: 100%'>\n"; while ($r = mysql_fetch_array($q)) { $s = "SELECT * FROM uppgifter WHERE kurs_id='" . $r['id'] . "' AND rattad='0' ORDER BY inlamnad DESC"; $qu = mysql_query($s); if (mysql_num_rows($qu) > 0) { $ret .= "<tr><th colspan='6' style='width: 100%; background-color: #ccc; text-align: left'><strong>" . $r['namn'] . "</strong></th></tr>"; while ($row = mysql_fetch_array($qu)) { $file_url = $row['inlamnad'] . "-" . $row['name_orig']; $ret .= sprintf("<tr><td><img src='icons/%s.gif' style='width: 20px'/></td><td><a href='showfile.php?file=%s'>%s</a></td><td>%s</td><td class='right'>%s</td><td class='right'>%s</td><td class='right'><a href='getfile.php?file=%s'><img src='icons/download.gif' title='Hämta' alt='Hämta' style='border: 0; width: 20px' /></a></td></tr>", file_to_icon($row['file_type']), $file_url, $row['name_orig'], db_get_user_name($row['user_id']), show_filesize($row['file_size']), show_date($row['inlamnad']), $file_url); } } } $ret .= "</table>\n"; } else { $ret .= "<p>Du har inga kurser upplagda än.</p>"; } return $ret; }