123456/Simon/ajax/bestellen.php

<?php include('../db.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 href="ajax.css" rel="stylesheet" type="text/css"> <script src="js/ajax.js"></script> <script> </script> </head> <body> <div id='container'> <div id='right'> <div id='ajax'> <h3 align="center">A.J.A.X.</h3> <p align="right"><input type="checkbox" id='alertRespons'>Alert antwoord</p> <div id='ajaxtext'></div> </div> </div> <?php include('../db.php'); $query = "select auteurnr, voornaam, tussenvoegsel, achternaam from auteurs order by achternaam"; $result = mysqli_query($db, $query) ; echo "<form><p>"; echo "<span class='label'>Auteurs :</span>"; echo "<span class='info'>"; echo "<select name='auteurnr' id='auteurs'>"; echo "<option value=''></option>"; while($row = mysqli_fetch_array($result)){//auteurs langs echo "<option value='$row[auteurnr]'>$row[achternaam], $row[voornaam] $row[tussenvoegsel]</option>"; } echo "</select></span>"; echo "<input type='submit' value='Verzenden'>"; echo "</p></form>"; echo "<span class='label'>Boeken :</span>"; echo "<span class='info'>"; echo "<select name='boeken' id='boeken' onchange='toonBoek(this)'>"; $auteurnr=$_GET['auteurnr']; if($auteurnr ){ $query = "select boeknr, titel from boeken where auteurnr=$auteurnr"; $result = mysqli_query($db, $query) or die(mysqli_error($db)); echo "<option value=''></option>\n"; while($row = mysqli_fetch_array($result)){//auteurs option echo "<option value='$row[boeknr]'>$row[titel]</option>\n"; } } else{ echo "<option value=''>(Kies eerst een auteur)</option>\n"; } echo "</select>"; ?> </div> </html>

Resultaat

Made by Thijs Aarnoudse