Blog

30 Minute Crash Course in mySQL

This is a crash course in SQL. Learn the basics enough to get you started with development or database administration. We will discuss how to create tables, search for information in those tables, join tables, perform easy calculations, and use real world examples to get you started in mySQL.

PHP Script to get user's location

Sometimes it's necessary to know the location of the user. This is available through third party pay sites, but what if you have no budget? This is a quick little function that uses cURL to scrape a third party website to get information about a users's location.

MySQL Fuzzy Dates

How to create fuzzy dates in mysql. What are "fuzzy dates?" Fuzzy dates are when you see blog posts or forum posts and they say stuff like "Posted 5 days ago" or "Last updated 3 years ago," as opposed to just giving the actual time those events occurred.