Alex Colson - Tech Talk

Logging to MySQL with Apache
Created: Thursday, April 17, 2008 11:16:20 AM
Logging Apache access logs to a database can be very convenient for keeping track of requests. Some advantages are:Tracking data sent from Apache for a specific virtual host, very useful for hosting companiesDetermining which pages get the most...

Using ZIP Codes in Web Applications
Modified: Saturday, March 8, 2008 6:09:29 PM
Using ZIP Codes in a web application allows users to do many things, including:Finding all cities and states within a certain range of a specific locationLocating the businesses and stores closest to their locationCalculating the distance between two...

Making a Simple Search Engine
Modified: Friday, January 25, 2008 10:49:51 PM
Search engines can add a lot of functionality to a website but can be very difficult to create. If you have a database full of items that need to be searched and use Perl, then this might be your solution. If not, then maybe this tutorial...

MySQL Prep
Modified: Sunday, September 23, 2007 10:26:35 PM
MySQL prep makes user input safe to use in SQL queries. MySQL prep should be used whenever user input is piped directly into the SQL query to prevent SQL Injection.The code below is written in Perl but the same concepts apply to any language.Th...

Page System
Modified: Sunday, September 23, 2007 7:16:10 PM
Page System is a Perl function that outputs a list of page links. This function can be very useful when a large number of results can occur, such as search engines and listing items.To use the function you must have the total results, the numb...

Friday, September 5, 2008 5:57:28 PM EST (0.0178 s)