If I were to log the IP addresses of my visitors, is there a way to pull out the total no. of unique IPs (PHP)?

Question

What I mean to say is that let's suppose I were to track the IPs of all my visitors and then I wished to count how many unique visitors I had, is there a way in which PHP can handle such requests, and the mysql table such queries?

Again, if the question is not clear, maybe because I did not explain too well, can I extract all the unique IP addresses, counting one IP address only once even if it appears more than 10 times in the table, and outputting the unique IP addresses, or at least the count. Not showing the redundants, I guess.

Answer 1

You can do this using the following MySQL query.

to get the unique IP list

SELECT DISTINCT(ip_address) FROM ip_log_table ;



To get the unique count:

SELECT COUNT(DISTINCT(ip_address)) FROM ip_log_table ;

Answer 2

This actual relies upon on who manages the community. If the IP addresses belong to a school or college who owns the IP block, then they might checklist to whom and at what time an IP handle replaced into assigned.

Answer 3

if (getenv(HTTP_X_FORWARDED_FOR)) {

$pipaddress = getenv(HTTP_X_FORWARDED_FOR);

$ipaddress = getenv(REMOTE_ADDR);

echo "Your Proxy IPaddress is : ".$pipaddress. "(via $ipaddress)" ;

} else {

$ipaddress = getenv(REMOTE_ADDR);

echo "Your IP address is : $ipaddress";

}

?>