IPv4 位址 w.x.y.z 轉為無號長整數:
intIP = w × 256³ + x × 256² + y × 256 + z
<?php
$ip = '192.168.1.1';
$long = ip2long($ip); // 3232235777 (有號整數,可能為負)
$unsigned = sprintf('%u', $long); // 3232235777 (無號字串)
$back = long2ip($long); // 192.168.1.1
?>
' IP -> Long
Function IP2Num(ByVal strIP)
Dim nIP, nIndex, arrIP
arrIP = Split(strIP, ".", 4)
For nIndex = 0 To 3
If nIndex <> 3 Then arrIP(nIndex) = arrIP(nIndex) * (256 ^ (3 - nIndex))
nIP = nIP + arrIP(nIndex)
Next
IP2Num = nIP
End Function
' Long -> IP
Function Num2IP(ByVal nIP)
Dim strIP, nTemp, nIndex
For nIndex = 3 To 0 Step -1
nTemp = Int(nIP / (256 ^ nIndex))
strIP = strIP & nTemp & "."
nIP = nIP - (nTemp * (256 ^ nIndex))
Next
Num2IP = Left(strIP, Len(strIP) - 1)
End Function
-- IP -> BIGINT
CREATE FUNCTION dbo.ipToInt(@strIp VARCHAR(15))
RETURNS BIGINT
AS BEGIN
DECLARE @nIp BIGINT = 0;
SELECT @nIp = @nIp + LEFT(@strIp, CHARINDEX('.', @strIp+'.')-1) * Id
FROM (
SELECT CAST(1*256*256*256 AS BIGINT) AS Id
UNION ALL SELECT 1*256*256
UNION ALL SELECT 1*256
UNION ALL SELECT 1
) AS T;
RETURN @nIp;
END;
-- BIGINT -> IP
CREATE FUNCTION dbo.intToIP(@nIp BIGINT)
RETURNS VARCHAR(15)
AS BEGIN
DECLARE @strIp VARCHAR(15) = '';
SELECT @strIp = @strIp + '.' + CAST(@nIp/ID AS VARCHAR), @nIp = @nIp%ID
FROM (
SELECT CAST(1*256*256*256 AS BIGINT) AS ID
UNION ALL SELECT 1*256*256
UNION ALL SELECT 1*256
UNION ALL SELECT 1
) AS T;
RETURN STUFF(@strIp, 1, 1, '');
END;
-- IP -> 無號整數
SELECT INET_ATON('192.168.1.1'); -- 3232235777
-- 無號整數 -> IP
SELECT INET_NTOA(3232235777); -- 192.168.1.1
INT UNSIGNED,節省空間、利於範圍查詢 (BETWEEN)。sprintf('%u', ip2long($ip)) 取得無號值寫入 DB。WHERE ip_int BETWEEN INET_ATON('192.168.1.0') AND INET_ATON('192.168.1.255')。