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