note 117447 added to control-structures.while
| From: | tuurke14 at hotmail dot com | Date: | Thu, 11 Jun 2015 05:48:04 +0000 |
| Subject: | note 117447 added to control-structures.while | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202828@lists.php.net to get a copy of this message | ||
UNIT
<HTML>
<HEAD>
</HEAD>
<?php
//CONNECT
include("includes/connect.php");
//SELECT//Eerste Keuze menu
$sqlEerste = "SELECT * FROM vakken";
$strResult = $mysqli->query($sqlEerste);
while($rij=$strResult->fetch_assoc()){
$strID = $rij['vakid'];
$strVoluit = $rij['voluit'];
$strAntw1 .="<option
value='$strID'>$strVoluit</option>";//overloopt alle klasids en per klasid
pakt hij de voluit waarde er bij
}
$strKeuze1 ="<select name='Keuze1'>option value=''>Kies een
vak</option>"."$strAntw1"."</select>";//Dit is voor de
keuzelijst
$strForm1 ="<form method='POST'>".$strKeuze1."<input type =
'submit' value='submit'></form>";
//TWEEDE KEUZE MENU
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);
//overlopen tabel
while($rij2=$strResult1->fetch_assoc()){
$strId2 = $rij2['leerkrachtid'];
$strVoornaam = $rij2['voornaam'];
$strAchternaam = $rij2['naam'];
$strAntw2 .="<option value='$strID2'<$strVoornaam
$strAchternaam</option>";
}
$strKeuze2 = "<select name='keuze2'><option value=''>kies een
leerkracht</option>".$strAntw2."</select>";
echo $strForm2
----
Server IP: 72.52.91.14
Probable Submitter: 91.180.154.238
----
Manual Page -- http://php.net/manual/en/control-structures.while.php
Edit -- https://master.php.net/note/edit/117447
Del: integrated -- https://master.php.net/note/delete/117447/integrated
Del: useless -- https://master.php.net/note/delete/117447/useless
Del: bad code -- https://master.php.net/note/delete/117447/bad+code
Del: spam -- https://master.php.net/note/delete/117447/spam
Del: non-english -- https://master.php.net/note/delete/117447/non-english
Del: in docs -- https://master.php.net/note/delete/117447/in+docs
Del: other reasons-- https://master.php.net/note/delete/117447
Reject -- https://master.php.net/note/reject/117447
Search -- https://master.php.net/manage/user-notes.php