note 117160 deleted from function.oci-fetch-assoc by peehaa
| From: | peehaa@php.net | Date: | Tue, 28 Apr 2015 09:11:11 +0000 |
| Subject: | note 117160 deleted from function.oci-fetch-assoc by peehaa | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-202389@lists.php.net to get a copy of this message | ||
Note Submitter: test at yahoo dot com
----
<html>
<head>
<?php include("includes/connect.php");?>
<title>Remediëringsoefening</title>
</head>
<body>
<?php
// eerste keuzemenu
$sqlEerste = "SELECT * FROM vakken";
$strResult = $mysqli->query($sqlEerste);
$strAntw1 = "";
while($rij=$strResult->fetch_assoc()){
$strID = $rij['vakid'];
$strVoluit = $rij['voluit'];
$strAntw1 .= "<option value='$strID'>$strVoluit</option>";
}
$strKeuze1 = "<select name='Keuze1'><option value='' disabled
selected style='display:none;'>Kies vak</option>" . "$strAntw1" .
"</select>";
$strForm1 = "<form method='POST'>" . $strKeuze1 . " <input type =
'SUBMIT' value='SUBMIT' name='btnSubmit1'></form>";
echo $strForm1;
// tweede keuzemenu
if(isset($_POST['btnSubmit1'])){
$vakid = $_POST['Keuze1'];
$sqlTweede = "SELECT * FROM leerkrachten JOIN leerkrachtpervak ON leerkrachten.leerkrachtid =
leerkrachtpervak.leerkrachtid WHERE vakid = '$vakid'";
$strResult2 = $mysqli->query($sqlTweede);
$strAntw2 = "";
while($rij2=$strResult2->fetch_assoc()){
$strID2 = $rij2['leerkrachtid'];
$strVoornaam = $rij2['voornaam'];
$strAchternaam = $rij2['naam'];
$strAntw2 .= "<option value='$strID2'>$strVoornaam
$strAchternaam</option>";
}
$strKeuze2 = "<select name='Keuze2'><option value='' disabled
selected style='display:none;'>Kies leerkracht</option>" .
"$strAntw2" . "</select>";
$strForm2 = $strKeuze2;
echo $strForm2;
}
?>
</body>
</html>