CREATE TABLE `user_log` (
`id` BIGINT NOT NULL AUTO_INCREMENT,
`log_date` DATE,
`log_time` TIME,
`method` TEXT,
`page` TEXT,
`referer` TEXT,
`adress` TEXT,
`browser` TEXT,
PRIMARY KEY (`id`),
INDEX (`date`, `time`));
<?
$date = date("Y-m-d"); // Current date
$time = date("H:i:s"); // Current time
if (isset($_SERVER['REQUEST_METHOD'])) { // HTTP-method
$method = $_SERVER['REQUEST_METHOD'];
} else {
$method = "";
}
if (isset($_SERVER['REMOTE_ADDR'])) { // IP-adress
$ip_adress = $_SERVER['REMOTE_ADDR'];
} else {
$ip_adress = "";
}
if (isset($_SERVER['HTTP_USER_AGENT'])) { // Browser
$browser = $_SERVER['HTTP_USER_AGENT'];
} else {
$browser = "";
}
if (isset($_SERVER['PHP_SELF'])) { // Current page
$page = $_SERVER['PHP_SELF'];
} else {
$page = "";
}
if (isset($_SERVER['HTTP_REFERRER'])) { // Previous page
$referer = $_SERVER['HTTP_REFERRER'];
} else {
$referer = "";
}
?>
$sql="INSERT INTO user_log (log_date, log_time, method, page,
referer, adress, browser)VALUES('$date', '$time', '$method', '$ip_adress', '$browser', '$page' ,'$referer')";
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment