1.3 KiB
1.3 KiB
Distance Finder
PHP script allowing users to find the air distance between cities. Uses information from Google if data not found in local database.
License
None, yet. I'll have to come up with something.
Installation
Change the following settings in bootstrap.php:
DB_HOST = The host on which your MySQL database is running. Usually localhost.
DB_NAME = The name of your MySQL database.
DB_USER = The user name for your MySQL database.
DB_PASSWORD = The corresponding password.
CSVFILE = The file you want to import to the database. Has to be in the
following format: City name, Country code, State code, Population,
Latitude, Longitude. Can be an empty file. Make sure this file exists
in the same folder as the install.php
Then go to http://yoursite.com/[subdirectory]/install.php and follow the instructions. Depending on the size of the CSV file you are importing into the database, this might take a while.
When the installation has finished, you might want to remove or rename install.php.
Troubleshooting
If you keep getting empty files when trying to download the distance list, make sure that the web server has permissions to write in the folder (e.g. chown www-data:www-data)