PDO

Today was a code day. Regular readers will recall how bummed I was when Google went with OAuth2 and threw my map projects into limbo. I put a weekend into it, converted all of my Google Spreadsheets to MySql tables, then converted the Zend data to MySql code. Whew, that’s a mouthful…

Next up I find that the code monkeys are depreciating MySql and recommending everybody update to MySqli (the improved version). In a previous post I thought they wouldn’t have the nerve but after a little research, they’ll probably kill standard MySql.

So, I thought, since my mapping apps are state of the art, shouldn’t my database code be also? Today I’ve been replacing all of that MySql code with PDO. This is a very cool interface for accessing MySql databases in PHP, and it’s the acknowledged leader over MySqli. It stands for PHP Data Objects and is very object-oriented.

Here are the current affected projects: all of the JimsMaps, along with bdjMap. I’ll have these conversions done tomorrow…