mysql

Making MySQL Update and Insert Easier

An addition to our PHP/MySQL Query class created last month now we have quick and organized ways to maintain our MySQL INSERT and UPDATE queries.

Read the full article →

MySQL Queries Made Easy With PHP Functions Library

Every web developer has a library of code that they reference frequently, if not constantly. I’m sharing with you one of my most useful snippets my MySQL helper class that helps me organize my queries and easily reference commonly used functions.

Read the full article →

Populating the Regions, Divisions and States MySQL Tables

The relationships between states, divisions and regions are simple but need to be setup properly from the start. Here we’ll walk though the setup.

Read the full article →

US Census Data as a MySQL Database Playground

Somehow I ended up at the 1990 US census and I realized what a valuable data resource it is! All kinds of data that I can use to make a well structured MySQL playground to test new scripts and ideas on.

Read the full article →

Birthday MySQL Query Hates Timestamps

In order to query the users with birthdays from my MySQL table I had to convert Unix timestamps saved as integers to a more usable DATETIME format, then we explore two ways to query the birthdays.

Read the full article →