Nerdburn - Web application & graphic user interface design blog by Shawn Adrian

Web site design by Shawn Adrian & friends

Blog posts in Code

How to Select All New Entries From Today with MySQL

Posted June 17, 2010

Yesterday I wanted to create a little stats panel for a client that would tell me how many new people had signed up that day. Then I wanted to compare that with Google Analytics unique visitors to come up with a conversion rate for the day.

The Problem

The "creation_date" field in the "users" table …

Read more

SimpleYouTube: PHP Class For Getting Video Details

Posted March 11, 2010

While writing a custom CMS for a client, I was approached with the request to enable it to accept any YouTube URL and add that video to a video gallery page on the web site. This turned out to be a lot easier than it sounds, and in this post I'm sharing the class I wrote to assist with the task.

Dow…

Read more

How to Parse Google Maps Returned Address Data: A Simple jQuery Plugin

Posted February 19, 2009

Google maps makes it very easy to add a map to any page - but it's not so easy to extract meaningful address data from what Google returns. The goal of this article is to help you do three things.

Article Goals

  • Send a string to Google Maps
  • Parse the response Google returns
  • Do something useful with …

Read more

Displaying all 3 posts

About The Author

Shawn is a 29 year old freelance designer in Vancouver, BC, Canada. Check out his other project QuoteRobot:

QuoteRobot