create table page_tracking
(
    prim_key        int            primary key  auto_increment,
    user_id         int            not null,
    date_time       datetime       not null,
    request_method  varchar(10),
    http_host       varchar(250),
    request_uri     varchar(250),
    query_string    varchar(1000),
    remote_addr     varchar(30),
    remote_host     varchar(250),
    remote_port     varchar(5),
    remote_user     varchar(250),
    server_addr     varchar(30),
    server_name     varchar(250),
    server_port     varchar(5),
    server_software varchar(250),
    server_protocol varchar(250),
    document_root   varchar(250),
    http_referer    varchar(1000),
    http_user_agent varchar(1000),
    http_connection varchar(250),
    https           varchar(250),
    auth_type       varchar(250),
    auth_user       varchar(250),
    auth_pswd       varchar(250),
    script_filename varchar(250),
    path_translated varchar(250),
    path_info       varchar(250),
    request_time    varchar(250),
    get_array       varchar(5000),
    post_array      varchar(5000),
    cookies         varchar(5000)
)

            values (0, $id, CURDATE(),  
                    '$_SERVER[REQUEST_METHOD]', 
                    '$_SERVER[HTTP_HOST]', 
                    '$_SERVER[REQUEST_URI]', 
                    '$_SERVER[QUERY_STRING]', 
                    '$_SERVER[REMOTE_ADDR]',			 
                    '$_SERVER[REMOTE_HOST]', 
                    '$_SERVER[REMOTE_PORT]', 
                    '$_SERVER[REMOTE_USER]',  
                    '$_SERVER[SERVER_ADDR]',			 
                    '$_SERVER[SERVER_NAME]', 
                    '$_SERVER[SERVER_PORT]', 
                    '$_SERVER[SERVER_SOFTWARE]', 
                    '$_SERVER[SERVER_PROTOCOL]', 
                    '$_SERVER[DOCUMENT_ROOT]', 
                    '$_SERVER[HTTP_REFERER]', 
                    '$_SERVER[HTTP_USER_AGENT]', 
                    '$_SERVER[HTTP_CONNECTION]', 
                    '$_SERVER[HTTPS]', 
                    '$_SERVER[AUTH_TYPE]',			
                    '$_SERVER[PHP_AUTH_USER]', 			
                    '$_SERVER[PHP_AUTH_PW]', 			
                    '$_SERVER[SCRIPT_FILENAME]', 
                    '$_SERVER[PATH_TRANSLATED]', 
                    '$_SERVER[PATH_INFO]',
                    '$_SERVER[REQUEST_TIME]'
                    '$getArray',
                    '$postArray',
                    '$cookieArray'