Jacobs Bonny Grid - PHP Obtain Information about visitors

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:

A purple dot 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.

A purple dot 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:	36
Online last 30 days	12
Online past 24 hours	8
Unique hypergrid visitors	109