l104/H15/15.8.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 {
padding: 10px;
border-collapse: collapse;
}
th, td {
border: 1px solid black;
padding: 5px;
}
a{
text-decoration: none;
font-size: 15px;
}
button{
background: transparent;
border: none;
}
</style>
</head>
<body>
<?php
include('../db.php');
if(isset($_GET['edit'])){
$edit=$_GET['edit'];
echo '<button><a href="15.8.php">Back</a></button>';
}
else{
$edit=null;
}
function form(){
global $db;
$query = "select * from auteurs order by auteurnr";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
echo "<table>";
echo "<tr>";
echo "<th>Edit</th>";
echo "<th>Auteurnr</th>";
echo "<th>Voornaam</th>";
echo "<th>Voorletters</th>";
echo "<th>Tussenvoegsel</th>";
echo "<th>Achternaam</th>";
echo "<th>Geboortejaar</th>";
echo "<th>Sterfjaar</th>";
echo '<tr>';
while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td><a href='15.8.php?edit=$row[auteurnr]'>✏️</a></td>";
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>";
}
}
if($edit){
$query = "select * from auteurs where auteurnr = $edit";
$result = mysqli_query($db, $query) or die(mysqli_error($db));
$row = mysqli_fetch_array($result);
echo "<h3>Wijzig de gegevens van de auteur $row[voornaam] $row[tussenvoegsel] $row[achternaam]</h3>";
echo "<form name='gegevens' action='' method='post'>";
echo "<table>";
echo "<input type='hidden' name='Auteurnr' value='$row[auteurnr]'>";
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(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'];
$query = "UPDATE auteurs set voornaam='$voornaam', voorletters='$voorletters', tussenvoegsel='$tussenvoegsel', achternaam='$achternaam', geb_jaar='$geb_jaar', sterfjaar='$sterfjaar' where auteurnr=$auteurnr";
echo $query;
}
}
elseif(!$edit){
form();
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse