PHP GeoIP Interfacing Tutorial
Moving on from yesterday’s PHP GeoIP Primer Tutorial, if we do find …
- a “where of life” reference … it behoves us to use some inhouse iframe hosted functionalities involving …
- interfaces to Google Charts Map Chart or Geo Chart and Colour Wheel web application (where timezones can supplement with “when of life” linkages)
… and to add Language smarts so that a user can display all the languages MaxMind offers with its data, or one of the user’s choosing, now displayed in a dropdown in the h1 header element, in the changed second draft GeoIP using PHP web application you can also try below.
Previous relevant PHP GeoIP Primer Tutorial is shown below.
PHP GeoIP Primer Tutorial
Today, we wanted to enter the world of GeoIP, which, as the name suggests, is gleaning information about the “where” of life given an …
- IP address … known directly … or discernible via a …
- domain or host name
… making use of databases provided by the great MaxMind open source resource we established an account with, allowing us to download database CSV data (for our desires) that is updated on a regular basis.
Originally we thought we’d be using PHP to host Python …
# getting us, on AlmaLinux, installing via ...
$ dnf list *geo*ip*
$ dnf install python3-geoip2
$ pip install python-geoip
$ pip install python-geoip-geolite2
$ pip3 install maxminddb
$ pip3 install maxminddb-geolite2
… and then register with MaxMind after this, to help make this solution happen, but ended up combining the (just) PHP supervision of …
- ping … means (via PHP shell_exec), as required, to derive an IP address from a host or domain name … then …
- PHP … means by which MaxMind CSV files are scoured to link IP address to geodata of interest, to derived City and Country of interest information
… via a first draft …
<?php
// geoip_hostname.php
// RJM Programming
// September, 2024
// Thanks to GeoIP
$city='';
$country='';
$state='';
$ccode='';
$tzplace='';
$continent='';
$newhname='';
$preresults='';
$results='';
$hname='';
$via='';
if (isset($_GET['via']) || isset($_POST['via'])) {
$via='' . (isset($_GET['via']) ? str_replace('+',' ',urldecode($_GET['via'])) : '') . (isset($_POST['via']) ? str_replace('+',' ',urldecode($_POST['via'])) : '');
}
if (isset($_GET['hostname']) || isset($_POST['hostname'])) {
$hname='' . (isset($_GET['hostname']) ? str_replace('+',' ',urldecode($_GET['hostname'])) : '') . (isset($_POST['hostname']) ? str_replace('+',' ',urldecode($_POST['hostname'])) : '');
if ($via == $hname) { $via=''; }
}
if (trim($hname) != '') {
if (substr(trim($hname),0,1) < '0' || substr(trim($hname),0,1) > '9') {
if (strpos($hname, '//') === false) {
$hname='http://' . $hname;
} else if (strpos($hname, ':') === false) {
$hname='http:' . $hname;
}
//$bigcont=file_get_contents($_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . 'ip_example.py');
//file_put_contents('/tmp/ip_example_ours.py', str_replace(explode("'", explode("url = '", $bigcont)[1])[0], $hname, $bigcont));
//echo '/usr/bin/python ' . $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . 'test_geoip.py --hostname=' . $hname;
//exit;
if (1 == 1) {
$results=shell_exec('ping -c 4 ' . str_replace('http://','',$hname));
} else {
$results=shell_exec('/usr/bin/python ' . $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . 'test_geoip.py --hostname=' . str_replace('http://','',$hname));
}
if (strpos($results, 'PING ' . str_replace('http://','',$hname) . ' (') !== false) {
$newhname=explode(" ",explode(")",trim(explode('PING ' . str_replace('http://','',$hname) . ' (', $results)[1]))[0])[0];
$results='';
} else if (strpos($results, 'IP address:') !== false) {
$newhname=explode(" ",explode("\n",trim(explode('IP address:', $results)[1]))[0])[0];
$results='';
}
} else if ($hname != '') {
if ($via != '' && (substr(trim($via),0,1) < '0' || substr(trim($via),0,1) > '9')) {
$preresults='Looking up ' . $via . " ( " . $hname . " ) ";
} else {
$preresults='Looking up ' . $hname;
}
$gnames=',';
foreach (glob('/tmp/GeoLite2-City-CSV_20240920/GeoLite2-City-Blocks-IP*.csv') as $fname) {
$fgc='';
if (1 == 1) {
$fgc="\n" . shell_exec('fgrep "' . $hname . '/" ' . $fname) . "\n";
} else {
$fgc="\n" . file_get_contents($fname) . "\n";
}
$listis="\n" . $fgc . "\n";
if (strpos($listis, "\n" . $hname . "/") !== false) {
$lis=explode("\n" . $hname . "/", $listis);
for ($ii=1; $ii<sizeof($lis); $ii++) {
$cols=explode(',',$lis[$ii]);
if ($cols[1] != '') {
if (strpos($gnames, ',' . $cols[1] . ',') === false) {
$gnames.=$cols[1] . ',';
}
}
}
}
}
if ($gnames != ',') {
$garr=explode(',', substr($gnames,1,(-2 + strlen($gnames))));
foreach (glob('/tmp/GeoLite2-City-CSV_20240920/GeoLite2-City-Locations-*.csv') as $fname) {
for ($jj=0; $jj<sizeof($garr); $jj++) {
$fgc='';
if (1 == 1) {
$fgc="\n" . shell_exec('fgrep "' . $garr[$jj] . '," ' . $fname) . "\n";
} else {
$fgc="\n" . file_get_contents($fname) . "\n";
}
$listis="\n" . $fgc . "\n";
if (strpos($listis, "\n" . $garr[$jj] . ",") !== false) {
$lis=explode("\n" . $garr[$jj] . ",", $listis);
for ($ii=1; $ii<sizeof($lis); $ii++) {
$cols=explode(',',$lis[$ii]);
if ($cols[3] != '') {
if ($ccode == '') { $ccode='<table border=1 style=width:80%;><tr><td>'; }
$ccode.=' ' . str_replace('"','',$cols[3]) . '</td><td>';
}
if ($cols[4] != '') {
if ($country == '') { $country='<table border=1 style=width:80%;><tr><td>'; }
$country.=' ' . str_replace('"','',$cols[4]) . '</td><td>';
}
if ($cols[9] != '') {
if ($city == '') { $city='<table border=1 style=width:80%;><tr><td>'; }
$city.=' ' . str_replace('"','',$cols[9]) . '</td><td>';
}
if ($cols[6] != '') {
if ($state == '') { $state='<table border=1 style=width:80%;><tr><td>'; }
$state.=' ' . str_replace('"','',$cols[6]) . '</td><td>';
}
if ($cols[11] != '') {
if ($tzplace == '') { $tzplace='<table border=1 style=width:80%;><tr><td>'; }
$tzplace.=str_replace(' NA',' ',' ' . str_replace('"','',$cols[1])) . '</td><td>';
}
if ($cols[2] != '') {
if ($continent == '') { $continent='<table border=1 style=width:80%;><tr><td>'; }
$continent.=' ' . str_replace('"','',$cols[2]) . '</td><td>';
}
}
}
}
$results="<br><br>City: " . ($city == '' ? $city : $city . '</td></tr></table>') . "\nState: " . ($state == '' ? $state : $state . '</td></tr></table>') . "\nCountry: " . ($country == '' ? $country : $country . '</td></tr></table>') . "\nCountry Code: " . ($ccode == '' ? $ccode : $ccode . '</td></tr></table>') . "\nContinent: " . ($continent == '' ? $continent : $continent . '</td></tr></table>') . "\nTimezone: " . ($tzplace == '' ? $tzplace : $tzplace . '</td></tr></table>') . "<br><br>";
}
}
}
}
echo "<html>
<head>
<title>Hostname Lookup geoip_hostname.php - RJM Programming - September, 2024</title>
</head>
<body onload=\" if (document.getElementById('hostname').value != '') { setTimeout(function() { document.getElementById('blook').click(); }, 2000); } \">
<h1>Hostname Lookup</h1>
<h3>RJM Programming - September, 2024 ... thanks to <a target=_blank title=MaxMind href='//www.maxmind.com/'>MaxMind</a></h3>
<div id=results>" . $preresults . str_replace("\n","<br>",$results) . "</div><br><br>
<form method=POST action=./geoip_hostname.php>
<input style=width:80%; type=text name=hostname id=hostname placeholder='Enter host name or domain name or host IP address to show information regarding ...' value='" . $newhname . "'></input><br><br>
<input type=hidden name=via id=via value='" . $hname . "'></input>
<input type=submit id=blook value=Lookup></input>
</form>
</body>
</html>";
exit;
?>
… in a first draft GeoIP using PHP web application you can also try below …
If this was interesting you may be interested in this too.
If this was interesting you may be interested in this too.
