query($query);
$villes = [];
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
$villes[] = [
'ville' => $row['ville'],
'latitude' => $row['latitude'],
'longitude' => $row['longitude']
];
}
}
// Requête pour sélectionner les valeurs uniques pour les menus déroulants
$types = [];
$departements = [];
$hopitaux = [];
$genres = [];
$query = "SELECT DISTINCT Type FROM bddgmed";
$result = $conn->query($query);
while ($row = $result->fetch_assoc()) {
$types[] = $row['Type'];
}
$query = "SELECT DISTINCT Departement FROM bddgmed ORDER BY CAST(Departement AS UNSIGNED)";
$result = $conn->query($query);
while ($row = $result->fetch_assoc()) {
$departements[] = $row['Departement'];
}
$query = "SELECT DISTINCT nom_de_l_hopital FROM bddgmed ORDER BY nom_de_l_hopital";
$result = $conn->query($query);
while ($row = $result->fetch_assoc()) {
$hopitaux[] = $row['nom_de_l_hopital'];
}
$query = "SELECT DISTINCT Genre FROM bddgmed";
$result = $conn->query($query);
while ($row = $result->fetch_assoc()) {
$genres[] = $row['Genre'];
}
// Requête pour sélectionner toutes les villes disponibles
$all_villes = [];
$query = "SELECT DISTINCT ville FROM bddgmed WHERE latitude IS NOT NULL AND longitude IS NOT NULL ORDER BY ville";
$result = $conn->query($query);
while ($row = $result->fetch_assoc()) {
$all_villes[] = $row['ville'];
}
// Fermer la connexion à la base de données
$conn->close();
?>