This post is sponsored by PayPerPost (more…)

I was just reading the new features listing for Google Docs, and came across this line: "Spreadsheets get smarter with 2 special functions".

Perhaps it's more of a grammatical error than a spelling mistake, but I believe they were trying to say 'Spreadsheets gets smarter'. Either that or they're disappointed in it and commanding it to smarten up…

This post is sponsored by PayPerPost (more…)

So you've retrieved the visitor's IP address. If you're just logging or tracing it, that's all you need to do. However, if you want to match it to an IP location database, you can't search by the IP in the IPV4 format. It needs to be converted to its IP number equivalent (it is just more efficient to store and search between a range of numbers in database). Here are the functions in PHP, ASP, C# and VB.Net to convert and IP address from dot format to IP number format.

Each function is based on the fact that IP addresses (IPV4) are divided into 4 sub-blocks. Each sub-block has a different weight number, each powered by 256. Here's the math:

IP Number = (16777216*a) + (65536*b) + (256*c) + (d (1))
- where the IP Address = a.b.c.d

And here are the functions that implement that math:
(more…)

This post is sponsored by PayPerPost. (more…)