note 117442 added to function.pg-fetch-assoc
| From: | php12345 at hotmail dot com | Date: | Wed, 10 Jun 2015 21:14:18 +0000 |
| Subject: | note 117442 added to function.pg-fetch-assoc | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202820@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 = "";
//overlopen tabel en aanmaken option
while($rij=$strResult->fetch_assoc()){
$strID = $rij['vakid'];
$strVoluit = $rij['voluit'];
$strAntw1 .= "<option value='$strID'>$strVoluit</option>";
}
//select aanmaken, options toevoegen en in een form steken
$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
//Enkel als eerste geset is
if(isset($_POST['btnSubmit1'])){
//vakid nodig voor JOIN
$vakid = $_POST['Keuze1'];
//Alle leerkrachten die het vak geven die in keuze1 geselecteerd is selecteren
$sqlTweede = "SELECT * FROM leerkrachten JOIN leerkrachtpervak ON leerkrachten.leerkrachtid =
leerkrachtpervak.leerkrachtid WHERE vakid = '$vakid'";
$strResult2 = $mysqli->query($sqlTweede);
$strAntw2 = "";
//Overlopen tabel en aanmaken option
while($rij2=$strResult2->fetch_assoc()){
$strID2 = $rij2['leerkrachtid'];
$strVoornaam = $rij2['voornaam'];
$strAchternaam = $rij2['naam'];
$strAntw2 .= "<option value='$strID2'>$strVoornaam
$strAchternaam</option>";
}
//select aanmaken, options toevoegen en in een form steken
$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: 78.20.148.32
----
Manual Page -- http://php.net/manual/en/function.pg-fetch-assoc.php
Edit -- https://master.php.net/note/edit/117442
Del: integrated -- https://master.php.net/note/delete/117442/integrated
Del: useless -- https://master.php.net/note/delete/117442/useless
Del: bad code -- https://master.php.net/note/delete/117442/bad+code
Del: spam -- https://master.php.net/note/delete/117442/spam
Del: non-english -- https://master.php.net/note/delete/117442/non-english
Del: in docs -- https://master.php.net/note/delete/117442/in+docs
Del: other reasons-- https://master.php.net/note/delete/117442
Reject -- https://master.php.net/note/reject/117442
Search -- https://master.php.net/manage/user-notes.php