recherhe de ville alentour d un point x

Bonsoir

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13

$lat = 49.21667; $lon = 1.16667;     $formule="(6371*acos(cos(radians($lat))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians($lon))+sin(radians($lat))*sin(radians(`latitude`))))";   $dest= $connect->query ("SELECT id,city,'$formule' AS dist FROM donnee_destination WHERE '$formule'<= 10 ORDER by dist ASC"); while($dest_fin = $dest->fetch_assoc()){ $id_city = $dest_fin["city"]; $id_id = $dest_fin["id"];   echo $id_id; echo $id_city;}

---

J 'ai trouver un script que j 'ai adapter pour afficher ville alentour de 10 km(ou autre )depuis une ville , mais celui-ci affiche toutes les villes présentes en base de donnée, est ce que vous voyez d’où vient le problème ?

Bonjour,

Teste d'abord ça dans ton PHPmyadmin

Code:

---

1 2 3 4

select id, city, round((6371*acos(cos(radians(49.21667))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians(1.16667))+sin(radians(49.21667))*sin(radians(`latitude`)))) , 2) as dist from donnee_destination where (6371*acos(cos(radians(49.21667))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians(1.16667))+sin(radians(49.21667))*sin(radians(`latitude`)))) <= 10 order by dist;

---

Et quand ça fonctionne, passe à PHP (avec PDO ici).

Code:

---

1 2 3 4 5 6 7 8 9 10 11

$sql=' select id, city, round((6371*acos(cos(radians(49.21667))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians(1.16667))+sin(radians(49.21667))*sin(radians(`latitude`)))) , 2) as dist from donnee_destination where (6371*acos(cos(radians(49.21667))*cos(radians(`latitude`))*cos(radians(`longitude`) -radians(1.16667))+sin(radians(49.21667))*sin(radians(`latitude`)))) <= 10 order by dist, city; '; $dest= $connect->query ($sql); $data= $dest->fetchAll(PDO::FETCH_ASSOC); foreach ($data as $row){ echo $row['id'].' / '.$row['city'].' / '.$row['dist'].'<br/>'; }

---

Merci Dentrite :D j 'essai sa dans la journée

Bonne journée

Merci beaucoup cela fonctionne maintenant