l112/PO/search.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <link href="stijlsheet/stylesheet.css?t=<?php echo time(); ?>" rel="stylesheet" type="text/css"> </head> <body> </body> </html> <?php include "db.php"; $zoek = $_GET["zoek"]; $query = "SELECT * FROM afleveringen WHERE serienaam like '%$zoek%' OR titel like '%$zoek%'"; $result = mysqli_query($db, $query); if($result){ echo '<div><h2>Afleveringen</h2></div>'; while ($row = mysqli_fetch_array($result)) { echo "<div><a href='afleveringen.php?serieid=$row[serieid]&seiznr=$row[seiznr]'>$row[titel] - $row[serienaam]</a></div>"; } } $query = "SELECT * FROM films WHERE titel like '%$zoek%'"; $result = mysqli_query($db, $query); if($result){ echo '<div><h2>Films</h2></div>'; while ($row = mysqli_fetch_array($result)) { echo "<div><a href='filmdetails.php?filmid=$row[filmid]'>$row[titel]</a></div>"; } } $query = "SELECT * FROM series WHERE naam like '%$zoek%'"; $result = mysqli_query($db, $query); if($result){ echo '<div><h2>Series</h2></div>'; while ($row = mysqli_fetch_array($result)) { echo "<div><a href='seriedetails.php?serieid=$row[serieid]'>$row[naam]</div>"; } } $query = "SELECT * FROM streamingsdiensten WHERE naam like '%$zoek%'"; $result = mysqli_query($db, $query); if($result){ echo '<div><h2>Streamingsdiensten</h2></div>'; while ($row = mysqli_fetch_array($result)) { echo "<div>$row[naam]</div>"; } } ?>

Resultaat

Made by Thijs Aarnoudse