萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> PHP 程式設計

IP 地址與長整數互轉:PHP、ASP、MSSQL、MySQL 完整對照

轉換原理

IPv4 位址 w.x.y.z 轉為無號長整數:

intIP = w × 256³ + x × 256² + y × 256 + z

PHP 內建函式 (最簡單)

<?php
$ip = '192.168.1.1';
$long = ip2long($ip);        // 3232235777 (有號整數,可能為負)
$unsigned = sprintf('%u', $long); // 3232235777 (無號字串)
$back = long2ip($long);      // 192.168.1.1
?>

ASP (VBScript) 自訂函式

' 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

MSSQL 使用者定義函式

-- 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;

MySQL 內建函式

-- IP -> 無號整數
SELECT INET_ATON('192.168.1.1');  -- 3232235777

-- 無號整數 -> IP
SELECT INET_NTOA(3232235777);     -- 192.168.1.1

應用場景

  • 資料庫儲存 IP 為 INT UNSIGNED,節省空間、利於範圍查詢 (BETWEEN)。
  • PHP 端用 sprintf('%u', ip2long($ip)) 取得無號值寫入 DB。
  • 查詢時 WHERE ip_int BETWEEN INET_ATON('192.168.1.0') AND INET_ATON('192.168.1.255')。
copyright © 萬盛學電腦網 all rights reserved