PHPize Online / SQLize Online  /  SQLtest Online

<?php $data = json_decode('[{"lat":"36.69100189","lng":"3.215410","name":"Houari Boumediene Airport","tz":"Africa\/Algiers","country":"DZ","icao":"DAAG"},{"lat":"36.85100174","lng":"10.227200","name":"Tunis Carthage International Airport","tz":"Africa\/Tunis","country":"TN","icao":"DTTA"},{"lat":"50.63740158","lng":"5.443220","name":"Liege Airport","tz":"Europe\/Brussels","country":"BE","icao":"EBLG"},{"lat":"52.38000107","lng":"13.522500","name":"Berlin-Schonefeld International Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDB"},{"lat":"51.13280106","lng":"13.767200","name":"Dresden Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDC"},{"lat":"52.13460159","lng":"7.684830","name":"Munster Osnabruck Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDG"},{"lat":"53.63040161","lng":"9.988230","name":"Hamburg Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDH"},{"lat":"50.86589813","lng":"7.142740","name":"Cologne Bonn Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDK"},{"lat":"49.49869919","lng":"11.066900","name":"Nuremberg Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDN"},{"lat":"51.43239975","lng":"12.241600","name":"Leipzig Halle Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDP"},{"lat":"49.21459961","lng":"7.109510","name":"Saarbrucken Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDR"},{"lat":"52.46110153","lng":"9.685080","name":"Hannover Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDV"},{"lat":"53.04750061","lng":"8.786670","name":"Bremen Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDDW"},{"lat":"49.94869995","lng":"7.263890","name":"Frankfurt-Hahn Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDFH"},{"lat":"51.61410141","lng":"8.616320","name":"Paderborn Lippstadt Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDLP"},{"lat":"48.77939987","lng":"8.080500","name":"Karlsruhe Baden-Baden Airport","tz":"Europe\/Berlin","country":"DE","icao":"EDSB"},{"lat":"59.41329956","lng":"24.832800","name":"Tallinn Airport","tz":"Europe\/Tallinn","country":"EE","icao":"EETN"},{"lat":"60.31719971","lng":"24.963301","name":"Helsinki Vantaa Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFHK"},{"lat":"62.66289902","lng":"29.607500","name":"Joensuu Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFJO"},{"lat":"65.98760223","lng":"29.239401","name":"Kuusamo Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFKS"},{"lat":"60.12220001","lng":"19.898199","name":"Mariehamn Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFMA"},{"lat":"61.46170044","lng":"21.799999","name":"Pori Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFPO"},{"lat":"61.41410065","lng":"23.604401","name":"Tampere-Pirkkala Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFTP"},{"lat":"60.51409912","lng":"22.262800","name":"Turku Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFTU"},{"lat":"63.05070114","lng":"21.762199","name":"Vaasa Airport","tz":"Europe\/Helsinki","country":"FI","icao":"EFVA"},{"lat":"52.45389938","lng":"-1.748030","name":"Birmingham International Airport","tz":"Europe\/London","country":"GB","icao":"EGBB"},{"lat":"53.33359909","lng":"-2.849720","name":"Liverpool John Lennon Airport","tz":"Europe\/London","country":"GB","icao":"EGGP"},{"lat":"50.77999878","lng":"-1.842500","name":"Bournemouth Airport","tz":"Europe\/London","country":"GB","icao":"EGHH"},{"lat":"49.43500137","lng":"-2.601970","name":"Guernsey Airport","tz":"Europe\/Guernsey","country":"GG","icao":"EGJB"},{"lat":"49.20790100","lng":"-2.195510","name":"Jersey Airport","tz":"Europe\/Jersey","country":"JE","icao":"EGJJ"},{"lat":"51.57139969","lng":"0.695556","name":"Southend Airport","tz":"Europe\/London","country":"GB","icao":"EGMC"},{"lat":"54.08330154","lng":"-4.623890","name":"Isle of Man Airport","tz":"Europe\/Isle_of_Man","country":"IM","icao":"EGNS"},{"lat":"55.03749847","lng":"-1.691670","name":"Newcastle Airport","tz":"Europe\/London","country":"GB","icao":"EGNT"},{"lat":"52.83110046","lng":"-1.328060","name":"East Midlands Airport","tz":"Europe\/London","country":"GB","icao":"EGNX"},{"lat":"57.20190048","lng":"-2.197780","name":"Aberdeen Dyce Airport","tz":"Europe\/London","country":"GB","icao":"EGPD"},{"lat":"55.87189865","lng":"-4.433060","name":"Glasgow International Airport","tz":"Europe\/London","country":"GB","icao":"EGPF"},{"lat":"55.95000076","lng":"-3.372500","name":"Edinburgh Airport","tz":"Europe\/London","country":"GB","icao":"EGPH"},{"lat":"55.50939941","lng":"-4.586670","name":"Glasgow Prestwick Airport","tz":"Europe\/London","country":"GB","icao":"EGPK"},{"lat":"57.48109818","lng":"-7.362780","name":"Benbecula Airport","tz":"Europe\/London","country":"GB","icao":"EGPL"},{"lat":"51.83689880","lng":"-1.320000","name":"Oxford (Kidlington) Airport","tz":"Europe\/London","country":"GB","icao":"EGTK"},{"lat":"52.30860138","lng":"4.763890","name":"Amsterdam Airport Schiphol","tz":"Europe\/Amsterdam","country":"NL","icao":"EHAM"},{"lat":"50.91170120","lng":"5.770140","name":"Maastricht Aachen Airport","tz":"Europe\/Amsterdam","country":"NL","icao":"EHBK"},{"lat":"53.42129898","lng":"-6.270070","name":"Dublin Airport","tz":"Europe\/Dublin","country":"IE","icao":"EIDW"},{"lat":"55.74029922","lng":"9.151780","name":"Billund Airport","tz":"Europe\/Copenhagen","country":"DK","icao":"EKBI"},{"lat":"54.96440125","lng":"9.791730","name":"Sonderborg Airport","tz":"Europe\/Copenhagen","country":"DK","icao":"EKSB"},{"lat":"60.29339981","lng":"5.218140","name":"Bergen Airport Flesland","tz":"Europe\/Oslo","country":"NO","icao":"ENBR"},{"lat":"58.20420074","lng":"8.085370","name":"Kristiansand Airport","tz":"Europe\/Oslo","country":"NO","icao":"ENCN"},{"lat":"60.19390106","lng":"11.100400","name":"Oslo Gardermoen Airport","tz":"Europe\/Oslo","country":"NO","icao":"ENGM"},{"lat":"63.11180115","lng":"7.824520","name":"Kristiansund Airport Kvernberget","tz":"Europe\/Oslo","country":"NO","icao":"ENKB"},{"lat":"58.87670136","lng":"5.637780","name":"Stavanger Airport Sola","tz":"Europe\/Oslo","country":"NO","icao":"ENZV"},{"lat":"50.47430038","lng":"19.080000","name":"Katowice International Airport","tz":"Europe\/Warsaw","country":"PL","icao":"EPKT"},{"lat":"52.16569901","lng":"20.967100","name":"Warsaw Chopin Airport","tz":"Europe\/Warsaw","country":"PL","icao":"EPWA"},{"lat":"57.66279984","lng":"12.279800","name":"Gothenburg-Landvetter Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESGG"},{"lat":"57.75759888","lng":"14.068700","name":"Jonkoping Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESGJ"},{"lat":"58.31809998","lng":"12.345000","name":"Trollhattan-Vanersborg Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESGT"},{"lat":"55.53630536","lng":"13.376198","name":"Malmo Sturup Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESMS"},{"lat":"65.54380035","lng":"22.122000","name":"Lulea Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESPA"},{"lat":"59.65190125","lng":"17.918600","name":"Stockholm-Arlanda Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESSA"},{"lat":"59.35440063","lng":"17.941700","name":"Stockholm-Bromma Airport","tz":"Europe\/Stockholm","country":"SE","icao":"ESSB"},{"lat":"54.63410187","lng":"25.285801","name":"Vilnius International Airport","tz":"Europe\/Vilnius","country":"LT","icao":"EYVI"},{"lat":"27.93190002","lng":"-15.386600","name":"Gran Canaria Airport","tz":"Atlantic\/Canary","country":"ES","icao":"GCLP"},{"lat":"28.04450035","lng":"-16.572500","name":"Tenerife South Airport","tz":"Atlantic\/Canary","country":"ES","icao":"GCTS"},{"lat":"28.48270035","lng":"-16.341499","name":"Tenerife Norte Airport","tz":"Atlantic\/Canary","country":"ES","icao":"GCXO"},{"lat":"35.27980042","lng":"-2.956260","name":"Melilla Airport","tz":"Africa\/Ceuta","country":"ES","icao":"GEML"},{"lat":"33.36750031","lng":"-7.589970","name":"Mohammed V International Airport","tz":"Africa\/Casablanca","country":"MA","icao":"GMMN"},{"lat":"20.93309975","lng":"-17.030001","name":"Nouadhibou International Airport","tz":"Africa\/Nouakchott","country":"MR","icao":"GQPP"},{"lat":"42.06779861","lng":"24.850800","name":"Plovdiv International Airport","tz":"Europe\/Sofia","country":"BG","icao":"LBPD"},{"lat":"45.74290085","lng":"16.068800","name":"Zagreb Airport","tz":"Europe\/Zagreb","country":"HR","icao":"LDZA"},{"lat":"38.94850159","lng":"-1.863520","name":"Albacete-Los Llanos Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEAB"},{"lat":"38.28219986","lng":"-0.558156","name":"Alicante International Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEAL"},{"lat":"43.56359863","lng":"-6.034620","name":"Asturias Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEAS"},{"lat":"41.29710007","lng":"2.078460","name":"Barcelona International Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEBL"},{"lat":"43.30210114","lng":"-8.377260","name":"A Coruna Airport","tz":"Europe\/Madrid","country":"ES","icao":"LECO"},{"lat":"41.90100098","lng":"2.760550","name":"Girona Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEGE"},{"lat":"38.87289810","lng":"1.373120","name":"Ibiza Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEIB"},{"lat":"36.74459839","lng":"-6.060110","name":"Jerez Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEJR"},{"lat":"41.52090073","lng":"2.105080","name":"Sabadell Airport","tz":"Europe\/Madrid","country":"ES","icao":"LELL"},{"lat":"40.49360000","lng":"-3.566760","name":"Madrid Barajas International Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEMD"},{"lat":"36.67490005","lng":"-4.499110","name":"Malaga Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEMG"},{"lat":"39.86259842","lng":"4.218650","name":"Menorca Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEMH"},{"lat":"39.55170059","lng":"2.738810","name":"Palma De Mallorca Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEPA"},{"lat":"42.77000046","lng":"-1.646330","name":"Pamplona Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEPP"},{"lat":"41.14739990","lng":"1.167170","name":"Reus Air Base","tz":"Europe\/Madrid","country":"ES","icao":"LERS"},{"lat":"39.48929977","lng":"-0.481625","name":"Valencia Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEVC"},{"lat":"42.88280106","lng":"-2.724470","name":"Vitoria\/Foronda Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEVT"},{"lat":"41.66619873","lng":"-1.041550","name":"Zaragoza Air Base","tz":"Europe\/Madrid","country":"ES","icao":"LEZG"},{"lat":"37.41799927","lng":"-5.893110","name":"Sevilla Airport","tz":"Europe\/Madrid","country":"ES","icao":"LEZL"},{"lat":"44.82830048","lng":"-0.715556","name":"Bordeaux-Merignac (BA 106) Airport","tz":"Europe\/Paris","country":"FR","icao":"LFBD"},{"lat":"43.54560089","lng":"1.367500","name":"Toulouse-Francazal (BA 101) Air Base","tz":"Europe\/Paris","country":"FR","icao":"LFBF"},{"lat":"43.62910080","lng":"1.363820","name":"Toulouse-Blagnac Airport","tz":"Europe\/Paris","country":"FR","icao":"LFBO"},{"lat":"47.56029892","lng":"-0.312222","name":"Angers-Loire Airport","tz":"Europe\/Paris","country":"FR","icao":"LFJR"},{"lat":"43.43927192","lng":"5.221424","name":"Marseille Provence Airport","tz":"Europe\/Paris","country":"FR","icao":"LFML"},{"lat":"43.65840149","lng":"7.215870","name":"Nice-Cote d'Azur Airport","tz":"Europe\/Paris","country":"FR","icao":"LFMN"},{"lat":"48.96939850","lng":"2.441390","name":"Paris-Le Bourget Airport","tz":"Europe\/Paris","country":"FR","icao":"LFPB"},{"lat":"49.01279831","lng":"2.550000","name":"Charles de Gaulle International Airport","tz":"Europe\/Paris","country":"FR","icao":"LFPG"},{"lat":"47.43690109","lng":"19.255600","name":"Budapest Listz Ferenc international Airport","tz":"Europe\/Budapest","country":"HU","icao":"LHBP"},{"lat":"37.46680069","lng":"15.066400","name":"Catania \/ Fontanarossa Airport","tz":"Europe\/Rome","country":"IT","icao":"LICC"},{"lat":"35.49789810","lng":"12.618100","name":"Lampedusa Airport","tz":"Europe\/Rome","country":"IT","icao":"LICD"},{"lat":"36.81650162","lng":"11.968900","name":"Pantelleria Airport","tz":"Europe\/Rome","country":"IT","icao":"LICG"},{"lat":"38.17599869","lng":"13.091000","name":"Palermo \/ Punta Raisi Airport","tz":"Europe\/Rome","country":"IT","icao":"LICJ"},{"lat":"37.91139984","lng":"12.488000","name":"Trapani \/ Birgi Airport","tz":"Europe\/Rome","country":"IT","icao":"LICT"},{"lat":"45.64839935","lng":"12.194400","name":"Treviso \/ Sant'Angelo Airport","tz":"Europe\/Rome","country":"IT","icao":"LIPH"},{"lat":"45.50529861","lng":"12.351900","name":"Venezia \/ Tessera - Marco Polo Airport","tz":"Europe\/Rome","country":"IT","icao":"LIPZ"},{"lat":"49.69630051","lng":"18.111099","name":"Ostrava Leo\u0161 Jan\u00e1\u010dek Airport","tz":"Europe\/Prague","country":"CZ","icao":"LKMT"},{"lat":"46.99110031","lng":"15.439600","name":"Graz Airport","tz":"Europe\/Vienna","country":"AT","icao":"LOWG"},{"lat":"48.11029816","lng":"16.569700","name":"Vienna International Airport","tz":"Europe\/Vienna","country":"AT","icao":"LOWW"},{"lat":"41.24810028","lng":"-8.681390","name":"Francisco de Sa Carneiro Airport","tz":"Europe\/Lisbon","country":"PT","icao":"LPPR"},{"lat":"38.78129959","lng":"-9.135920","name":"Lisbon Portela Airport","tz":"Europe\/Lisbon","country":"PT","icao":"LPPT"},{"lat":"46.52190018","lng":"26.910299","name":"Bac\u0103u Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRBC"},{"lat":"47.65840149","lng":"23.469999","name":"Tautii Magheraus Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRBM"},{"lat":"44.50320053","lng":"26.102100","name":"B\u0103neasa International Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRBS"},{"lat":"46.78519821","lng":"23.686199","name":"Cluj-Napoca International Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRCL"},{"lat":"47.17850113","lng":"27.620600","name":"Ia\u0219i Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRIA"},{"lat":"44.57220078","lng":"26.102200","name":"Henri Coand\u0103 International Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LROP"},{"lat":"47.68750000","lng":"26.354099","name":"Suceava Stefan cel Mare Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRSV"},{"lat":"45.80989838","lng":"21.337900","name":"Timi\u0219oara Traian Vuia International Airport","tz":"Europe\/Bucharest","country":"RO","icao":"LRTR"},{"lat":"41.25450134","lng":"36.567101","name":"Samsun \u00c7ar\u015famba Airport","tz":"Europe\/Istanbul","country":"TR","icao":"LTFH"},{"lat":"41.96160126","lng":"21.621401","name":"Skopje Alexander the Great Airport","tz":"Europe\/Skopje","country":"MK","icao":"LWSK"},{"lat":"44.81840134","lng":"20.309099","name":"Belgrade Nikola Tesla Airport","tz":"Europe\/Belgrade","country":"RS","icao":"LYBE"},{"lat":"48.17020035","lng":"17.212700","name":"M. R. Stefanik Airport","tz":"Europe\/Bratislava","country":"SK","icao":"LZIB"},{"lat":"48.66310120","lng":"21.241100","name":"Kosice Airport","tz":"Europe\/Bratislava","country":"SK","icao":"LZKZ"},{"lat":"31.97270012","lng":"35.991600","name":"Amman-Marka International Airport","tz":"Asia\/Amman","country":"JO","icao":"OJAM"},{"lat":"48.35720062","lng":"35.100601","name":"Dnipropetrovsk International Airport","tz":"Europe\/Zaporozhye","country":"UA","icao":"UKDD"},{"lat":"53.88249969","lng":"28.030701","name":"Minsk International Airport","tz":"Europe\/Minsk","country":"BY","icao":"UMMS"},{"lat":"14.67111100","lng":"-17.066944","name":"Blaise Diagne International Airport","tz":"Africa\/Dakar","country":"SN","icao":"GOBD"}]', true); $icao = "EGMC"; foreach($data as $el) { if ($el['icao'] === $icao) { $result = $el; } } print_r($el['lat']);