Nicketick

Untitled

Feb 27th, 2012
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.47 KB | None | 0 0
  1. <form enctype='multipart/form-data' method="post" name="koe" action="index.php?p=stap3"><table width="100%" style="text-align: left;">
  2. <tr><th style="width: 7%">Selectie</th><th style="width: 10%">Docent</th><th style="width: 10%">Vak</th><th style="width: 75%">Opmerkingen</th></tr>
  3. <?
  4. include("config.inc.php");
  5. $stromingvar = $_GET['stroming'];
  6. $result = mysql_query( "SELECT id, docent, vak, lokaal, datum, richting, opmerkingen FROM toetsrooster WHERE richting=$stromingvar" );
  7. while( $row = mysql_fetch_array( $result ) )
  8.     {
  9.     $docenttoe = mysql_query("SELECT * FROM docent WHERE docent_id='".$row[1]."' ");
  10. while($doc = mysql_fetch_assoc($docenttoe))
  11. {
  12. $docentval = $doc[docent_naam];
  13. }
  14. $vaktoe = mysql_query("SELECT * FROM vak WHERE vak_id='".$row[2]."' ");
  15. while($vakm = mysql_fetch_assoc($vaktoe))
  16. {
  17. $vakval = $vakm[vak_naam];
  18. }
  19. $lokaaltoe = mysql_query("SELECT * FROM lokaal WHERE lokaal_id='".$row[3]."' ");
  20. while($lokm = mysql_fetch_assoc($lokaaltoe))
  21. {
  22. $lokval = $lokm[lokaal_naam];
  23. }
  24. $richtingtoe = mysql_query("SELECT * FROM stroming WHERE stroming_id='".$row[5]."' ");
  25. while($ricm = mysql_fetch_assoc($richtingtoe))
  26. {
  27. $ricval = $ricm[stroming_naam];
  28. }
  29. $toetsen .=<<<__HTML_END
  30.  
  31.     <tr><td><input name="selector[]" id="hoi" type="checkbox" value="$row[0]"/></td><td>$docentval</td><td>$vakval</td><td>$row[6]</td></tr>\n
  32. __HTML_END;
  33.     }
  34.     mysql_free_result( $result );
  35.     echo($toetsen);
  36.  
  37. ?>
  38.  
  39. </table>
  40. <input name="volgende" type="submit" class="buttonbeheer" value="Laat mijn rooster zien">
  41. </form>
Advertisement
Add Comment
Please, Sign In to add comment