perl CGI in General :: Programming

perl
mysql (3)
perl CGI (3)

General :: Programming :: perl :: perl CGI

CGI = Common Gateway Interface, a specification for transferring information between a web server and a CGI program. Here you find code snippets for CGIs written in perl.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Perl script on web server sends Excel file to browser (5601)
perl CGI script cannot load a library (3161)
Logging IP numbers in a perl script (3461)

Featured Article

Logging IP numbers in a perl script

Question:

I need to log IP numbers of computers connecting to our web site. I want to log them into a mysql database and do some analysis. Any pointers?

Answer:

It is a good idea to convert the incoming IP number to a long integer e.g. IP 1.2.3.4 would be converted to

(((1*256)+2)*256)+3)*256+4

Then keep a mysql table with IP ranges e.g. IP1 and IP2 each of type long int. This allows you to quickly find out which range a given IP falls into. The SQL would look like this:

select company_id from company_ip_ranges where ip1 <= $ip and $ip <= ip2

This gives you optimal performance. The downside is that the mysql table will be less readable by a human.

Unless you have a lot of traffic in a weak shared hosted environment, you may as well format the ip number by padding it with 0 (zeroes).

'1.2.3.4' would be '001.002.003.004'. The perl script below will do this padding for you.

The padded IP numbers can be compared just as long ints (only slightly slower, we're comparing 15 bytes instead of 4 bytes now), so the SQL to query the table is exactly the same.

sub format_ip {
    my ($ip) = @_;
 
    $ip =~ /(.*).(.*).(.*).(.*)/;
    my $a = $1;
    my $b = $2;
    my $c = $3;
    my $d = $4;
    return substr("000$a", -3) . '.' .
           substr("000$b", -3) . '.' .
           substr("000$c", -3) . '.' .
           substr("000$d", -3);
 }

Most recent comments

2009-11-21 07:45:01:
by OJAS
in Male Dating Scammers
on Dating scammer Josh Kelly:
@anonymous - 2009-11-20, 22:49:57
How in the world, the rest of us understand Miss Marple. What in the world are you doing here? Ask Lou Dobbs, he must also have started looking for a job!

2009-11-21 07:32:07:
by Miss Marple
in Male Dating Scammers
on Dating scammer Smith Williams:
@PT

Im glad to hear that you are feeling better
and try to move on with youre life...
But please take it carefully out there on the
net you never know what sharks hides in the read more

2009-11-21 06:53:19:
by Clark
in Dating Scams
on Dating scammer Rhoda Naa from Accra, Ghana:
@Wan Wan
When it´s possible for you to loggin than i will give you a good tip on your delphi private communicator.

2009-11-21 06:21:29:
by [hidden]
in Male Dating Scammers
on Dating scammer Oliver Peter Brüggert, OPG:
I am so sorry to hear of your friend's experience in Portugal. It was I that he scammed in Italy in 2008. I can't believe that he continues to do such things. And he's seemingly getting more brazen ... read more

2009-11-21 06:03:32:
by [hidden]
in Dating Scams
on Dating scammer Anastasia Mirgarodskaja:

this is the photo she is using on most dating sites

2009-11-21 04:44:12:
by anonymous
in Dating Scams
on Dating scam from Kazan, Russia - Part 1:

a woman checked out of nowhere, already demonstrated at bobspammit, which at the same time more people contact and has a style to me effective for men to cook. attention, I think it's dangerous.

2009-11-21 03:37:04:
by anonymous
in Dating Scams
on Letters and pictures of dating scammer Kathy Bisola75:
il mio nome è Miss Gloria, sono una ragazza in cerca di una persona affidabile per condividere la mia vita, mi pare non intendo disturbare con i miei sentimenti perché ho interesse su di voi e io co ... read more

2009-11-21 02:24:40:
by Georges de France
in Dating Scams
on Dating scammer Ekaterina 'Katya' from Russia:

sa pourrait être même un homme qui écrit.
Depuis hier que j'ai répondu la remarque en voici une autre.
Voici les mot c'est vrais j'ai u été a une agence mais depuis je l'ai ai envoyez ch ... read more

2009-11-21 02:04:23:
by anonymous
in Dating Scams
on Dating scammer Nancy Milman from Accra, Ghana:
ayisha_trust2008@yahoo.com

2009-11-21 02:01:40:
by 007
in Other Scams
on The UK NATIONAL LOTTERY scam:
Some more 'Scammer' crap just in!!
[START]
From The Desk Of Dr Charles Brown
Director Inter-switch Unit.
Direct Tel:+234-708 617 6591
Attention Beneficiary,
It was Resolved an ... read more


	Search: