<?php
include 'config.php';

$session_id = $_SESSION['session_id'];
$user_id = $_SESSION['user_id'];

function getLocationInfoByIp(){
    $client  = @$_SERVER['HTTP_CLIENT_IP'];
    $forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
    $remote  = @$_SERVER['REMOTE_ADDR'];
    $result  = array('country'=>'', 'city'=>'');
    if(filter_var($client, FILTER_VALIDATE_IP)){
        $ip = $client;
    }elseif(filter_var($forward, FILTER_VALIDATE_IP)){
        $ip = $forward;
    }else{
        $ip = $remote;
    }
    $ip_data = @json_decode(file_get_contents("http://www.geoplugin.net/json.gp?ip=".$ip));    
    if($ip_data && $ip_data->geoplugin_countryName != null){
        $result['country'] = $ip_data->geoplugin_countryCode;
        $result['city'] = $ip_data->geoplugin_city;
        $result['region'] = $ip_data->geoplugin_region;
        $result['longitude'] = $ip_data->geoplugin_longitude;
        $result['latitude'] = $ip_data->geoplugin_latitude;
    }
    // return $result;
}

$ipaddress = $_SERVER['REMOTE_ADDR'];
$page = $_SERVER['PHP_SELF'];
$referrer = $_SERVER['HTTP_REFERER'];
date_default_timezone_set('Asia/Kolkata');  
$datetime = date('Y-m-d H:i:s');;
$useragent = $_SERVER['HTTP_USER_AGENT'];

$query="INSERT INTO sp_session_tracker set session_id='$session_id',page_title='$page', refer='$referrer', user_id='$user_id', ip_address='$ipaddress',city='',region='',country='',longitude='',latitude='',browser='$useragent',date_time='$datetime'";
$sql=$db->prepare($query);
$sql->execute(); 

?>