如何收集有关我网站访问者的信息？ [英] How do I collect information about my website's visitors?
问题描述
有没有办法存储：
- 访客的IP地址
- 什么时间访问者访问了我的网站
- 他们访问了多少次
我知道有办法这样做没有 PHP，只需使用Javascript和一些文本文件。
I know there is a way to do this without PHP, just with Javascript and some text files.
如何在PHP中执行此操作？
How it would I do this in PHP?
推荐答案
这是一项非常简单的任务。
It's a very easy task.
你可以借助php来做到这一点。您可以获得有关访问您网站的客户的许多类型的信息。您可以了解IP地址，日期，时间，操作系统，浏览器，该IP地址的isp以及更多内容。你将不得不使用php和mysql！
You can do this with the help of php. You can get many types of information about client visiting your site. You can get to know about the ip address, date, time, operating system, browser, isp of that ip address and many more things. You will have to use php and mysql !
首先在mysql中创建一个表。
firstly create a table in mysql.
create_table_track .php
<?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的表。
现在要在此表中存储信息，您必须创建另一个文件。
This is the first part of getting the information about client. This file will create a table named "track" in mysql database. Now to store information in this table, you will have to create another file.
example.php
<html>
<?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);
?>
</html>
现在，上述文件将从客户端计算机中提取信息并将其存储在数据库中。
Now the above file will extract information from client computer and store it in the database.
现在要显示存储在数据库中的信息，我们将使用以下文件---
Now to show the information stored in database,, we wil use following file---
show track。 php
<html>
<body>
<?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();
?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">id</font></th>
<th><font face="Arial, Helvetica, sans-serif">time</font></th>
<th><font face="Arial, Helvetica, sans-serif">http referer</font></th>
<th><font face="Arial, Helvetica, sans-serif">user agent</font></th>
<th><font face="Arial, Helvetica, sans-serif">ip address</font></th>
<th><font face="Arial, Helvetica, sans-serif">ip value</font></th>
<th><font face="Arial, Helvetica, sans-serif">domain</font></th>
<th><font face="Arial, Helvetica, sans-serif">tracking_page_name</font></th>
<th><font face="Arial, Helvetica, sans-serif">Host_name</font></th>
</tr>
<?php
$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");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
</tr>
<?php
$i++;
}
?>
</body>
</html>'
这篇关于如何收集有关我网站访问者的信息？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
