Ad:

PHP Discussion Thread
Marked Solved
Views: 897

Jan 14th, 2009

visitor Details

Expand Post »

hi I had a web site made in php. I need to collect visitor data ( ip address, visiting time) and store in it a database. I wrote the code like this

PHP Syntax (Toggle Plain Text)
date_default_timezone_set('Asia/Calcutta');
$time= date('D,F j, Y, H:i:s A');
$ip=getenv("REMOTE_ADDR");
mysql_query("INSERT into visitordetails (ip,time) VALUES ('$ip','$time')") or die(mysql_error());
date_default_timezone_set('Asia/Calcutta');
$time= date('D,F j, Y, H:i:s A');
$ip=getenv("REMOTE_ADDR");
mysql_query("INSERT into visitordetails (ip,time) VALUES ('$ip','$time')") or die(mysql_error());

and this is works perfectly for me.. Let me know am i need to do anything more in it ????

Similar Threads

Complete noob needs lots of help in Networking
How many visitors on average? in Promotion and Marketing Plans

rajeesh_rsn

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

265 posts
since Sep 2008

Permalink

Jan 14th, 2009

Re: visitor Details

Dont format the date until you pull the data out of the database
its much quicker to update the table or perform compares when later reporting if the data is timestamp

and

php Syntax (Toggle Plain Text)
<?php
$timestamp = time();
$timeout = $timestamp - 1500;
//Insert User
$insert = mysql_query("INSERT INTO TG_whos_online (timestamp, ip, file) VALUES('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')") or die("Error in who's online insert query!");
//Delete Users
$delete = mysql_query("DELETE FROM TG_whos_online WHERE timestamp<$timeout") or die("Error in who's online delete query!");
//Fetch Users Online
$result = mysql_query("SELECT DISTINCT ip FROM TG_whos_online") or die("Error in who's online result query!");
$users = mysql_num_rows($result);
//Show Who's Online
if($users == 1) {
print("<span>$users Person Online. &nbsp;</span>\n");
} else {
print("<span>$users People Online. &nbsp;</span>\n");
}
?>
<?php
$timestamp = time();
$timeout = $timestamp - 1500;
//Insert User
$insert = mysql_query("INSERT INTO TG_whos_online (timestamp, ip, file) VALUES('$timestamp','".$_SERVER['REMOTE_ADDR']."','".$_SERVER['PHP_SELF']."')") or die("Error in who's online insert query!");
//Delete Users
$delete = mysql_query("DELETE FROM TG_whos_online WHERE timestamp<$timeout") or die("Error in who's online delete query!");
//Fetch Users Online
$result = mysql_query("SELECT DISTINCT ip FROM TG_whos_online") or die("Error in who's online result query!");
$users = mysql_num_rows($result);
//Show Who's Online
if($users == 1) {
print("<span>$users Person Online. &nbsp;</span>\n");
} else {
print("<span>$users People Online. &nbsp;</span>\n");
}
?>

sql Syntax (Toggle Plain Text)
/*
This is the database creation SQL. You will need to create this table in your MySQL database.
*/ 
 
 CREATE TABLE `TG_whos_online` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `TIMESTAMP` INT(15) NOT NULL DEFAULT '0',
  `ip` VARCHAR(40) NOT NULL DEFAULT '',
  `file` VARCHAR(100) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`),
  KEY `ip` (`ip`),
  KEY `file` (`file`),
  KEY `TIMESTAMP` (`TIMESTAMP`)
) TYPE=MyISAM;
/*
This is the database creation SQL. You will need to create this table in your MySQL database.
*/ 
 
 CREATE TABLE `TG_whos_online` (
  `id` bigint(20) NOT NULL auto_increment,
  `timestamp` int(15) NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '',
  `file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `ip` (`ip`),
  KEY `file` (`file`),
  KEY `timestamp` (`timestamp`)
) TYPE=MyISAM;

add a visitcount column to the database

php Syntax (Toggle Plain Text)
$query = mysql_query(sprintf("select id from visitordetails where ip='%s';", $_SERVER["REMOTE_ADDR"]));
	list($id) = mysql_fetch_row($query);
	if (strlen($id)) 
		{
		if (!mysql_query(sprintf("UPDATE visitordetails SET visitcount = visitcount + 1 WHERE ip ='%s';", $_SERVER["REMOTE_ADDR"])));
		{	
		return false;
		}
		return true; 
		}
$query = mysql_query(sprintf("select id from visitordetails where ip='%s';", $_SERVER["REMOTE_ADDR"]));
	list($id) = mysql_fetch_row($query);
	if (strlen($id)) 
		{
		if (!mysql_query(sprintf("UPDATE visitordetails SET visitcount = visitcount + 1 WHERE ip ='%s';", $_SERVER["REMOTE_ADDR"])));
		{	
		return false;
		}
		return true; 
		}

and/or update the table with a last_visit column and do the same exist check to post the current timestamp to last_visit

almostbob

Reputation Points: 562

Solved Threads: 367

Posting Maven

Offline

2,970 posts
since Jan 2009

Permalink

Jan 14th, 2009

Re: visitor Details

or install the geoip library
and map the locations from the ip and crate a googlemap mashup of the ip locations

almostbob

Reputation Points: 562

Solved Threads: 367

Posting Maven

Offline

2,970 posts
since Jan 2009

Permalink

Jan 15th, 2009

Re: visitor Details

Click to Expand / Collapse Quote originally posted by almostbob ...

and/or update the table with a last_visit column and do the same exist check to post the current timestamp to last_visit

php Syntax (Toggle Plain Text)
query = mysql_query(sprintf("select id from visitordetails where ip='%s';", $_SERVER["REMOTE_ADDR"])); 
list($id) = mysql_fetch_row($query); 
if (strlen($id))  { 
if (!mysql_query(sprintf("UPDATE visitordetails SET visitcount = visitcount + 1, lastvisit='%s' WHERE ip ='%s';" ,$timestamp, $_SERVER["REMOTE_ADDR"])));
{ return false; } 
return true;
query = mysql_query(sprintf("select id from visitordetails where ip='%s';", $_SERVER["REMOTE_ADDR"])); 
list($id) = mysql_fetch_row($query); 
if (strlen($id))  { 
if (!mysql_query(sprintf("UPDATE visitordetails SET visitcount = visitcount + 1, lastvisit='%s' WHERE ip ='%s';" ,$timestamp, $_SERVER["REMOTE_ADDR"])));
{ return false; } 
return true;

Last edited by peter_budo; Jan 17th, 2009 at 6:05 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

almostbob

Reputation Points: 562

Solved Threads: 367

Posting Maven

Offline

2,970 posts
since Jan 2009

Permalink

Jan 15th, 2009

Re: visitor Details

Thank you for the kind support..

rajeesh_rsn

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

265 posts
since Sep 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: How to add amount of items in shopping cart? Need urgent help!

Next Thread in PHP Forum Timeline: please tell me what is wrong with the code

DaniWeb Message

Cancel Changes

User Name
Password