/*****************************************************
**************HTTP://SOFTWARE.REDSHIFT.JE*************
********************FREE SOFTWARE*********************
*****************************************************/
//Configure your database settings here:
$server = "localhost";
$db_user = "manpaper_db1";
$db_pass = "blahblah";
$database = "manpaper_db1";
$table = "OnlineCounter";
$timeoutseconds = 300; //Recommended setting
//Connect
mysql_connect($server, $db_user, $db_pass);
//Fetch Time
$timestamp = time();
$timeout = $timestamp - $timeoutseconds;
$remoteADDR = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
$remoteHOST = mysql_real_escape_string($_SERVER['REMOTE_HOST']);
$httpReferer = mysql_real_escape_string($_SERVER['HTTP_REFERER']);
$phpSelf = mysql_real_escape_string($_SERVER['PHP_SELF']);
$reqeustURI = mysql_real_escape_string($_SERVER['REQUEST_URI']);
$userAgent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']);
//Insert User
$insert = mysql_db_query($database, "INSERT INTO $table (`timestamp`, `RemoteADDR`, `RemoteHOST`, `HttpReferer`, `PhpSelf`, `ReqeustURI`, `UserAgent` ) VALUES
('$timestamp', '$remoteADDR', '$remoteHOST', '$httpReferer', '$phpSelf ', '$reqeustURI', '$userAgent')") or die("Failed!");
//Delete User
//$delete = mysql_db_query($database, "DELETE FROM $table WHERE timestamp<$timeout") or die("Failed!");
?>
Ben Cohen Biography on Manpaper.com