这是一项非常简单的任务.
你可以借助php来做到这一点.您可以获得有关访问您网站的客户的许多类型的信息.您可以了解IP地址,日期,时间,操作系统,浏览器,该IP地址的isp以及更多内容.你将不得不使用PHP和MySQL!
首先在mysql中创建一个表.
create_table_track.php
$server = "localhost";
$username = "username";
$password = "password";
$database = "database name";
$connId = mysql_connect($server,$username,$password) or die("Cannot connect to server");
$selectDb = mysql_select_db($database,$connId) or die("Cannot connect to database");
$result = "CREATE TABLE track(
`id` int(6) NOT NULL auto_increment,
`tm` varchar(20) NOT NULL default '',
`ref` varchar(250) NOT NULL default '',
`agent` varchar(250) NOT NULL default '',
`ip` varchar(20) NOT NULL default '',
`ip_value` int(11) NOT NULL default '0',
`domain` varchar(20) NOT NULL default '',
`tracking_page_name` varchar(10) NOT NULL default '',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ";
if (mysql_query($result))
{
print "Success in TABLE creation!......";
}
else
{
die('MSSQL error: ' . mssql_get_last_message());
}
?>'
这是获取客户信息的第一部分.
该文件将在mysql数据库中创建一个名为“track”的表.
现在要在此表中存储信息,您必须创建另一个文件.
使用example.php
// fill in your databasa data here!
$server = "localhost";
$username = "username";
$password = "password";
$database = "database name";
$connId = mysql_connect($server,$username,$password) or die("Cannot connect to server");
$selectDb = mysql_select_db($database,$connId) or die("Cannot connect to database");
$tracking_page_name="example";
$ref=$_SERVER['HTTP_REFERER'];
$agent=$_SERVER['HTTP_USER_AGENT'];
$ip=$_SERVER['REMOTE_ADDR'];
$host_name = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$strSQL = "INSERT INTO track(tm, ref, agent, ip, tracking_page_name, host_name) VALUES(curdate(),'$ref','$agent','$ip','$tracking_page_name','$host_name')";
$test=mysql_query($strSQL);
?>
现在,上述文件将从客户端计算机中提取信息并将其存储在数据库中.
现在要显示存储在数据库中的信息,我们将使用以下文件—
show track.php
$con = mysql_connect("localhost","user name","password");
mysql_select_db("database name", $con) or die( "Unable to select database");
$query="SELECT * FROM track";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
id | time | http referer | user agent | ip address | ip value | domain | tracking_page_name | Host_name |
---|
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"id");
$f2=mysql_result($result,$i,"tm");
$f3=mysql_result($result,$i,"ref");
$f4=mysql_result($result,$i,"agent");
$f5=mysql_result($result,$i,"ip");
$f6=mysql_result($result,$i,"ip_value");
$f7=mysql_result($result,$i,"domain");
$f8=mysql_result($result,$i,"tracking_page_name");
$f9=mysql_result($result,$i,"host_name");
?>
<?php echo $f1; ?> <?php echo $f2; ?> <?php echo $f3; ?> <?php echo $f4; ?> <?php echo $f5; ?> <?php echo $f6; ?> <?php echo $f7; ?> <?php echo $f8; ?> <?php echo $f9; ?>$i++;
}
?>
'