note 117160 added to function.oci-fetch-assoc
| From: | test at yahoo dot com | Date: | Thu, 23 Apr 2015 20:51:54 +0000 |
| Subject: | note 117160 added to function.oci-fetch-assoc | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202356@lists.php.net to get a copy of this message | ||
<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>
----
Server IP: 72.52.91.14
Probable Submitter: 83.134.46.80
----
Manual Page -- http://php.net/manual/en/function.oci-fetch-assoc.php
Edit -- https://master.php.net/note/edit/117160
Del: integrated -- https://master.php.net/note/delete/117160/integrated
Del: useless -- https://master.php.net/note/delete/117160/useless
Del: bad code -- https://master.php.net/note/delete/117160/bad+code
Del: spam -- https://master.php.net/note/delete/117160/spam
Del: non-english -- https://master.php.net/note/delete/117160/non-english
Del: in docs -- https://master.php.net/note/delete/117160/in+docs
Del: other reasons-- https://master.php.net/note/delete/117160
Reject -- https://master.php.net/note/reject/117160
Search -- https://master.php.net/manage/user-notes.php