getMessage());
}
// On prépare la requête
$sql = « SELECT laboratoires.id AS ‘id’, laboratoires.region AS ‘region’,
laboratoires.district AS ‘district’, laboratoires.labo AS ‘labo’,
laboratoires.lattitude AS ‘lattitude’, laboratoires.longitude AS ‘longitude’, infogenerales.Telephone AS ‘Telephone’,
infogenerales.Statut AS ‘Statut’, infogenerales.Niveau AS ‘Niveau’, infogenerales.DemarcheQualite AS ‘DemarcheQualite’,
infogenerales.Accreditation AS ‘Accreditation’ FROM laboratoires,infogenerales WHERE laboratoires.id=infogenerales.id »;
$stmt = $bdd->prepare($sql);
$stmt->execute();
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
// On transforme le tableau PHP en json
$retour = json_encode($results);
// On retourne le tableau à la fonction appelante
echo $retour;
?>