opdracht auteurdetails/boekinfo.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>
<link rel="stylesheet" type="text/css" href="infostyle.css">
</head>
<body>
<?php
include "../db.php";
include "../functions.php";
$boeknr = $_GET["boeknr"];
$result = mysqli_query($db, "SELECT * FROM boeken WHERE boeknr = $boeknr");
$values = mysqli_fetch_row($result);
echo "<h1>$values[2]</h1>";
echo "<p>Gepubliceerd in $values[3]</p>";
$values2 = mysqli_fetch_row(mysqli_query($db, "SELECT voornaam, tussenvoegsel, achternaam, auteurnr FROM auteurs WHERE auteurnr = $values[1]"));
echo "<p>Geschreven door <a href='auteurinfo.php?auteurnr=$values2[3]'>$values2[0] $values2[1] $values2[2]</a></p>";
echo "<p>Geleend door:</p>";
$result = mysqli_query($db, "SELECT DISTINCT leerlingen.* FROM leerlingen, uitleningen WHERE boeknr = $boeknr");
$returnedvalue = "<table>";
for($i = 0; $i < mysqli_num_rows($result); $i++){
$values = mysqli_fetch_array($result);
$returnedvalue .= "<tr>";
for($j = 0; $j < count($values)/2; $j++){
if($j == 1){
$returnedvalue .= "<td><a href='leerlinginfo.php?llnr=$values[0]'>$values[$j]</a></td>";
}
else{
$returnedvalue .= "<td>$values[$j]</td>";
}
}
$returnedvalue .= "</tr>";
}
$returnedvalue .= "</table>";
$returnedvalue = str_replace("<table>", "<table style='border: 1px solid'>", $returnedvalue);
$returnedvalue = str_replace("<td>", "<td style='border: 1px solid'>", $returnedvalue);
echo $returnedvalue;
//echo formattable($result, "border");
?>
<br><span><a href="boeken.php">Alle boeken</a></span>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse