l207/gevangenis.php

<!DOCTYPE html> <html lang="en"> <head> <link rel="stylesheet" href="style/style.css"> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body id="gevangenis"> <html><h1>gevangenissen</h1></html> <table border="1"> <tr> <th>gevangenis ID</th> <th>naam</th> <th>plaats</th> <th>aantal cellen</th> </tr> <button onclick="location.href='moorden.php'">moorden</button> <button onclick="location.href='moordenaars.php'">moordenaars</button> <button onclick="location.href='slachtoffers.php'">slachtoffers</button> <button onclick="location.href='index.php'">homepagina</button> <?php include('db.php'); $query = "select * from gevangenis"; $result = mysqli_query($db, $query); while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td><a href='gevangenis_gegevens.php?gevangenisID=" . $row['gevangenisID'] . "'>$row[gevangenisID]</a></td>"; echo "<td><a href='gevangenis_gegevens.php?gevangenisID=" . $row['gevangenisID'] . "'>$row[naam]</a></td>"; echo "<td>$row[plaats]</td>"; echo "<td>$row[cellen]</td>"; echo "</tr>"; } ?> </table> </body> </html>

Resultaat

Made by Thijs Aarnoudse