70 ¹ø ±ÛÀÇ ´äÀå±Û: [MYSQL] INET_ATON(), INET_NTOA() |
±Û¾´ÀÌ: »êÀÌ
[ȨÆäÀÌÁö]
|
±Û¾´³¯: 2004³â 01¿ù 24ÀÏ 01:21:40 Åä(»õº®) |
Á¶È¸: 4782 |
INET_ATON(): // Address TO Number
INET_NTOA(); // Number TO Address
number ÇüÅ·ΠDB ¿¡ ÀúÀåµÇ¾î ÀÖÀ» °æ¿ì
UPDATE table SET
ipto = INET_NTOA
( ipfrom + INET_ATON('255.255.255.255') - ipto ),
ipfrom = INET_NTOA(ipfrom)
;
*ÁÖ)
ÀÌ¿Í °°ÀÌ °è»ê¼ø¼»ó ipto À» ¸ÕÀú update ÇؾßÇÔ
------------------------
½ÃÀÛÁÖ¼Ò¿Í ¸¶Áö¸·ÁÖ¼Ò¸¦ ¾Ë°í ÀÖÀ» °æ¿ì ³Ý¸Å½ºÅ© °è»ê
*°è»ê¹æ¹ý)
256 - ( ¸¶Áö¸·ÁÖ¼Ò + 1 - ½ÃÀÛÁÖ¼Ò)
= ½ÃÀÛÁÖ¼Ò + (256 - ¸¶Áö¸·ÁÖ¼Ò - 1)
= ½ÃÀÛÁÖ¼Ò + (255 - ¸¶Áö¸·ÁÖ¼Ò)
or
/32 - bit( ¸¶Áö¸·ÁÖ¼Ò + 1 - ½ÃÀÛÁÖ¼Ò)
¿¹)
- ½ÃÀÛ ÁÖ¼Ò : 211.36.160.0
- ¸¶Áö¸·ÁÖ¼Ò : 211.36.163.255
SQL)
SELECT INET_NTOA
(
INET_ATON('211.36.160.0')
+
INET_ATON('255.255.255.255')
-
INET_ATON('211.36.163.255')
);
// °á°ú 255.255.252.0
or
SELECT INET_NTOA
(
0xffffffff
^
INET_ATON('211.36.160.0')
^
INET_ATON('211.36.163.255')
);
http://phpschool.com/bbs2/inc_view.html?id=10144&code=tnt2
PHP °æ¿ì
function inet_aton($ipaddr)
{
return sprintf('%u',ip2long($ipaddr));
}
function inet_ntoa($base)
{
return long2ip($base);
}
function is_subnet($some)
{
if(preg_match('/^[\d]+\.[\d]+\.[\d]+\.[\d]+$/',$some))
{
$some = sprintf('%u',ip2long($some));
}
$dec = abs($some);
$bits = decbin($dec);
return (boolean)preg_match('/^[1]+[0]*$/',$bits);
}
|
ÀÌÀü±Û : [³×Æ®¿öÅ©] °£´ÜÇÑ °è»ê¹æ¹ý
´ÙÀ½±Û : [PHP/MP3] url streaming
|
from 61.254.130.225
JS(Redhands)Board 0.4 +@
|
|