123456/ajax/leerlingen.php

<?php ?> <!DOCTYPE html> <html lang="en"> <head> <script src="js/ajax.js"></script> <link href="css/ajax.css" rel="stylesheet" type="text/css"> <title>Leerlingen</title> <script> window.onload = setEvents function setEvents(){ document.getElementById('llnr').onchange = leerlingChange } function leerlingChange(){ var llnr = this.options[this.selectedIndex].value; //document.location='?auteurnr=' + auteurnr; ajax('includes/leerlingdetails.php?llnr='+ llnr ,'leerlingdetails') } </script> </head> <body> <?php include('includes/db.php');//verbinding database echo "<div><span class='veldnaam'>Auteur:</span>"; ?> <select name='llnr' id='llnr'> <option value=''></option> <?php //alle auteurs ophalen $query ="select * from leerlingen order by achternaam"; $result = mysqli_query($db_link, $query) or die(mysqli_error($db_link).": $query"); while($row = mysqli_fetch_array($result)){ //$selected = $auteurnr == $row['auteurnr']?"selected":""; echo "<option $selected value='$row[llnr]'>$row[voornaam] $row[tussenvoegsel] $row[achternaam]</option>\n"; } echo "</select></div>"; echo "<div id='leerlingdetails'></div>"; ?> <hr> <p><input type="checkbox" id='alertRespons'>Alert antwoord</p> <div id='ajaxtext'></div> </body> </html>

Resultaat

Made by Thijs Aarnoudse