This class can access different types of SQL database using PDO.
It provides a common interface to access different types of database like MySQL, PostgreSQL, Microsoft SQL server, IBM DB2, SQLite, Oracle, Informix, and Firebird.
The class can establish connections, execute queries, retrieve single result rows or single row columns, the number of result rows, the last inserted record identifier, the names of tables columns, and execute INSERT, UPDATE and DELETE queries from parameters.
It can use prepared queries to prevent SQL injection attacks.
This package implements the PDO database abstraction interface that is compatible with PHP 4.
PDO is an extension introduced in PHP 5 that provides a common interface to several types of relational databases.
Since PDO only became standard extension with PHP 5.1 and very few hosting companies provide PHP 5.1 servers, the idea of this package is to provide an implementation of the PDO API that works under PHP 4 without special extension in a compatible way to the PHP 5 extension.
Access MySQL using MySQL, MySQLi or PDO extensions
This package can be used to access MySQL databases using MySQL, MySQLi or PDO extensions.
There is a base class that defines an interface to access MySQL databases and there are also sub-classes to access MySQL databases using PHP PDO, MySQLi or MySQL extensions.
These classes provide functions to establish database connections, execute queries, sanitize query parameters, retrieve query results, affected rows or database access errors.
Stumble It!
Bookmark in del.icio.us
1. 
