l104/H15/15.4.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['nieuwauteur'])){
if (isset($_POST['auteur'])){
if($_POST['auteur'] != ''){
$auteur=$_POST['auteur'];
$query = "select * from auteurs where auteurnr = $auteur";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$row = mysqli_fetch_array($result);
echo "<table>";
echo "<tr>";
echo "<th>Auteurnr</th>";
echo "<th>Voornaam</th>";
echo "<th>Voorletters</th>";
echo "<th>Tussenvoegsel</th>";
echo "<th>Achternaam</th>";
echo "<th>Geboortedatum</th>";
echo "<th>Sterfjaar</th>";
echo "</tr>";
echo "<tr>";
echo "<td>$row[auteurnr]</td>";
echo "<td>$row[voornaam]</td>";
echo "<td>$row[voorletters]</td>";
echo "<td>$row[tussenvoegsel]</td>";
echo "<td>$row[achternaam]</td>";
echo "<td>$row[geb_jaar]</td>";
echo "<td>$row[sterfjaar]</td>";
echo "<td><form name='gegevens' action='' method='post'><input type='submit' name='gegevens' value='Wijzigen'><input type='hidden' value=$_POST[auteur] name='autnr'></form></td>";
echo "</tr>";
echo "</table>";
$witregel=true;
}
}
if (isset($_POST['gegevens'])||isset($_POST['submit'])){
if (isset($_POST['gegevens'])){
$auteur=$_POST['autnr'];
$query = "select * from auteurs where auteurnr = $auteur";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$row = mysqli_fetch_array($result);
echo "<table>";
echo "<tr>";
echo "<th>Auteurnr</th>";
echo "<th>Voornaam</th>";
echo "<th>Voorletters</th>";
echo "<th>Tussenvoegsel</th>";
echo "<th>Achternaam</th>";
echo "<th>Geboortedatum</th>";
echo "<th>Sterfjaar</th>";
echo "</tr>";
echo "<tr>";
echo "<td>$row[auteurnr]</td>";
echo "<td>$row[voornaam]</td>";
echo "<td>$row[voorletters]</td>";
echo "<td>$row[tussenvoegsel]</td>";
echo "<td>$row[achternaam]</td>";
echo "<td>$row[geb_jaar]</td>";
echo "<td>$row[sterfjaar]</td>";
echo "</tr>";
echo "</table>";
echo "<form name='gegevens' action='' method='post'>";
echo "<input type='hidden' value=$_POST[autnr] name='Auteurnr'>";
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>Voorletters:</td>";
echo "<td><input type='text' name='Voorletters' value='$row[voorletters]'></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>Geboortedatum:</td>";
echo "<td><input type='text' name='Geb_jaar' value='$row[geb_jaar]'></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Sterfjaar:</td>";
echo "<td><input type='text' name='Sterfjaar' value='$row[sterfjaar]'></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'])){
$auteurnr=$_POST['Auteurnr'];
$voornaam=$_POST['Voornaam'];
$voorletters=$_POST['Voorletters'];
$tussenvoegsel=$_POST['Tussenvoegsel'];
$achternaam=$_POST['Achternaam'];
$geb_jaar=$_POST['Geb_jaar'];
$sterfjaar=$_POST['Sterfjaar'];
if($auteurnr != ''){
echo "UPDATE auteurs SET auteurnr = '$auteurnr',voornaam = '$voornaam', voorletters = '$voorletters', tussenvoegsel = '$tussenvoegsel', achternaam = '$achternaam', geb_jaar = '$geb_jaar', sterfjaar = '$sterfjaar' WHERE auteurnr = $auteurnr";
}
else{
echo "INSERT INTO auteurs (auteurnr, voornaam, voorletters, tussenvoegsel, achternaam, geb_jaar, sterfjaar) VALUES (null, '$voornaam', '$voorletters', '$tussenvoegsel', '$achternaam', '$geb_jaar', '$sterfjaar')";
}
}
}
}
elseif (isset($_POST['nieuwauteur'])){
echo '<h3>Nieuwe auteur</h3>';
echo "<form name='gegevens' action='' method='post'>";
echo "<table>";
echo "<tr>";
echo "<td>Voornaam:</td>";
echo "<td><input type='text' name='Auteurnr' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Voornaam:</td>";
echo "<td><input type='text' name='Voornaam' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Voorletters:</td>";
echo "<td><input type='text' name='Voorletters' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Tussenvoegsel:</td>";
echo "<td><input type='text' name='Tussenvoegsel' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Achternaam:</td>";
echo "<td><input type='text' name='Achternaam' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Geboortedatum:</td>";
echo "<td><input type='text' name='Geb_jaar' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td>Sterfjaar:</td>";
echo "<td><input type='text' name='Sterfjaar' value=''></td>";
echo "</tr>";
echo "<tr>";
echo "<td></td>";
echo "<td><input type='submit' name='submit' value='Opslaan'></td>";
echo "</tr>";
echo "</table>";
}
//
if ($witregel){
echo '<br>';
echo '<br>';
}
echo "<h3>Auteurgegevens</h3>";
$query = "select * from auteurs order by achternaam";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
echo "<form name='keuze' action='' method='post'>";
echo "<select name='auteur'>";
echo "<option value=''></option>";
while ($row=mysqli_fetch_array($result)){
echo "<option value='$row[auteurnr]'>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</option>";
}
echo "</select>";
echo "<input name='submit2' type='submit' value='Openen'>";
echo "<div>";
echo "<input name='nieuwauteur' type='submit' value='Nieuwe auteur'>";
echo "</form>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse