PHP API DOCTRINE DBAL Introduction

 

- Info:

- DBAL stands for Data Base Abstraction Layer.

- DBAL API allows you to use the same classes/functions to work with different Data Bases.

This means that the same code would work for MySQL, Oracle, SQLite and other Data Bases.

- This is in contrast of using for instance MySQL API which works only with MySQL DB.

Code written with MySQL API must be rewriten to work with Oracle or some other DB.

- Doctrine DBAL API works on top of PDO DBAL API.

 

- Additional Tutorials:

- PHP API DOCTRINE DBAL MySQL Connect

- PHP API DOCTRINE DBAL MySQL Insert

- PHP API DOCTRINE DBAL MySQL Select

- PHP API DOCTRINE DBAL MySQL Select Prepared Statement By name

- PHP API DOCTRINE DBAL MySQL Select Prepared Statement By position

- PHP API DOCTRINE DBAL MySQL Update

- PHP API DOCTRINE DBAL MySQL Delete

 

- Links:

Official docu

http://www.doctrine-project.org/docs/dbal/2.1/en/reference/data-retrieval-and-manipulation.html

http://www.doctrine-project.org/api/dbal/2.0/doctrine/dbal/connection.html

http://gonzalo123.wordpress.com/2011/07/11/database-abstraction-layers-in-php-pdo-versus-dbal/

http://www.programmingtuts.com/tutorial/php/database-abstraction-layers-in-php-pdo-versus-dbal.htm