i have ip's stored in mysql in binary(16) format
in phpmyadmin, it looks like this:
4c44b817
how can i convert it to readable ip string ?
Thanks !!
3
-
if its hexadecimal, convert to decimal using echo hexdec('4c44b817');Muhammed– Muhammed2016-02-28 22:00:45 +00:00Commented Feb 28, 2016 at 22:00
-
i already tryed this, but the result is just "13"user5448454– user54484542016-02-28 22:08:58 +00:00Commented Feb 28, 2016 at 22:08
-
for me its: 1279571991. What database/table are we talking about?Muhammed– Muhammed2016-02-28 22:09:38 +00:00Commented Feb 28, 2016 at 22:09
Add a comment
|
1 Answer
MySQL has INET_NTOA() function that converts numeric IPv4 address representations to the dotted-quad strings, e.g.:
mysql> SELECT INET_NTOA(0x4c44b817);
+-----------------------+
| INET_NTOA(0x4c44b817) |
+-----------------------+
| 76.68.184.23 |
+-----------------------+
There's also INET_ATON() that works the other way around, as well as INET6_* versions of both functions that work with IPv6 addresses.
1 Comment
Muhammed
this is probably what was wanted.