In this tutorial we will study about PDO in PHP, it is a new feature of PHP which is included in PHP 5. This is the index page on this topic, subsequent pages will focus on every point on this topic.

PHP PDO:

PHP has introduced a new uniform interface for database connectivity called  PDO, it is used to connect with many type of database . PDO (PHP Database Objects) is a PHP extension which defines an object-oriented, lightweight, uniform  interface for database connectivity and accessing the data. PHP is not an abstraction layer like PearDB. It is much like Pearl's DBI. Using the following and subsequent tutorial's coding you can create your own database and use PDO.

To check available drivers in php.ini file execute the following piece of code and you will get to know about that, if you want to put more drivers on active mode then go to php.ini file and find out  your desired drives and remove the semicolons from that line:

 

Example:

<?php

foreach(PDO::getAvailableDrivers()as $driver)

{

echo $driver.'<br/>';

}

?>

Output:

mysql
odbc
pgsql
sqlite
sqlite2

 

This is the index page of PDO, following pages will illustrate how to connect with different DBMS and other features of PDO:

PDO MySQL
In this tutorial we will study about PDO MySQL in PHP, how to access MySQL using PDO, etc. Examples will make this clearer.
 
PDO PgSQL
In this tutorial we will study about PDO PgSQL in PHP, how to access PgSQL using PDO, etc. Examples will make this clearer.
 
PDO Execute
In this tutorial we will study about PDO Execution of code (select) in PHP, how to display data using PDO, etc. Examples will make this clearer.
 
PDO Insert
In this tutorial we will study about insertion of data using PDO in PHP, How to insert data using inbuilt function exec() is described here. Examples will make this clearer.
 
PDO Fetch Execute
In this tutorial we will study about PDO Fetch Assoc Execute in PHP, how to access MySQL using PDO Fetch Assoc function, How to retrieve data etc. Examples will make this clearer.
 
PDO Fetch Num
In this tutorial we will study about PDO Fetch Num in PHP, how to access MySQL using PDO Fetch Num function, How to retrieve data etc. Examples will make this clearer.
 
PDO Fetch Both
In this tutorial we will study about PDO Fetch Num in PHP, how to access MySQL using PDO Fetch Num function, How to retrieve data etc. Examples will make this clearer.
 
PDO Fetch Object
In this tutorial we will study about PDO Fetch Object method in PHP, how to access MySQL using PDO Fetch Object method, How to retrieve by using this method data etc. Examples will make this clearer.
 
PDO Fetch Lazy
In this tutorial we will study about PDO Fetch Lazy method in PHP, how to access MySQL using PDO Fetch Lazy method , How to retrieve data etc. Examples will make this clearer.
 
PDO Fetch Class
In this tutorial we will study about PDO Fetch Class method in PHP, how to access MySQL using PDO Fetch Class method , How to retrieve data etc. Examples will make this clearer.
 
PDO Fetch Into
In this tutorial we will study about PDO Fetch Into method in PHP, how to access MySQL using PDO Fetch Into method , How to retrieve data etc. Examples will make this clearer.
 

Related Tags for PHP PDO Index: