Have you ever written a piece of code that works, but the amount of redundancy and inefficiency drove you nuts? Always had the itch to go back and pretty it up? Well, that’s exactly what I did. I recently wrote a script for a people directory, it contained 3 parts

1. An database storing the information of the people (i.e. name, states, country, etc etc.)
2. the html input file (see example below)
3. The data processor using PHP

input file (input.html)

The idea is that you will be able to select a last name or a state and find the corresponding results. For example, finding someone in the state of Virginia, finding someone with last name start with W, or a combination of both.

This was the first attempt for selecting the matching last name:

HERE

HERE

By using arrays, here are the code for selecting the matching last name and state and generate the SQL query

HERE

HERE

This entry was posted on Wednesday, June 25th, 2008 at 10:50 am and is filed under php, programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.