l208/studios.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 rel="stylesheet" href="style/style.css">
</head>
<body>
<html>
<div class="menubalk">
<a href="index.html">Home</a>
<a href="storyline.html">Storyline</a>
<a href="joel.html">Joel</a>
<a href="ellie.html">Ellie</a>
<a href="TVshow.html">TV show</a>
</div>
</html>
<?php
include("db.php");
$query = "select * from studio order by naam";
$result = mysqli_query($db, $query);
$row = mysqli_fetch_array($result);
echo "<h3> studio's</h3>";
while($row = mysqli_fetch_array($result)){
echo "<div><a href='studiodetails.php?studioid=$row[studioid]'> $row[naam]</div>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse