Installing the Program

Installing the Program

Simply unpack the downloaded zip file to a subdirectory of your Document Root ("localhost").

Check that the following files are present:

cities.sql

georget.css

georget.ico

georget.js

georget.php

georget_large.png

georget_medium.png

georget_small.png

georget_small_bw.png

measure.png

timezones.sql

Let's say you've unpacked the files to the subdirectory "GPS".

Now open a browser and type in the following address:

localhost/GPS/georget.php

When run the first time, the lack of user data will prompt the program to enter the Admin mode.

Automatic Installation

First enter the details required to connect to your MySQL database. If these are correct the program will attempt to create the database Georget and the tables cities, timezones and timezone_regions.

If the database and the tables are not created at this time, you can attempt to create them again later by entering the Admin mode.

Next a set of fields can be filled out to assist with automatic reading of photo locations. For more details see Adding Special Features - Saving photo locations.

Finally you can choose any number (or all) of the time zones from the timezone database as standard time zones, and arrange them in any order.

Photo and time zone data can be changed at any time by entering Admin mode.

Manual Installation

Data tables can be imported into any MySQL database by hand (e.g. using PHPMyAdmin), if automatic installation fails for any reason.

In particular, installing the cities database may be difficult because of the file size. The database can be installed via PHPMyAdmin, or prior to installation you can run the following commando on the localhost via the MySQL GUI:

SET GLOBAL max_allowed_packet=16777216;

Another possibility is to save the following to a php file and run it in a browser:

<?php

$host = ""; // put the host name in here

$user = ""; // put the user name in here

$password = ""; // put the password in here

$mysqli = new mysqli ($host, $user, $password);

$mysqli->query ("SET GLOBAL max_allowed_packet=16777216");

$mysqli->close ();

?>

User data is written in the georget.php file. Locate the line:

# User configuration data

And the following lines should be editable.