when/where we use PDO?

Question

Hi Guys, I want to know when and where we use PDO's other than simple mysql_connect methods?

Is this PDO is faster ? what are the advantages over other methods?

Answer 1

The PDO introduction in the PHP documentation details much of this basic information. To some extent, PDO is to PHP as JDBC is to Java. Except, well, not quite as nice.

Answer 2

1. Security: The most useful thing with PDO are the prepared statements. With them, writing code which can be SQL Injected is far more complicated. ;-)

2. Errorhandling: On the other hand the errorhandling is much much better as you can switch to Exceptions instead of lousy FATALs ERRORs and so on.

3. Extensibility: With the mysql_ methods you're strictly bound to mysql. Maybe sometime in the future you want to use antoher database and have to rewrite all your connection and query issuing code. If you're using MySQL specific queries this point has no value to you as you have to rewrite most of your database code anyway.

Answer 3

Apart from the portability, mysqli provides you with pretty much the same as PDO does (like prepared statements, transactions and so on) except that mysqli is a bit faster than PDO.

Answer 4

here is a similar discussion to chew on http://stackoverflow.com/questions/13569/mysqli-or-pdo-what-are-the-pros-and-cons