Subversion Repositories Sites.obs-saisons.fr

Rev

Rev 5 | Blame | Compare with Previous | Last modification | View Log | RSS feed

<?php


// Programme de migration jetable 
include_once 'connect.php';
//bouh! c'est pas propre! c'est a cause de PEAR et de ses includes
set_include_path('configuration/'.PATH_SEPARATOR.get_include_path());
//librairies PEAR
require_once 'configuration/DB.php' ;
$dsn='mysql://'.$login.':'.$pass.'@'.$hote.'/'.$db;
//echo $dsn.'<br /><br />';
$GLOBALS['car_db'] =& DB::connect($dsn) ;
if (DB::isError($GLOBALS['car_db'])) {
 die ($GLOBALS['car_db']->getMessage());
}

$requete = 'SELECT STATION_ID, STATION_NOM, STATION_LATITUDE , STATION_LONGITUDE FROM STATION ';
 

$resultat = $GLOBALS['car_db']->query($requete) ;
                    
if (DB::isError($resultat)) {
 die ($resultat->getMessage());
}

$i=1;

while ($ligne = $resultat->fetchRow(DB_FETCHMODE_ASSOC)) {
        
          $alt = file_get_contents('http://ws.geonames.org/srtm3?lat='.$ligne['STATION_LATITUDE'].'&lng='.$ligne['STATION_LONGITUDE'], 'r') ;
                        
                

     $requete3= 'UPDATE STATION SET STATION_ALTITUDE='.$alt.' WHERE STATION_ID='.$ligne['STATION_ID'].';';
    
        echo $requete3.'<br/>';
        
        $i++;
    //  if ($i==10) exit;
         
     
}
?>