SQL Archive
Some More PDO Weirdness
I've said before that I'm a great fan of PDO and use it wherever possible. That said there are some annoying quirks in it, one of which I encountered today. I'll outline what I was trying to do, what I expected to happen and what actually happened. I'm also curious...
Read More Creating 50,000 unique values
A client at work wants to run a promotion where a customer will receive a card with a unique 8 digit code on it when they buy something. They will then be able to visit the website to find out if they are a winner or to get a chance...
Read More A Quick Tip
I haven't written anything here for ages due to illness, work and life getting in the way. I've got a longer post brewing that I'll hopefully add in the next couple of days but for now here's a quick tip that I hope someone will find useful.
I recently had a...
Read More Creating a Persistent Login Mechanism
I've been working on a project recently where one of the requirements was to have a persistent login mechanism. I'm not a great fan of this kind of feature simply because it significantly degrades the security of the application. As the only mechanism whereby data can be persisted across sessions...
Read More Handling Binary Data with PDO
I'm a great fan of the PDO database access library in PHP 5 and use it for all of my database work in PHP. I love its' clean, object oriented syntax and great support for prepared statements. I also like the fact that it supports most of the most common database...
Read More Location Aware Webpages
I'm working on a site for a client at the moment who has around 35 store locations across Canada. The client was keen to have a 'your local store' feature on the home page where the store closest to the visitors location was featured. I thought I'd write briefly about...
Read More 
