l112/sql/data.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>Database</title>
<link href="stijlsheet/stylesheet.css?t=<?php echo time(); ?>" rel="stylesheet" type="text/css">
</head>
<body>
<?php
include "db.php";
$zoek = $_GET["zoek"];
// Zoek films
$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='filmoverzicht.php?filmid=$row[filmid]'>$row[titel]</a></div>";
}
}
// Zoek series
$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='serieoverzicht.php?serieid=$row[serieid]'>$row[naam]</a></div>";
}
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse