The ramblings of web developer Beau Brownlee

Posts Tagged ‘ PDO ’

 
Thursday, June 10th, 2010

PHP has typically been partnered along side of MySQL as a DBMS for a long time now. While MySQL is very powerful PHP can utilize many other DBMS’s as well such as PostgresSQL, Oracle, and even Microsoft SQL. The problem is that connecting to and using the different databases means you have to load different drivers with different coding conventions. For a long time you couldn’t use the same code with Microsoft SQL as you did with MySQL. Not until PDO.

********************UPDATE***************************
I’ve changed a couple things in the class. First I’ve changed the get rowcount and get columncount to functions so they are run on demand instead of every time you execute a query. I’ve also added in a function to get the last inserted ID from an insert query which is very handy. I’ve also added in a function to close the opened cursor to free up memory and the function runs in the destruct magic method.
*****************************************************

(more…)

cheap software