Hello can you explain how edit the airports via using php my admin I have same issues I need to update some airport ıcao code.
Hello,
First in PhpMyAdmin ( i guess you have access to your database of your virtual airlines installation.
you need to know the organization of the airports table.
If you need to update a table, i suggest you export the airports table, and the airport frequencies table to an SQL file.
basically a table has columns and fields, columns stores the data in it, and the fields is where the data resides.
In your PhPmyadmin, there is an option to export tables.
then, you need to locate 3 things in the (airport) table: the ID( which appears to be the primary key), the column ident ( where the ICAO code is)
In the sql part of your PHPmyadmin, execute the below query
SELECT * FROM `airports` WHERE ident ='put here the ICAO code you want to update'
once you have the result, you see data for the airport.
you can then, update the data in entering anything you want with this query.
In order not to do mistakes, i suggest you to update each field at time.
the airports table has the below columns.
ID, ident,name, latitude_deg, longitude_deg, elevation_ft, continent,iso_country,municipality,scheduled_services,gps_code,iata_code,local_code,home_link,wikipedia_link,keywords
update airports set (the name of the field you want to update) where ( the field that will identify the airport, and not another one)
basically speaking if you want to update the airport of Johannesburg in south africa which change from FAJS to FAOR, all you need is to locate the old airport
select * from airports where ident='FAJS'
You get
2792 FAJS large_airport, Jan smuts International Airport, -26.1392002106, 28.2460002899, 5558, AF, ZA, ZA-GT, Johannesburg, yes FFAJS JNB
http://www.acsa.co.za/home.asp?pid=228http://en.wikipedia.org/wiki/OR_Tambo_Internationa... Jan smuts International,Airport
Johannesburg I
if you want to update the ICAO with the new code which is FAOR, or and any other field:
type the below query.
update airports set ident='FAOR' where iata_code='JNB'
update airports set name='OR Tambo International Airport' where iata_code='JNB'
update airports set gps_code='FAOR' where iata_code='JNB'
do like that to update any field you want, by making sure you relate to the record by a single information, here iata_code='JNB'
you done
RFK676,
CEO of all African airways
