Over the last few months I’ve been working on a new way to update our collection of waterfall photos. Previously, we would add new waterfalls by hand into the respective state and county indices. While this worked for a few waterfalls, now that we have well ~140 falls it had become hard to manage. Instead, I decided to build a small database that would hold the important info (state, directions, photo, etc.) and write some PHP code to build the pages for us. I’ve been wanting to learn a bit more PHP code and this seemed like a good excuse reason.

As you might have guessed, I’ve finished the first version and our redesigned waterfall site is now automatically generated. Anytime we have an update we only need to add the data to the database and let the scripts do the rest of the work. Sweet.