123456/ajax/opdracht/leerlingreserveringza.php
<?php
$llnr= $_GET['llnr'];
$boeknr= $_GET['boeknr'];
include('../includes/db.php');
if($llnr && $boeknr){
$datum = strftime("%Y-%m-%d",time());
$query = "insert into reserveringen values($boeknr, $llnr, '$datum',null,'N','open');";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="iso-8859-2">
<title>Boek reserveren zonder ajax</title>
<link href="../ajax.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php
$query = "select * from leerlingen order by achternaam";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
echo "<form method='get'>";
echo "<p>";
echo "<span class='label'>Leerlingen :</span>";
echo "<select name='llnr' id='leerlingen'>";
echo "<option value=''></option>";
while($row = mysqli_fetch_array($result)){//auteurs langs
$selected = $row['llnr'] == $llnr ? "selected":"";
echo "<option value='$row[llnr]' $selected>$row[achternaam], $row[voornaam] $row[tussenvoegsel]</option>";
}
echo "</select>";
echo "</p>";
$query = "select * from boeken, auteurs where boeken.auteurnr = auteurs.auteurnr order by achternaam, titel";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
echo "<p>";
echo "<span class='label'>Boeken :</span>";
echo "<select name='boeknr' id='boeken'>";
echo "<option value=''></option>";
while($row = mysqli_fetch_array($result)){//auteurs langs
$selected = $row['boeknr'] == $boeknr ? "selected":"";
echo "<option value='$row[boeknr]' $selected>$row[achternaam], $row[voornaam] $row[tussenvoegsel] - $row[titel]</option>";
}
echo "</select>";
echo "</p>";
echo "<p>";
echo "<span class='label'></span>";
echo "<input type='submit' value='Reserveren'";
echo "</p>";
echo "</form>";
if($llnr){
$query = "select b.titel, a.achternaam, r.datum_reservering from auteurs a, boeken b, reserveringen r, leerlingen l where a.auteurnr = b.auteurnr and b.boeknr = r.boeknr and r.llnr = l.llnr and l.llnr=$llnr order by datum_reservering desc";
$result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
echo "<table>";
while($row = mysqli_fetch_array($result)){
echo "<tr>";
$datum = strftime("%d %B %Y",strtotime($row[datum_reservering]));
echo "<td>$row[titel] - $row[achternaam] - $datum</span></td>\n";
echo "</tr>";
}
echo "</table>";
}
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse