บทสรุปความแตกต่างระหว่าง PDO กับ MySQLi
PDO | MySQLi | |
Database support | 12 different drivers | MySQL only |
API | OOP | OOP + procedural |
Connection | Easy | Easy |
Named parameters | Yes | No |
Object mapping | Yes | Yes |
Prepared statements (client side) |
Yes | No |
Performance | Fast | Fast |
Stored procedures | Yes | Yes |
PDO database support : CUBRID, MS SQL Server, IBM, Informix, MySQL, MS SQL Server, Oracle, ODBC and DB2, PostgreSQL, SQLite, 4D
อ้างอิง
https://code.tutsplus.com/tutorials/pdo-vs-mysqli-which-should-you-use–net-24059