note 117159 added to function.pg-fetch-assoc
| From: | huntfalow at yahoo dot com | Date: | Thu, 23 Apr 2015 20:46:30 +0000 |
| Subject: | note 117159 added to function.pg-fetch-assoc | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202355@lists.php.net to get a copy of this message | ||
<html>
<head>
<script>
function waarde(){
var text = document.getElementById("optVakken").value;
document.getElementById("txthidden").value = text;
document.forms["hiddenform"].submit();
}
</script>
<?php
// keuzemenu met alle leerkrachten
function leerkrachten($aName){
include("includes/connect.php");
}
// keuzemenu met alle vakken
function vakken($aID){
include("includes/connect.php");
$SelectVakkenQuery = "SELECT * FROM vakken";
$SelectVakkenResult = $mysqli->query($SelectVakkenQuery);
$Choice = "<select id='$aID' onchange=waarde()><option>Kies een
vak</option>";
while($rij2 = $SelectVakkenResult->fetch_assoc()){
$VakID = $rij2['vakid'];
$Vaknaam = $rij2['voluit'];
$Choice .= "<option value='$VakID'>$Vaknaam</option>";
}
$Choice .= "</select>";
return $Choice;
}
?>
<title>Remediëringsoefening</title>
</head>
<body>
<?php
include("includes/connect.php");
// aanmaken van keuzemenus
// eerste keuzemenu
echo vakken("optVakken")."<br><br>";
// tweede keuzemenu
if(!isset($_POST['txthidden'])){
$SelectLeerkrachtenQuery = "SELECT * FROM leerkrachten";
$SelectLeerkrachtResult = $mysqli->query($SelectLeerkrachtenQuery);
$Choice = "<select>";
while($rij=$SelectLeerkrachtResult->fetch_assoc()){
$Voornaam = $rij['voornaam'];
$Naam = $rij['naam'];
$LKID = $rij['leerkrachtid'];
$Volledig = $Voornaam . " " . $Naam;
$Choice .= "<option value='$LKID'>$Volledig</option>";
}
$Choice .= "</select><br><br>";
echo $Choice;
}else{
$vakid = $_POST['txthidden'];
$SelectLeerkrachtenQuery = "SELECT * FROM leerkrachten JOIN leerkrachtpervak ON
leerkrachten.leerkrachtid = leerkrachtpervak.leerkrachtid WHERE vakid = '$vakid'";
$SelectLeerkrachtResult = $mysqli->query($SelectLeerkrachtenQuery);
$Choice = "<select>";
while($row3=$SelectLeerkrachtResult->fetch_assoc()){
$Voornaam = $row3['voornaam'];
$Naam = $row3['naam'];
$Volledig = $Voornaam . " " . $Naam;
$Choice .= "<option>$Volledig</option>";
}
$Choice .= "</select><br><br>";
echo $Choice;
}
// onzichtbaar textbox voor JS
echo "<form method='post' id='hiddenform'><input
type='hidden' name='txthidden' id='txthidden'></form>";
$mysqli->close();
?>
</body>
</html>
----
Server IP: 72.52.91.14
Probable Submitter: 83.134.46.80
----
Manual Page -- http://php.net/manual/en/function.pg-fetch-assoc.php
Edit -- https://master.php.net/note/edit/117159
Del: integrated -- https://master.php.net/note/delete/117159/integrated
Del: useless -- https://master.php.net/note/delete/117159/useless
Del: bad code -- https://master.php.net/note/delete/117159/bad+code
Del: spam -- https://master.php.net/note/delete/117159/spam
Del: non-english -- https://master.php.net/note/delete/117159/non-english
Del: in docs -- https://master.php.net/note/delete/117159/in+docs
Del: other reasons-- https://master.php.net/note/delete/117159
Reject -- https://master.php.net/note/reject/117159
Search -- https://master.php.net/manage/user-notes.php