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