connect_error) {
die(“Verbinding met database mislukt: ” . $conn->connect_error);
}

mysqli_set_charset($conn, “utf8”);

$sql = “SELECT koorplaats,volnaam,ledental FROM leden ORDER by koorplaats”;
$result = $conn->query($sql);

if ($result->num_rows > 0) {
echo “

“;
echo “

“;

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

// output data of each row
while($row = $result->fetch_assoc())
{
echo “

“;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo “

“;
}

echo “

Plaats Koornaam Ledental
‘,$row[‘koorplaats’], ‘ ‘,$row[‘volnaam’], ‘ ‘,$row[‘ledental’], ‘

“;
}
else {
echo “Geen resultaten gevonden”;
}
$conn->close();
?>