MySQLi Extension

[sreenavc]

The mysqli extension, the MySQL improved extension, was developed to take advantage of new features found in MySQL systems versions 4.1.3 and newer. The mysqli extension has a number of benefits.

Read more:

[beniston]

Good article on MySqli.

Part II of the article is coming with PDO, there the author might compare MySqli and PDO.

I am a fan of PDO. How do you rate between MySqli and PDO?

[sreenavc]

I prefer PDO because of the ease of use and the error handling.

Mysqli allows you to use really awful procedural code, but as long as you're using the object-oriented methods and preparing your statements and such, it's great. The advantage of PDO over MySQLi is that PDO can be used for an assortment of database engines. So using PDO makes it easier to adjust the web application if you decide to switch databases.

[beniston]

Here is the Part 2 which they have mentioned about PDO in that article.

http://phpmaster.com/avoid-the-original ... tension-2/

This is also a nice article like the former one.

Another advantage of PDO is that it could be used for multiple databases.

[beniston]