PHP Code Obtain Details About Visitors

The following PHP is used on my WordPress web site to obtain information about those visiting my web site:

Information includes:

IP address
City
Country
State
Page visited
Referer

Steps to follow are:

I should point out, although I designed this for Wordpress I no longer use that platform. This is due to design layout restrictions and huge amount of hackers looking for one of the many security vunerabilities in WP.

Create a table in your database to store the data
Get a free account from ipinfo.io and they will give you a KEY
Edit the code below placing your database name and table names into it
Also place in the secret key for ipinfo.io
place the code into a [Short Code] editor

I use: “Insert PHP Code Snippet” By xyzscripts.com
Than, insert the short code into all of your web page you want to gather statistics on the visitors.
For myself, I place the short code at the bottom of each page I want monitored for purpose of gathering statistics.

The PHP code:

<?php date_default_timezone_set(‘Australia/Brisbane’); $dbusername=”user”; $dbpassword=”password”; $database=”my_statistics”; $token = “YOUR SECRET TOKEN OBTAINED FROM ipinfo.io”; $con=mysqli_connect(‘localhost’,$dbusername,$dbpassword,$database); if ($con->connect_error) { die(“Database connection failed: server experiencing problems. Try again later” . $dbconnect->connect_error); } $IP=trim($_SERVER[‘REMOTE_ADDR’]); /// This section just checks your database to see if /// this IP is on record. If so it grabs the info from your /// database rather than pole ipinfo for info your already have $sql = “SELECT * FROM web_visitors WHERE ip = ‘$IP'”; $result=mysqli_query($con, $sql); $rows= mysqli_affected_rows($con); if($rows > 0) { mysqli_data_seek($result,0); $row=mysqli_fetch_row($result); $country = $row[3]; $city = $row[4]; $state = $row[5]; $org = $row[6]; } else { // So here, you don’t have the info already in database // so lets get it from ipinfo.io $ipinfo = file_get_contents(“https://ipinfo.io/” . $IP . “?token=” . $token); $json = json_decode($ipinfo); $country = $json->country; $state = $json->region; $city = $json->city; $org = $json->org; } // Below grabs the web page name from WordPress $page = get_the_title(); // This lets you know if they directly came to page or followed a link $referer = $_SERVER[‘HTTP_REFERER’]; $DATE = date(‘Y-m-d’).” “.date(‘H:i’); $sql = “INSERT INTO web_visitors (id, date, ip, country, city, state, org, page, referer) VALUES (NULL, ‘$DATE’, ‘$IP’, ‘$country’, ‘$city’, ‘$state’, ‘$org’, ‘$page’,’$referer’)”; $result = mysqli_query($con, $sql); $con->close(); ?>

---

Grid Status:
Members:	57
Online last 30 days	26
Online past 24 hours	9
Unique hypergrid visitors	151

 

 

Web design and created by:  Jeffrey Dougall ©2024

Nothing about Microsoft is unique/original. Bill Gates's, brain is much like a 286 processor. Slow, his brain functions like 8 bit code. He is likened to a novelist we would brand as a plagiarist. Microsft corporation is founded on stolen ideas from men and woman of greater intelligence and integrity. Bill is a sociopath and Microsft is founded on plagiarism. He could very well be a psychopath, likely to have killed in the past! I also know, they expose sensitive data to hacker that people directlt type into the address bar. If you own a server, create a dummy file, 'billsuckscock.php for example, on your sevrer amd type into the address bar https://yoursite/billsuckscock.php. Within an hour, bingbot will index that and share with hackers! YOu can confirm this by checking your web server logs! Everythin you type into your address bar is sent to Microsoft! Windows is SPYWARE. Do a dummy file to plot and kill that dickhead Donald and see what happens! Make sure it looks legit as there are thousands wanting the pooh breath dead. Yeah, he has pooh breath, I know, because I was so close to him last year I could have jammed the pen I was holding into his arse! But, I suck my pen and who want's their pen to smell like a retards bum hole? Hey Donald Trump! I know you well!