What is the difference between MySQL, MySQLi and PDO? [closed]

by

There are (more than) three popular ways to use MySQL from PHP. This outlines some features/differences PHP: Choosing an API:

  1. (DEPRECATED) The mysql functions are procedural and use manual escaping.
  2. MySQLi is a replacement for the mysql functions, with object-oriented and procedural versions. It has support for prepared statements.
  3. PDO (PHP Data Objects) is a general database abstraction layer with support for MySQL among many other databases. It provides prepared statements, and significant flexibility in how data is returned.

I would recommend using PDO with prepared statements. It is a well-designed API and will let you more easily move to another database (including any that supports ODBC) if necessary.

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  3. mysqli or PDO – what are the pros and cons? [closed]
  4. How to prevent duplicate usernames when people register?
  5. PHP PDO and MySQLi [duplicate]
  6. Unknown database error in PHP but it exists in PHPMyAdmin
  7. PHP: mysql v mysqli v pdo [closed]
  8. SELECT COUNT(*) AS count – How to use this count
  9. How can I use PDO to fetch a results array in PHP?
  10. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  11. how safe are PDO prepared statements
  12. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  13. PHP PDO – Num Rows
  14. How to solve General error: 2006 MySQL server has gone away
  15. Mysql No connection could be made because the target machine actively refused it
  16. Replacing mysql_* functions with PDO and prepared statements
  17. How to connect to MySQL database in PHP using mysqli extension?
  18. Calling stored procedure with Out parameter using PDO
  19. When *not* to use prepared statements?
  20. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  21. What is the best way to insert multiple rows in PHP PDO MYSQL?
  22. PDO MySQL: Insert multiple rows in one query
  23. How to bind LIKE values using the PDO extension?
  24. Fatal error: Call to undefined function mysqli_result()
  25. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  26. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  27. PHP 7 RC3: How to install missing MySQL PDO
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. PDO and MySQL ‘between’

Leave a Comment