News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Martin Psinas' Blog:
Switching to PDO
August 04, 2011 @ 10:17:59

In a new post to his blog Martin Psinas talks about some of his pains experienced with upgrading his code to use PDO instead of the mysql extension for database interaction.

I read not too long ago that the mysql library in PHP is being deprecated as of v6.0 in favor of mysqli or PDO, so of course I had to update all of my database code keep on top of things. I spent about 5 or 6 hours over the course of 2 days familiarizing myself with the new syntax and updating my code offline. Without any testing, I decided I could go ahead and push the code "live" because I'm just that over-confident sometimes, although I did make a backup in case anything went wrong (or so I thought).

Two problems jumped out immediately - a SQL error caused by this bug and the other being a problem with preparing his statement inside of a session handling method.

0 comments voice your opinion now!
pdo mysql switch problem prepare session limit bug


blog comments powered by Disqus

Similar Posts

Stefan Mischook's Blog: Connecting PHP to MYSQL Video Tutorial

Phpro.org: Introduction to PHP and MySQL

O\'Reilly: $lamp =~ /^Linux,\\s*Apache,\\s*MySQL,P(?:hp|ython|erl[56])$/

Software Gunslinger: PHP is meant to die

PHP-Code.net: Securing PHP Apps Part III Securing PHP on the server/Securing MySQL & Apache


Community Events





Don't see your event here?
Let us know!


language symfony voicesoftheelephpant interview release composer community series application tool update package opinion version framework introduction security podcast laravel library

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework