JustinFHI Posted July 26, 2014 Report Share Posted July 26, 2014 Hi, has anyone a SQL-Table of all airports of the world? When not, can anyone help me to import all airports via PHP? Thanks! Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted July 26, 2014 Members Report Share Posted July 26, 2014 if you dont use them what is the point f inserting all ? phpvms adds them automaticly whenever you add a route http://openflights.org/data.html has a dat file that is actualy a text with comma seperated file with all the airports almost every host's phpadmin supports importing csv so you can use this one Quote Link to comment Share on other sites More sharing options...
OA01 Posted July 26, 2014 Report Share Posted July 26, 2014 I don't claim this has EVERY airport in the world, but its close! updated-03/16 airports_2.zip Quote Link to comment Share on other sites More sharing options...
JustinFHI Posted July 26, 2014 Author Report Share Posted July 26, 2014 Thank you! We need all airports for a funktion in a fuel-calc. Quote Link to comment Share on other sites More sharing options...
OmerAslan Posted March 10, 2016 Report Share Posted March 10, 2016 Hello friends, Can someone explain to me that where do i have to put this folder in my server? I couldn't find it? I am new. Please explain easy way. Thanks... Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted March 10, 2016 Moderators Report Share Posted March 10, 2016 Unzip the airports.zip file, inside it there is an airports.sql file. Open the file and go to lines 29, 30, 48 and 696 and replace `airports` with your `phpvms_tableprefix_airports`. After that, open your phpmyadmin, locate your phpVMS database and import this file. 1 Quote Link to comment Share on other sites More sharing options...
OmerAslan Posted March 10, 2016 Report Share Posted March 10, 2016 Unzip the airports.zip file, inside it there is an airports.sql file. Open the file and go to lines 29, 30, 48 and 696 and replace `airports` with your `phpvms_tableprefix_airports`. After that, open your phpmyadmin, locate your phpVMS database and import this file. Thank you. It helped me a lot. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.