March 12, 2010

ip2long vs INET_ATON

Filed under: PHP, SQL — Tags: , , , — hoball @ 9:15 pm

Source: http://mwillis.co.uk/mysql/ip2long-vs-inet_aton/

PHP ip2long() sometimes return negative integers,
while MySQL INET_ATON() function returns only positive numbers.

Ensure PHP ip2long() returns only positive intergers:

sprintf("%u", ip2long(""));
$ip = ip2long($ip_address);
if ($ip < 0){ $ip += 4294967296; }

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: