409";
$db = connect_base();
$queryRequest = $db->prepare( $query );
$queryRequest->execute();
if($queryRequest->rowCount()>0){
$data=$queryRequest->fetchAll();
foreach($data as $cle=>$val){
$add=decrypter($maCleDeCryptage,$val['adresse1'])." ";
$add.=decrypter($maCleDeCryptage,$val['adresse2'])." ";
$add.=decrypter($maCleDeCryptage,$val['cp'])." ";
$add.=decrypter($maCleDeCryptage,$val['ville']);
echo $add.'
';
$url_gmap = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . urlencode(utf8_encode($add)) . '&sensor=false&key=AIzaSyAD8dr4sS_iFafcU_AowzS9p9B306iQEZQ';
$json = json_decode(file_get_contents($url_gmap), true);
$coord = $json['results']['0']['geometry']['location'];
//$file2[$line] = $content . ';' . $coord['lat'] . ';' . $coord['lng'];
echo "
"; echo "Lat : ".$coord['lat'];
echo "
";
echo "Lon : ".$coord['lng'];
echo "
"; echo "
"; echo "
";
$query2="update eta set lat=:lat, lon=:lon where id_eta=:id_eta";
$db2 = connect_base();
$queryRequest2 = $db2->prepare( $query2 );
$queryRequest2->bindParam( ':id_eta', $val['id_eta'], PDO::PARAM_INT );
$queryRequest2->bindParam( ':lat', $coord['lat'], PDO::PARAM_STR);
$queryRequest2->bindParam( ':lon', $coord['lng'], PDO::PARAM_STR );
$queryRequest2->execute();
}
}
?>