Case "24": //yakınklarıal
$usn = clean($_GET["girdi1"]);
$psw = md5(clean($_GET["girdi2"]));
$base = clean($_GET["girdi3"]);
$p1 = clean($_GET["girdi4"]);
$p2 = clean($_GET["girdi5"]);
$value1 = 500;
$value2 = 1500;
$q = "SELECT ident,latitude_deg,longitude_deg,iso_country,name FROM airports3";
// $q = "SELECT * FROM useraircrafts1 where username='".$usn."' order by date DESC";
$r = mysql_query($q);
$all = array();
while(($row = mysql_fetch_assoc($r))) {
$lat2=$row['latitude_deg'];
$lon2=$row['longitude_deg'];
$ident=$row['ident'];
$ulke=$row['iso_country'];
$name=$row['name'];
// $all[] = distance('29','41',$lat2,$lon2,'N');
$arr[] = array('uzaklik' => distance('41','26',$lat2,$lon2,'N'), 'ident' => $ident, 'ulke' => $ulke, 'name' => $name);
}
$uzaklik = array();
foreach ($arr as $key => $row2)
{
$uzaklik[$key] = $row2['uzaklik'];
}
array_multisort($uzaklik, SORT_ASC, $arr);
$new = array_filter($arr, function ($var) {
return ($var['uzaklik'] > '500' and $var['uzaklik'] < '1500');
});
print json_encode(array_slice($new, 0, 10000));