<?php
function get_client_ip() {
    $ipaddress = '';
    if ($_SERVER['HTTP_CLIENT_IP'])
        $ipaddress = $_SERVER['HTTP_CLIENT_IP'];
    else if($_SERVER['HTTP_X_FORWARDED_FOR'])
        $ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
    else if($_SERVER['HTTP_X_FORWARDED'])
        $ipaddress = $_SERVER['HTTP_X_FORWARDED'];
    else if($_SERVER['HTTP_FORWARDED_FOR'])
        $ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];
    else if($_SERVER['HTTP_FORWARDED'])
        $ipaddress = $_SERVER['HTTP_FORWARDED'];
    else if($_SERVER['REMOTE_ADDR'])
        $ipaddress = $_SERVER['REMOTE_ADDR'];
    else
        $ipaddress = 'UNKNOWN';
    return $ipaddress;
}
//echo "hello world";
$date_captured = date("Y-m-d h:m:s");

$con = mysqli_connect("localhost", "john", "sql", "posts") or die("Could not connect: " . mysqli_connection_error());

$ip = get_client_ip();

$sql = "INSERT INTO ips VALUES ('$ip','$date_captured')" or die("Could not query: " . mysqli_error($con));

mysqli_query($con, $sql) or die ("Could not query " . mysqli_error($con));

mysqli_close($con);
?>