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