opdracht auteurdetails/leerlinginfo.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";
$llnr = $_GET["llnr"];
$result = mysqli_query($db, "SELECT * FROM leerlingen WHERE llnr = $llnr");
$values = mysqli_fetch_row($result);
echo "<h1>$values[1] $values[2] $values[3]</h1>";
echo "<p>$values[4] $values[5] $values[7]</p>";
echo "<p>$values[6]</p>";
echo "<p>Geleende boeken:</p>";
$result = mysqli_query($db, "SELECT titel, datum_uit, auteurs.voornaam, auteurs.tussenvoegsel, auteurs.achternaam, boeken.boeknr, auteurs.auteurnr FROM auteurs, boeken, uitleningen, leerlingen
WHERE auteurs.auteurnr = boeken.auteurnr AND boeken.boeknr = uitleningen.boeknr AND uitleningen.llnr = leerlingen.llnr AND leerlingen.llnr = $llnr");
$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 == 0){
$returnedvalue .= "<td><a href='boekinfo.php?boeknr=$values[5]'>$values[$j]</a></td>";
}
else if($j == 2){
$returnedvalue .= "<td><a href='auteurinfo.php?auteurnr=$values[6]'>$values[$j]</a></td>";
}
else if ($j < 5){
$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;
//for($i = 0; $i < )
?>
<br><span><a href="leerlingen.php">Alle leerlingen</a></span>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse