Prepared statements: MySQLi or PDO?

Question

I'm using mySQL database and found out that using Prepared statements offer lots of benefits. However by browsing Stackoverflow I noticed that every expert encourages to use PDO, but no one talks about MySQLi. As far I have understood, PDO supports multiple databases, if thats not the concern, why PDO is preferred over mySQLi? Thanks

also see: http://stackoverflow.com/questions/13569/mysqli-or-pdo-what-are-the-pros-and-cons — kontur, Apr 16 '12 at 07:14

score 1 · Answer 1 · answered May 25 '20 at 18:47

PDO is more mature. It offers more features and is easier to use. It has fewer bugs. The choice has nothing to do with the number of drivers supported by PDO; you would need to rewrite your SQL anyway if you decided to change the RDBMS.

PDO is simply a much better extension for communication with the database.

score 0 · Answer 2 · answered Apr 12 '11 at 17:41

0

PDO is interface for accessing databases, so you can use various drivers. This mechanism gives you abstraction, so it's preferrable.

answered Apr 12 '11 at 17:41

miholeus

1,537
1
9
8

I dont understand, i never used more than one database, and mysqli is faster, so why use PDO? Thanks for answers – Roman Holzner Feb 26 '13 at 15:57

Prepared statements: MySQLi or PDO?

2 Answers2