distancefinder/README.md

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)