Select gevuld uit database
|
<h1>Select gevuld uit database</h1>
<?php
include "connecti.php";
if ($resultaat = mysqli_query($mysqli, "SELECT * FROM test")) {
echo '<td><select name="select">';
while ($row = mysqli_fetch_assoc($resultaat)) {
$selected = $row["id"] == $id ? 'selected="selected"' : '';
echo '<option value="'.$row['id'].'" '.$selected.'>';
echo ''.$row['voornaam'].' ';
echo ''.$row['achternaam'].' ';
echo ''.$row['leeftijd'].'</option>/n';
}
echo '</select></td></tr>';
}
else {
mysqli_error();
}
show_source(__FILE__);
?>