Home / Web Development Technologies / Codeigniter / PHP Data Objects – PDO

PHP Data Objects – PDO

PHP Data Objects - PDO

Introduction to PHP Data Objects

Short Definition
PHP Data Objects is a database abstraction layer giving a uniform technique for access to different databases.”

Explaination of  PDO
The PHP Data Objects extension characterizes a lightweight, reliable interface for getting to databases in PHP. Every database driver that executes the PDO interface can uncover database-particular components as routine extension functions. Note that you can’t perform any database functions utilizing the PDO extensions without anyone else; you should utilize a database-particular PDO-driver to get to a database server.

PDO gives a data access abstraction layer, which implies that, paying little heed to which database you’re utilizing, you utilize the same functions to issue queries and bring information. PDO does not give a database reflection; it doesn’t revise SQL or imitate missing components. You have to use a full-blown abstraction layer if you want that facility.

Database Supports
The extension can back any database that a PDO driver has been developed for. At the point of this written work, the accompanying database drivers are accessible:

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

These drivers are not automatically accessible on your system; here’s a fast approach to find which drivers you have:

1 print_r(PDO::getAvailableDrivers());

 

Introduction to PHP Data Objects Short Definition "PHP Data Objects is a database abstraction layer giving a uniform technique for access to different databases." Explaination of  PDO The PHP Data Objects extension characterizes a lightweight, reliable interface for getting to databases in PHP. Every database driver that executes the PDO interface can uncover database-particular components as routine extension functions. Note that you can't perform any database functions utilizing the PDO extensions without anyone else; you should utilize a database-particular PDO-driver to get to a database server. PDO gives a data access abstraction layer, which implies that, paying little heed to…

0%

User Rating: 3.02 ( 3 votes)

Check Also

AngularJS and Laravel Blade

How to use AngularJS and Laravel Blade together

How to use AngularJS and Laravel Blade together In this article I will show you …

Ajax Pagination Using Laravel

How to Create an Ajax Pagination Using Laravel

In this article I will demonstrate one way to create an Ajax pagionation using Laravel …

Leave a Reply

Your email address will not be published. Required fields are marked *