Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brent Meshier's Blog:
Blocking visitors by country using PHP & MySQL
Apr 23, 2007 @ 21:38:00

In a quick new post from Brent Meshier today, he shows us how, with the help of a database CVS file, to block visitors to your site from certain locales.

A client asked me last night if it was possible to block certain countries from accessing his website. He's concerned about the "axis of evil" and their comrades downloading his software. The task is easily accomplished, although it's like using a sledge hammer to tap in a finishing nail. He didn't seem too concerned that we could accidentally block Uzbekistan in the process. Unfortunately his entire site uses plain .html files, no dynamic scripting. This led me to using a slightly creative solution with .htaccess.

Broken up into five simple steps, he makes a light function to drop into an output buffering function to tell it to either show the normal content or return a 401 Unauthorized header to the visitor.

tagged: mysql block visitor country download csv database htaccess mysql block visitor country download csv database htaccess

Link:


Trending Topics: