l104/H15/15.6.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <style> table, th, td { padding: 5px; } table, th { padding: 5px; } table { padding: 5px; } </style> </head> <body> <?php include('../db.php'); $witregel=false; if(!isset($_POST['nieuwleerling'])){ if (isset($_POST['leerling'])){ if($_POST['leerling'] != ''){ $leerling=$_POST['leerling']; $query = "select * from leerlingen where llnr = $leerling"; $result = mysqli_query($db, $query) or die(mysqli_error($db)); $row = mysqli_fetch_array($result); echo "<table>"; echo "<tr>"; echo "<th>Leerlingnummer</th>"; echo "<th>voornaam</th>"; echo "<th>Tussenvoegsel</th>"; echo "<th>Achternaam</th>"; echo "<th>Straat</th>"; echo "<th>Huisnummer</th>"; echo "<th>Postcode</th>"; echo "<th>Plaats</th>"; echo "<th>Telefoon</th>"; echo "<th>Geslacht</th>"; echo "<th>Geboortedatum</th>"; echo "<th>Klas</th>"; echo "</tr>"; echo "<tr>"; echo "<td>$row[llnr]</td>"; echo "<td>$row[voornaam]</td>"; echo "<td>$row[tussenvoegsel]</td>"; echo "<td>$row[achternaam]</td>"; echo "<td>$row[straat]</td>"; echo "<td>$row[huisnummer]</td>"; echo "<td>$row[postcode]</td>"; echo "<td>$row[plaats]</td>"; echo "<td>$row[telefoon]</td>"; echo "<td>$row[geslacht]</td>"; echo "<td>$row[geb_datum]</td>"; echo "<td>$row[klas]</td>"; echo "<td><form name='gegevens' action='' method='post'><input type='submit' name='gegevens' value='Wijzigen'><input type='hidden' value=$_POST[leerling] name='lnr'></form></td>"; echo "</tr>"; echo "</table>"; $witregel=true; } } if (isset($_POST['gegevens'])||isset($_POST['submit'])){ if (isset($_POST['gegevens'])){ $llnr=$_POST['lnr']; $query = "select * from leerlingen where llnr = $llnr"; $result = mysqli_query($db, $query) or die(mysqli_error($db)); $row = mysqli_fetch_array($result); echo "<table>"; echo "<tr>"; echo "<th>Leerlingnummer</th>"; echo "<th>voornaam</th>"; echo "<th>Tussenvoegsel</th>"; echo "<th>Achternaam</th>"; echo "<th>Straat</th>"; echo "<th>Huisnummer</th>"; echo "<th>Postcode</th>"; echo "<th>Plaats</th>"; echo "<th>Telefoon</th>"; echo "<th>Geslacht</th>"; echo "<th>Geboortedatum</th>"; echo "<th>Klas</th>"; echo "</tr>"; echo "<tr>"; echo "<td>$row[llnr]</td>"; echo "<td>$row[voornaam]</td>"; echo "<td>$row[tussenvoegsel]</td>"; echo "<td>$row[achternaam]</td>"; echo "<td>$row[straat]</td>"; echo "<td>$row[huisnummer]</td>"; echo "<td>$row[postcode]</td>"; echo "<td>$row[plaats]</td>"; echo "<td>$row[telefoon]</td>"; echo "<td>$row[geslacht]</td>"; echo "<td>$row[geb_datum]</td>"; echo "<td>$row[klas]</td>"; echo "</tr>"; echo "</table>"; echo "<form name='gegevens' action='' method='post'>"; echo "<input type='hidden' value=$_POST[lnr] name='Leerlingnummer'>"; echo "<table>"; echo "<tr>"; echo "<td>Voornaam:</td>"; echo "<td><input type='text' name='voornaam' value='$row[voornaam]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Tussenvoegsel:</td>"; echo "<td><input type='text' name='tussenvoegsel' value='$row[tussenvoegsel]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Achternaam:</td>"; echo "<td><input type='text' name='achternaam' value='$row[achternaam]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Straat:</td>"; echo "<td><input type='text' name='straat' value='$row[straat]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Huisnummer:</td>"; echo "<td><input type='text' name='huisnummer' value='$row[huisnummer]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Postcode:</td>"; echo "<td><input type='text' name='postcode' value='$row[postcode]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Plaats:</td>"; echo "<td><input type='text' name='plaats' value='$row[plaats]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Telefoon:</td>"; echo "<td><input type='text' name='telefoon' value='$row[telefoon]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Geslacht:</td>"; echo "<td><input type='text' name='geslacht' value='$row[geslacht]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Geboortedatum:</td>"; echo "<td><input type='text' name='geb_datum' value='$row[geb_datum]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Klas:</td>"; echo "<td><input type='text' name='klas' value='$row[klas]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; echo "<td><input type='submit' name='submit' value='Opslaan'></td>"; echo "</tr>"; echo "</table>"; echo "</form>"; } if (isset($_POST['submit'])){ $llnr=$_POST['llnr']; $voornaam=$_POST['voornaam']; $tussenvoegsel=$_POST['tussenvoegsel']; $achternaam=$_POST['achternaam']; $straat=$_POST['straat']; $huisnummer=$_POST['huisnummer']; $postcode=$_POST['postcode']; $plaats=$_POST['plaats']; $telefoon=$_POST['telefoon']; $geslacht=$_POST['geslacht']; $geb_datum=$_POST['geb_datum']; $klas=$_POST['klas']; if($llnr != ''){ $query = "UPDATE leerlingen SET llnr = '$llnr', voornaam = '$voornaam', tussenvoegsel = '$tussenvoegsel', achternaam = '$achternaam', straat = '$straat', huisnummer = '$huisnummer', postcode = '$postcode', plaats = '$plaats', telefoon = '$telefoon', geslacht = '$geslacht', geb_datum = '$geb_datum', klas = '$klas' WHERE llnr = $llnr"; echo $query; } else{ $query = "INSERT INTO leerlingen (llnr, voornaam, tussenvoegsel, achternaam, straat, huisnummer, postcode, plaats, telefoon, geslacht, geb_datum, klas) VALUES (null, '$voornaam', '$tussenvoegsel', '$achternaam', '$straat', '$huisnummer', '$postcode', '$plaats', '$telefoon', '$geslacht', '$geb_datum', '$klas')"; echo $query; } } } } elseif (isset($_POST['nieuwleerling'])){ echo '<h3>Nieuwe leerling</h3>'; echo "<form name='gegevens' action='' method='post'>"; echo "<table>"; echo "<tr>"; echo "<td>Voornaam:</td>"; echo "<td><input type='text' name='voornaam' value='$row[voornaam]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Tussenvoegsel:</td>"; echo "<td><input type='text' name='tussenvoegsel' value='$row[tussenvoegsel]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Achternaam:</td>"; echo "<td><input type='text' name='achternaam' value='$row[achternaam]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Straat:</td>"; echo "<td><input type='text' name='straat' value='$row[straat]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Huisnummer:</td>"; echo "<td><input type='text' name='huisnummer' value='$row[huisnummer]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Postcode:</td>"; echo "<td><input type='text' name='postcode' value='$row[postcode]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Plaats:</td>"; echo "<td><input type='text' name='plaats' value='$row[plaats]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Telefoon:</td>"; echo "<td><input type='text' name='telefoon' value='$row[telefoon]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Geslacht:</td>"; echo "<td><input type='text' name='geslacht' value='$row[geslacht]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Geboortedatum:</td>"; echo "<td><input type='text' name='geb_datum' value='$row[geb_datum]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td>Klas:</td>"; echo "<td><input type='text' name='klas' value='$row[klas]'></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; echo "<td><input type='submit' name='submit' value='Opslaan'></td>"; echo "</tr>"; echo "</table>"; echo "</form>"; } // if ($witregel){ echo '<br>'; echo '<br>'; } echo "<h3>Leerlingengegevens</h3>"; $query = "select llnr, voornaam, tussenvoegsel, achternaam from leerlingen order by llnr"; $result = mysqli_query($db, $query) or die(mysqli_error($db)); echo "<form name='keuze' action='' method='post'>"; echo "<select name='leerling'>"; echo "<option value=''></option>"; while ($row=mysqli_fetch_array($result)){ echo "<option value='$row[llnr]'>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</option>"; } echo "</select>"; echo "<input name='submit2' type='submit' value='Openen'>"; echo "<div>"; echo "<input name='nieuwleerling' type='submit' value='Nieuwe leerling'>"; echo "</form>"; ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse