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