perl CGI in General :: Web publishing

perl
mysql (3)
perl CGI (3)

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.

Logging IP numbers in a perl script (3458)
Perl script on web server sends Excel file to browser (5598)
perl CGI script cannot load a library (3160)

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-20 20:00:44:
by PT
in Male Dating Scammers
on Dating scammer Smith Williams:
Miss Marples, my goodness you must be very ill from that picture! Please get the rest you need so that you may come back here & fight the war against our enemies! :) I am doing great, and actually t ... read more

2009-11-20 19:49:47:
by anonymous
in Dating Scams
on Dating scammer Anastasiya from Medvedevo:

Hello Arturo.
I am very pleased so soon to receive your letter.
It is very pleasant, that you have not left my letter without the answer.
I have the first experience of the correspondence ... read more

2009-11-20 19:12:21:
by anonymous
in Dating Scams
on Dating scammer Natalya from Osinniki, Russia:

some more pics Elena hromihina

2009-11-20 18:49:14:
by [hidden]
in Dating Scams
on Dating scammer Natalija Dostojewski:

Hi everybody. I saw this advertisement by Kijiji, I was curious and drop a short e-mail.
Please, I would like to know more about how this 'scamming' mafia operates, what they can do to you!! Can ... read more

2009-11-20 17:14:32:
by bernie
in Dating Scams
on Dating scammer Nancy Milman from Accra, Ghana:
I KNOW OF A CYNTHIA OSHO I THINK FROM CANADA. SHE ASK ME FOR AIRFARE TO COME TO MONTREAL. I DIDNT FALL FOR THAT. I HAVE SEEN HER FACE BEFORE. I TRY TO STOP THEM ALL WITH WESTERN UNION

2009-11-20 17:14:00:
by anonymous
in Dating Scams
on Dating scammer Nadezhda Titova:
2 more names for ananstasiya illarionova are Tatyana Shepeleva or Nadezhda Basova

2009-11-20 17:13:17:
by Dirk
in Dating Scams
on Dating scammer Ekaterina Rozhentsova:

Gratuliere!

2009-11-20 16:54:54:
by [hidden]
in Other Scams
on Another dating / chat scam - USA/ Nigeria connection:

there is another from Nigeria she is a hot blond from Niles Il ,she came across as dame o1 on Mertodate.com his or her email is annarol10@yahoo.com. This one is a geologist,she got robbed by thieves a ... read more

2009-11-20 16:50:06:
by wanwan
in Dating Scams
on Dating scammer Irina Prigunova:

http://www.delphi. p=8#59237
@2007-17-11-03, 13:04:09 (updated: 2007-11-03, 13:22:53)
OJAS from United States
I tried it but ?

O ... read more

2009-11-20 16:24:54:
by anonymous
in Male Dating Scammers
on Dating scammer David Williams:
hi i JUST WANTED TO SAY THAT i HAD SOMEONE e-MAIL ME ABOUT MY PSP BUNDLE FOR SALE. AND SAID SHE SENT ME THE MONEY BUT IT NEVER SHOWED UP IN MY PAYPAL ACOUNT SO I ASKED HER ABOUT THAT AND THIS IS WHAT ... read more


	Search: