PDO vs MySQLi. What do you think? PHP

Question

I have been reading through a few articles on PDO and they seem to say switch over, MySQLi is outdated, etc.

It does look good, you can use lots of different types of SQL servers and still use the same functions. Better OO emphasis.

Below are a couple of the articles I read.

Your MySQL Code Sucks.

Why you Should be using PHP’s PDO for Database Access

What is the general consensus on here?

This question is really not a good fit for the SO Q&A format. Generally questions should have a specific answer. This one doesn't. [Please read the FAQ](http://www.stackoverflow.com/faq). — Charles Sprayberry, Jan 30 '12 at 16:16
Also see http://stackoverflow.com/questions/13569/mysqli-or-pdo-what-are-the-pros-and-cons — Charles Sprayberry, Jan 30 '12 at 16:17
Does this answer your question? [mysqli or PDO - what are the pros and cons?](https://stackoverflow.com/questions/13569/mysqli-or-pdo-what-are-the-pros-and-cons) — Dharman, Feb 15 '20 at 12:05

score 0 · Accepted Answer · edited Sep 17 '12 at 18:24

0

If you think there is a remote possibility you will need to use a different DB backend, then use PDO. If you know you will only be using MySQL and already know how to use it, or have a good library to wrap the mysqli_*() class of functions, just use that.

edited Sep 17 '12 at 18:24

Kenny Linsky

1,726
3
17
41

answered Jan 30 '12 at 16:18

deed02392

4,799
2
31
48

PDO vs MySQLi. What do you think? PHP

1 Answers1