News Feed
Jobs Feed
Sections




News Archive
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

Ryan Malesevich's Blog: MD5 to SHA-1 in PHP and MySQL (Part 1)

Greg Beaver\'s Blog: Protecting a MySQL user/password in a PHP script

Gonzalo Ayuso's Blog: Keep our PostgreSQL databases synchronized with PHP. Database version control

Dave Dash's Blog: Saving a file to a database using symfony and doctrine

Debianhelp.co.uk: LAMP (Linux Apache Mysql PHP) Configuration in Debian


Community Events











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


application introduction series release functional unittest conference opinion tool code development community zendframework2 language interview testing example framework podcast phpunit

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