l103/15.2.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> </head> <body> <?php include('db.php');//verbinding database $query = "select auteurnr, achternaam from auteurs order by achternaam"; $result = mysqli_query($db, $query) or die(mysqli_error($db)); echo "<form name='keuze' action='' method='post'>"; echo "<select name='auteurnr'>"; echo "<option value=''></option>"; //lege keuze while ($rowA=mysqli_fetch_array($result)){ //zolang er een volgende rij/record is echo "<option value='$row[auteurnr]'> $rowA[achternaam]</option>"; //auteurnr als value } echo "</select>"; echo "<input name='submit2' type='submit' value='Openen'>"; //knop echo "</form>"; ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse