SyntaxFix

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

Those are different APIs to access a MySQL backend

  • The mysql is the historical API
  • The mysqli is a new version of the historical API. It should perform better and have a better set of function. Also, the API is object-oriented.
  • PDO_MySQL, is the MySQL for PDO. PDO has been introduced in PHP, and the project aims to make a common API for all the databases access, so in theory you should be able to migrate between RDMS without changing any code (if you don't use specific RDBM function in your queries), also object-oriented.

So it depends on what kind of code you want to produce. If you prefer object-oriented layers or plain functions...

My advice would be

  1. PDO
  2. MySQLi
  3. mysql

Also my feeling, the mysql API would probably being deleted in future releases of PHP.

Examples related to php

• I am receiving warning in Facebook Application using PHP SDK • Pass PDO prepared statement to variables • Parse error: syntax error, unexpected [ • Preg_match backtrack error • Removing "http://" from a string • How do I hide the PHP explode delimiter from submitted form results? • Problems with installation of Google App Engine SDK for php in OS X • Laravel 4 with Sentry 2 add user to a group on Registration • php & mysql query not echoing in html with tags? • How do I show a message in the foreach loop?

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to pdo

• Pass PDO prepared statement to variables • PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers • Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes • PHP 7 RC3: How to install missing MySQL PDO • PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused • ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it • php artisan migrate throwing [PDO Exception] Could not find driver - Using Laravel • How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL) • PDOException SQLSTATE[HY000] [2002] No such file or directory • How do I configure php to enable pdo and include mysqli on CentOS?

Examples related to mysqli

• phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) • mysqli_real_connect(): (HY000/2002): No such file or directory • mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it • Call to a member function fetch_assoc() on boolean in <path> • How can I enable the MySQLi extension in PHP 7? • Fatal error: Call to a member function bind_param() on boolean • Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\ • How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL) • Object of class mysqli_result could not be converted to string in • mysqli::query(): Couldn't fetch mysqli