<?php
if (array_key_exists('HTTP_X_FORWARDED_FOR', $_SERVER)) {
    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else if (array_key_exists('HTTP_CLIENT_IP', $_SERVER)) {
    $ip = $_SERVER['HTTP_CLIENT_IP'];
} else {
    $ip = $_SERVER['REMOTE_ADDR'];
}
$date = date('Y-m-d H:i:s');
$app = $_GET['app'];
$db = pg_connect("host=geob-vdb01 port=6432 dbname=stats user=stats password=st@ts");
if (!$db) {
     die("Error in connection: " . pg_last_error());
}
$sql = "INSERT INTO data.stats (login, ip, application, ddate) VALUES('anonymous', $1, $2, $3 )";
$pg_name = md5($sql);
$query_parameters = array($ip, $app, $date);
$prepared_sql = pg_prepare($db, $pg_name, $sql);
$result = pg_execute($db, $pg_name, $query_parameters);
if ($result) {
    echo 'ok';
} else {
    echo pg_last_error();
}
?>