✏️ Editing: pxx.php

<?php
include 'conex.php';

$sqlxx=$conex->query ("SELECT * FROM zonas WHERE lat='' and lon='' limit 1 ") or die(mysqli_error());   
            if($row_cnt = $sqlxx->num_rows>0) {       
            while ($rowxx = $sqlxx->fetch_array(MYSQLI_ASSOC) ) {   
            $id= $rowxx['id'];                                         
            $direccion= $rowxx['direccion'];                                                    
                    }    
            }

//echo $direccion;

$ubicacion=$direccion;
$url="https://nominatim.openstreetmap.org/search.php?q=".urlencode($ubicacion)."&format=jsonv2";
  $USERAGENT = $_SERVER['HTTP_USER_AGENT'];
    $opts = array('http'=>array('header'=>"User-Agent: $USERAGENT\r\n"));
    $context = stream_context_create($opts);
    $url4 = file_get_contents($url, false, $context);    
    $osmaddress = json_decode($url4);

$lat = $osmaddress[0]->lat;
         $lon = $osmaddress[0]->lon;

if ($lat=='' and $lon=='') {
  $lat=$lon='N/A';
}
/*
echo $lat;
echo "</br>";
echo $lon;
*/

$_grabar_sql="UPDATE `zonas` SET `lat`='$lat',`lon`='$lon' WHERE id='$id' ";
         mysqli_query($conex,$_grabar_sql);

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team