IP tracker

Simple php script to keep track of dynamic IPs, using mysql storage.

Usage

POST index.php?site=mysite stores the visible ip of the client accessing the script, and stores it under mysite.

GET index.php?site=mysite fetches the last known ip for mysite. If no address is known nothing is returned.

Configuration

Rename config-example.php to config.php and configure the variables defined there.

$mysql_host = "";
$mysql_database = "";
$mysql_user = "";
$mysql_password = "";

The database must have a table create with the following command.

CREATE TABLE `ip` (
 `site` VARCHAR(256) CHARACTER SET ascii NOT NULL,
 `ip` BINARY(16) NOT NULL,
  PRIMARY KEY (`site`)
);