Storing IP as an unsigned int?

Question

I read that the best way to store IP addresses in a database is to create an Unsigned Int (10) field. How to translate IP addresses using PHP? I tried using

$this->ip = long2ip($_SERVER['REMOTE_ADDR']);

But this does not seem to work. I found a way to convert it back to an IP address using

$this->ip = sprintf("%u", ip2long($result['ip']));

How do I convert the IP address first? Should I use PHP for this? Or would it be better to integrate into a MySQL query?

Answer 1

long2ipconverts an integer to IP format and ip2longdoes the opposite.

ip2long $_SERVER['REMOTE_ADDR'] long2ip :

$long = ip2long($_SERVER['REMOTE_ADDR']);
$ip   = long2ip($long);

Answer 2

SQL-:

INSERT INTO `table`
    (`ip`)
VALUES
    INET_ATON('192.168.0.1')

:

SELECT INET_NTOA(`ip`)
    FROM `table`

Answer 3

function ip2int($ip) {
    $a = explode(".",$ip);
    return $a[0] * 256 * 256 * 256 + $a[1] * 256 * 256 + $a[2] * 256 + $a[3];
}

Answer 4

MySQL, INET_ATON (ip2long ) INET_NTOA (long2ip), PHP:

Answer 5

IP- ip2long long2ip. , .

$integer_ip = ip2long($_SERVER["REMOTE_ADDR"]); // => 1113982819
$dotted_ip  = long2ip($integer_ip);             // => "66.102.7.99"