I’m always finding myself looking up strings to format PHP and MySQL dates. A simple d/m/Y is pretty straight forward but sometimes things can get a bit fiddly. Where ever possible I try and leave my date formatting in the database, but I still find myself doing it in PHP all the time.
Here are a [...]
Posts under ‘MySQL’
MySQL DATE_FORMAT() AND PHP date() formats
UK Towns and Postcode Areas
The other day I needed a list of UK post towns matched up to postcode areas, which I found on wikipedia.
Anyway I have tidied it up and put it into two database tables postcode and town
You can download the SQL file here towns.zip
Hope it comes in useful.
Finding overlapping dates and times in MySQL
Quite often you end up in situations where you are required to check and see if one time period overlaps another time period. Probably the most common situation this occurs in is when you are building a booking system – be it for tables or cars or rooms.
You have a series of entries in a [...]
MySQL import / export at the Command Line
Like many (most?) developers when I work with a database I tend to manage them using another programme – usually either phpMyAdmin or Navicat. However there are times when you have to get basic again and dig down to the Command Line (usually because of an access issue like a firewall setting you [...]