News Feed
Jobs Feed
Sections




News Archive
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
April 23, 2007 @ 16: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.

0 comments voice your opinion now!
mysql block visitor country download csv database htaccess mysql block visitor country download csv database htaccess


blog comments powered by Disqus

Similar Posts

DeveloperTutorials.com: Inserting An Array Into A Database

Vinu Thomas' Blog: Modifying your MySQL databases to be UTF-8 compliant

SitePoint PHP Blog: Cursors in MySQL Stored Procedures

DevShed: Working with MySQL and Sessions to Serialize Objects in PHP (Part 3)

International PHP Magazine: November 2006 Issue Released


Community Events











Don't see your event here?
Let us know!


database unittest example introduction release hhvm hack podcast security composer project package performance language framework install component application symfony2 facebook

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework