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