PHP MySQL PDO

From CoderLearner
Jump to: navigation, search

What is PDO?

  • PDO stands for PHP DATA Object extension for accessing databases in PHP.
  • PDO is a data access abstraction layer that can be used for different databases by using the same function to issue fetch and queries data.

PDO driver and support databases

Driver name	Supported databases
PDO_CUBRID	Cubrid
PDO_DBLIB	FreeTDS / Microsoft SQL Server / Sybase
PDO_FIREBIRD	Firebird/Interbase 6
PDO_IBM	        IBM  DB2
PDO_INFORMIX	IBM Informix Dynamic Server
PDO_MYSQL	MySQL 3.x/4.x/5.x
PDO_OCI	        Oracle Call Interface
PDO_ODBC	ODBC v3 (IBM DB2, unixODBC and win32 ODBC)
PDO_PGSQL	PostgreSQL
PDO_SQLITE	SQLite 3 and SQLite 2
PDO_SQLSRV	Microsoft SQL Server / SQL Azure
PDO_4D	        4D