1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

<?php
require_once "configure.php";

// Expires in the past
header("Expires: Mon, 26 Jul 1990 05:00:00 GMT");
// Always modified
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
// HTTP/1.1
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
// HTTP/1.0
header("Pragma: no-cache");

preg_match("/^[a-zA-Z\-]*/", $_SERVER['HTTP_ACCEPT_LANGUAGE'], $language);
// $_SESSION['_tracking'] = $_SESSION['_tracking'] ?: session_id();

if(true){
    $sql = "INSERT into raw (
                createdate, docdate,
                tracking_code, url, ip_address, browser_user_agent, json_val, session
            ) VALUES (
                NOW(), NOW(),
                :tracking_code, :url, :ip_address, :browser_user_agent, :json_val, :session
            )";
    $sql_param = array(
            'tracking_code'         => $_REQUEST['tracking_code'],
            'url'                     => $_REQUEST['url'] ?: $_SERVER['HTTP_REFERER'],
            'ip_address'            => getRealIpAddr(),
            'browser_user_agent'     => $_REQUEST['browser_user_agent'] ?: $_SERVER['HTTP_USER_AGENT'],
            'json_val'                 => json_encode($_REQUEST),
            'session'                 => session_id(),
        );

    bind_pdo($sql, $sql_param, "insert");
}