39 lines
1.3 KiB
Markdown
39 lines
1.3 KiB
Markdown
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)
|