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