Learning PDO

Learning PDO – many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions.

What is PDO

The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. Each database driver that implements the PDO interface can expose database-specific features as regular extension functions. Note that you cannot perform any database functions using the PDO extension by itself; you must use a database-specific PDO driver to access a database server.

PDO provides a data-access abstraction layer, which means that, regardless of which database you’re using, you use the same functions to issue queries and fetch data. PDO does not provide a database abstraction; it doesn’t rewrite SQL or emulate missing features. You should use a full-blown abstraction layer if you need that facility.

PDO ships with PHP 5.1, and is available as a PECL extension for PHP 5.0; PDO requires the new OO features in the core of PHP 5, and so will not run with earlier versions of PHP.


Start using PDO

Make sure you have the following tools “Required tools“.

Now lets create a database on phpmyadmin.

  • Database name: db_test
  • table: tbl_test
  • Fields: id, name, age, gender
Learning PDO

Now we will going to create a simple connection using PDO.

We will create a simple handler

Now we will going to add exception error handler.

PDO::setAttribute – Sets an attribute on the database handle. Some of the available generic attributes are listed below; some drivers may make use of additional driver specific attributes.  Read more