As a complement of MySQL - IP To Numeric Value, here is how to convert IP to numeric value using PHP.
int ip2long ( string $ip_address )
printf(“%u\n”,?ip2long(“209.207.224.40″));?//return 3520061480.
To convert numeric value to IP:
string long2ip ( int $proper_address )
long2ip(3520061480);?//return 209.207.224.40
Because PHP’s integer type is signed, and many IP addresses will result in negative integers, you need to [...]
Archive for October, 2008
PHP - IP To Numeric Value
Saturday, October 25th 2008 Tags: convert ip to number, convert ip to numeric value, php ip to number
MySQL - IP To Numeric Value
Thursday, October 23rd 2008 Tags: convert ip to number, convert ip to numeric value, mysql ip to number
So you want to convert the ip ‘209.207.224.40′ to 3520061480 using mysql while 3520061480 comes from 209*2563 + 207*2562 + 224*256 + 40.
You can use INET_ATON(expr) function.
SELECT INET_ATON(’209.207.224.40′)
And vice-versa if you want to convert number to ip you can use INET_NTOA(expr) function.
SELECT INET_NTOA(3520061480)
- The Acrobat Reader Speed Launcher
- Remove Infoweb.net
- Display Text in MS Word Vertically
- Remove the Clear History Button in Windows XP
- MySql Error 1036 Table is Read Only
- Call to Undefined Function curl_init
- Hang When Installing Novell Netware 5
- Create Favicon for Your Website
- How To Add Or Subtract Hours From Datetime Expression
- Remove Mybrowserbar From My Browser
- samir patel in Merge Table Cells Using Javascript
- ankara hali y?k… in Call to Undefined Function curl_ini…
- SuperJet in Remove Mybrowserbar From My Browser…
- The Love in Remove Mybrowserbar From My Browser…
- ???? in Remove Mybrowserbar From My Browser…
- satyajeet in Merge Table Cells Using Javascript
- How come PR alw… in Remove Acronym or Abbr Underline In…
- Shermie in Get The Last Record from a Table
- martin in Getting The Domain Name Out Of A UR…
- rbc303 in Fireworks: Make Rounded Corner Edge…
- Fireworks: Make Rounded Corner Edges Image (4)
- Remove Mybrowserbar From My Browser (3)
- Naked Scuba Diving (2)
- Merge Table Cells Using Javascript (2)
- Check User Input Is Numeric or Character String (1)
- MySQL - Copy An Existing Table To A New Table (1)
- Getting The Domain Name Out Of A URL (1)
- Get The Last Record from a Table (1)
- Remove Acronym or Abbr Underline In Mozilla Firefox (1)
- Call to Undefined Function curl_init (1)
- Fireworks: Make Rounded Corner Edges Image
- Javascript - Get URL Parameters
- Merge Table Cells Using Javascript
- Get Domain Name From URL Using Javascript
- Javascript: Open new window containing php page
- Check User Input Is Numeric or Character String
- Remove Mybrowserbar From My Browser
- PHP - IP To Numeric Value
- PHP Create Zip file
- Exporting Data To TextFile
- convert ip to number convert ip to numeric value copy table to a new table copy table using mysql dll error dll file dll file corrupt dll not found domain name domain name from url Export Data fireworks horizontal line effect get domain from url get url parameters golfer social network import data javascript alert javascript alert method javascript dialogue box javascript get url parameter javascript load php page javascript open new window javascript open php page javascript pops up javascript prompt javascript tabbed page location href merge table cells Motion Trail Text mysql copy table mysql ip to number PC Router php compress file php create zip file php error PHP fatal error php ip to number php session how to php uploaded file rounded corner edges image url domain url domain name WinXP auto logon WinXP File Sharing zip using php