123456/ajax/opdracht/leerlingreservering.php
<?php
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>
<script src="../js/ajax.js"></script>
<script>
function reserveren(){
var leerlingen = document.getElementById('leerlingen')
var llnr = leerlingen.options[leerlingen.selectedIndex].value
var boeken = document.getElementById('boeken')
var boeknr = boeken.options[boeken.selectedIndex].value
var adres = 'reserveren.php?boeknr=' + boeknr + "&llnr=" + llnr;
//alert(adres)
ajax(adres, 'reserveringen');
}
function init(){
document.getElementById('button').onclick = reserveren;
}
window.onload = init;
</script>
<meta charset="iso-8859-2">
<title>Boek reserveren met 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 "<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
echo "<option value='$row[boeknr]'>$row[achternaam], $row[voornaam] $row[tussenvoegsel] - $row[titel]</option>";
}
echo "</select>";
echo "</p>";
echo "<p>";
echo "<span class='label'></span>";
echo "<input type='button' value='Reserveren' id='button' ";
echo "</p>";
echo "<div id='reserveringen'>";
echo "</div>";
echo "<div id='ajaxtext'></div>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse