Zortin, Record who is visiting your site & where from

Record who is visiting your site & where from

Category: php

Keywords: record who is visiting your site & which link did he click, use visitors to see what sites are linking to your site

Added by: Anonymous

Usage: Copy & paste (Zortin offers codes for your Website, Blog, Profile, Myspace, Friendster, Hi5, Bebo, IMVU, Xanga, etc...)

The Code

First, you create a mySQL table (where you will save the data)
-------------------------------------------------------------------------------

Call the table 'pop'
This table should have 4 rows
row1: pop_id  (Auto increment)
row2: pop_URL (This will show which URL is bringing traffic)
row3: pop_visited (This will show what page was opened in your site)
row4: pop_IP (This will show the IP)

Place the following codes in the page you want stats for (if you want stats for all your pages, then, place it in the Menu)
------------------------------------------------------------------------------------

<?php

/////////////////////////// COLLECT DATA ///////////////////////////
$IP=GetHostByName($REMOTE_ADDR);
$get_url = $_SERVER['REQUEST_URI'];
$from_page = $HTTP_REFERER;
/////////////////////////// COLLECT DATA ///////////////////////////

/////////////////////////// CONNECT TO MYSQL ///////////////////////////
$con=mysql_connect("connection", "username", "password"); 
mysql_select_db("database", $con); 
/////////////////////////// CONNECT TO MYSQL ///////////////////////////

/////////////////////////// REMOVE YOUR WEBSITE FROM BEING SAVED ///////////////////////////
//// lest say your website is http://www.example.com, here is how this part should be
$findme   = 'http://www.example';
$pos = strpos($from_page, $findme);
$findme2   = 'http://example';
$pos2 = strpos($from_page, $findme2);
/////////////////////////// REMOVE YOUR WEBSITE FROM BEING SAVED ///////////////////////////

////////////////////////////////////////// RECORD TO DATABASE ///////////////////////////////////////
if ($pos === false) { ////////////////// Don't record my site1
if ($pos2 === false) { ////////////////// Don't record my site2

if($from_page){
$query="INSERT INTO pop (pop_URL, pop_visited, pop_IP) VALUES ('$from_page', '$get_url', '$IP')";
$result=mysql_query($query) or die("error:".mysql_error()); 
}

} ////////////////// Don't record my site2
} //////////////////// Don't record my site1
///////////////////////////////////////// RECORD TO DATABASE ////////////////////////////////////

To echo the data, you simply use the following code
------------------------------------------------------------------------------

<?php

$con=mysql_connect("connection", "username", "password"); 
mysql_select_db("database", $con);

$result = mysql_query("SELECT * FROM pop ORDER BY pop_id DESC LIMIT 1000; ");
$no_of_results=mysql_num_rows($result);

while($row = mysql_fetch_array($result)) {

$get_id = $row[pop_id];
$get_URL = $row[pop_URL];
$get_visited = $row[pop_visited];
$get_IP = $row[pop_IP];

//////////// This part can make your IP black colored, so you know it is you who visted
if($get_IP == 'PUT_YOUR_IP'){ 
$color = '000000';
}else{
$color = 'FF0000';
}
//////////// This part can make your IP black colored, so you know it is you who visted

print"TO ";
print"<A href=\"$get_visited\" target=\"_blank\">$get_visited</A>";
print" ";
print"FR ";
print"<A href=\"$get_URL\" target=\"_blank\">$get_URL</A>";
print" ($get_IP)";
print"<hr noshade size=\"2\" width=\"100%\" color=\"#C0C0C0\" id=\"Line\">";
}

Explenation

This little php code is very efficient in showing you who is coming to your site, and which place did he come from, which means, where did he click to come to your site
It will show you who is linking to your site or who is coming to your site
This is also very efficient because some website may suck your bandwidth
This code requires MySQL TABLE (where you will save the data recorded)

« Back to PHP category