Coding IP

[web_master]

Hi,

 

I found that I can coding the IP, in database looks like this: N"Ix or WaS� ... how can I do this, and after decoding?

 

Thnx in advanced

[Maq]

Hi,

 

I found that I can coding the IP, in database looks like this: N"Ix or WaS� ... how can I do this, and after decoding?

 

Thnx in advanced

 

What are you trying to do exactly?

[jonsjava]

I'm not sure what you are asking

Are you asking how you can convert the IP into a long, so it's easier to sort in the database?

$ip = $_SERVER['REMOTE_ADDR'];
$long = ip2long[$ip];

[web_master]

In database IP is looks like this:

 

[jskywalker]

that's not how it looks in the database, but that's how it looks in phpMyAdmin?

[Maq]

Can you post the code that does the insert?  What data type is the column "IP" in your DB?

[Mchl]

VARBINARY or BLOB probably...

[Maq]

OP, you should be using INET_ATOM and INET_NTOA when retrieving and inserting IP addresses.