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 CGI script cannot load a library (3495)
Perl script on web server sends Excel file to browser (6224)
Logging IP numbers in a perl script (3789)

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

2010-03-20 11:01:19:
by [hidden]
in Dating Scams
on Dating scammer Kim/ Brittany from Lagos, Nigeria:
I received the email about Jessica Awa, and I replied to her and she said something about the money that she wanted me to help her transfer so she can come to my country to study.
I dunno who she ... read more

2010-03-20 10:32:30:
by anonymous
in Dating Scams
on Is this Russian girl scamming me? How to recognize scammers:

One last photo of Olga Malinkina of Cheboksary. This one is different from the others so now she has 3 different looks. Please advise if you knoiw this girl. She has sent me a letter asking for mone ... read more

2010-03-20 10:22:23:
by anonymous
in Dating Scams
on Dating scammer Ekaterina:
I got these same messages!!! I actually can't believe it. I wonder how many more people have been sent the same thing? I traced the ip address and apparently the person resides somewhere in the US.

2010-03-20 09:48:48:
by ww
in Dating Scams
on Dating scammer Sarah Sarpong:

@Todd aka WTF

2010-03-20 08:53:09:
by mcmillen45
in Dating Scams
on Dating scammer Osai Williams from Ghana:

Here is a new one from this scammer claiming to be Bojisah Hamis Taufic. It is a passport with Dawson Millers face overtop someone elses picture. Very easy to see the addition

2010-03-20 08:46:36:
by [hidden]
in Dating Scams
on Dating scammer Tatyana Zaiceva:
Waarschijnlijk een mooie afsluiter ... read more

2010-03-20 07:55:55:
by anonymous
in Dating Scams
on Dating scammer Sandra Da_Rocha from Accra/Ghana:

tenderhearted500@yahoo.com she go now with this name boys watch out boyes she isd in nigeria she say for here sick mother boyhahahahahaha haahahhahahahhahahahahah she do this foto shoot in nigera she ... read more

2010-03-20 06:58:18:
by auschook
in Male Dating Scammers
on Dating scammer Michael brown :
ALL THESE SCAMMERS HAVE ONE THING IN COMMON .....THEY HAVE BLOODY TERRIBLE GRAMMAR

2010-03-20 06:12:29:
by anonymous
in Male Dating Scammers
on Dating scammer Brian Cole:
Courtney Roy from 65 Byslips Road South Bedforshire or Bedfordshire Dunstable UK from sight MATE1

Be aware she is a scammer and uses Brian Jones as the Customs agent to call and demand the su ... read more

2010-03-20 04:57:45:
by auschook
in Male Dating Scammers
on Dating scammer Kenny Williams:
This is a pic he uses of his 13 year old son Derrick


	Search: