<?php
$host = "db_host";
$username = 'db_user';
$password = 'db_pass';
$database = "db_name";
$ip = $_SERVER['REMOTE_ADDR'];
$browser = $_SERVER['HTTP_USER_AGENT'];
$date = date("F j, Y, g:i a");
$fhost = gethostbyaddr($ip);
$host = preg_replace("/^[^.]+./", "", $fullhost);
$url = “http” . ((!empty($_SERVER['HTTPS'])) ? “s” : “”) . “
$connect = mysql_connect($host,$username,$pwd) or die("Connection to database failed.");
mysql_select_db($database, $connect);
mysql_query("INSERT INTO table_name (column1, column2, column3, column4, column5) VALUES ('$ip', '$browser', '$date', '$host', '$url')");
mysql_close();
?>