l107/PO php/Ajax/AjaxVerwijderen.php

<?php if($_GET['welke']){ $welke = $_GET['welke']; echo "<div>" . $welke . "</div>"; echo "<select name='wuwa' id='wawa'>"; // echo "<option value='idk'></option>"; $query ="select * from $welke"; $result = mysqli_query($db, $query) or die(mysqli_error($db).": $query"); if($welke == 'acteurs'){ echo "1"; while($row = mysqli_fetch_array($result)){ echo "<option $selected value='$row[acteur_id]'>$row[act_voornaam] $row[act_tussenvoegsel] $row[act_achternaam] $row[act_geb_datum] $row[act_sterfdatum]</option>\n"; }; } else if($welke == 'films'){ echo "2"; while($row = mysqli_fetch_array($result)){ echo "<option $selected value='$row[componist_id]'>$row[titel]</option>\n"; }; } else if($welke == 'streamingsdiensten'){ echo "3"; while($row = mysqli_fetch_array($result)){ echo "<option $selected value='$row[acteur_id]'>$row[dienstnaam]</option>\n"; }; } else if($welke == 'rollen'){ echo "4"; while($row = mysqli_fetch_array($result)){ echo "<option $selected value='$row[acteur_id]'>$row[rol_voornaam]</option>\n"; }; } else if($welke == 'componisten'){ echo "5"; while($row = mysqli_fetch_array($result)){ echo "<option $selected value='$row[acteur_id]'>$row[comp_voornaam]</option>\n"; }; } else if($welke == 'regisseurs'){ echo "6"; while($row = mysqli_fetch_array($result)){ echo "<option $selected value='$row[acteur_id]'>$row[reg_voornaam]</option>\n"; }; } ; echo "</select></div>"; }; ?>

Resultaat

Made by Thijs Aarnoudse