opdracht auteurdetails/auteurinfo.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";
$auteurnr = $_GET["auteurnr"];
$result = mysqli_query($db, "SELECT * FROM auteurs WHERE auteurnr = $auteurnr");
$values = mysqli_fetch_row($result);
echo "<h1>$values[1] $values[3] $values[4]</h1>";
if(isset($values[6])){
echo "<p>$values[5] - $values[6]</p>";
}
else{
echo "<p>$values[5]</p>";
}
echo "<p>Geschreven boeken:</p>";
$result = mysqli_query($db, "SELECT * FROM boeken WHERE auteurnr = $auteurnr");
$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 == 2){
$returnedvalue .= "<td><a href='boekinfo.php?boeknr=$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="auteurs.php">Alle auteurs</a></span>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse