l104/H15/15.7.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> </head> <body> <?php include '../db.php'; if(isset($_POST['rubriek']) || isset($_POST['genre'])){ if(isset($_POST['rubriek'])){ $rubriek = $_POST['rubriek']; $voorwaarde = "rubriek = '$rubriek'" . $voorwaarde; } if(isset($_POST['genre'])){ $genre = $_POST['genre']; $voorwaarde = "genre = '$genre'" . $voorwaarde; } } else { $voorwaarde = 1; } echo '<table>'; echo '<tr>'; echo '<td>'; echo "<form action='15.7.php' method='post'>"; echo '<div><h3>Rubriek</h3></div>'; $query_rubriek = "SELECT distinct(rubriek) FROM boeken"; $result_rubriek = mysqli_query($db, $query_rubriek) or die ('Error: ' . mysqli_error($db)); while ($row = mysqli_fetch_array($result_rubriek)){ echo "<div><input type='radio' name='rubriek' value='$row[rubriek]'>$row[rubriek]</div>"; } echo "<div><input type='submit' value='Zoeken'></div>"; echo "</form>"; echo '</td>'; echo '<td>'; echo "<form action='15.7.php' method='post'>"; echo '<div><h3>Genre</h3></div>'; $query_genre = "SELECT distinct(genre) FROM boeken"; $result_genre = mysqli_query($db, $query_genre) or die ('Error: ' . mysqli_error($db)); while ($row = mysqli_fetch_array($result_genre)){ echo "<div><input type='radio' name='genre' value='$row[genre]'>$row[genre]</div>"; } echo "<div><input type='submit' value='Zoeken'></div>"; echo "</form>"; echo '</td>'; echo '</tr>'; echo '</table>'; echo '<br>'; echo '<br>'; echo '<br>'; $query = "SELECT * FROM boeken where $voorwaarde"; $result = mysqli_query($db, $query) or die ('Error: ' . mysqli_error($db)); echo "<table>"; echo "<tr>"; echo "<th>Titel</th>"; echo "<th>Auteur</th>"; echo "<th>Publicatie jaar</th>"; echo "<th>Aantal paginas</th>"; echo "<th>Genre</th>"; echo "<th>Rubriek</th>"; echo "</tr>"; while($row = mysqli_fetch_array($result)){ $query2 = "SELECT * FROM auteurs where auteurnr = $row[auteurnr]"; $result2 = mysqli_query($db, $query2) or die ('Error: ' . mysqli_error($db)); $row2 = mysqli_fetch_assoc($result2); echo "<tr>"; echo "<td>$row[titel]</td>"; echo "<td>$row2[voornaam] $row2[tussenvoegsel] $row2[achternaam]</td>"; echo "<td>$row[pub_jaar]</td>"; echo "<td>$row[aantalpags]</td>"; echo "<td>$row[genre]</td>"; echo "<td>$row[rubriek]</td>"; echo "</tr>"; } ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse