Home / Questions / 134983
Accepted
Art_Code
Asked: 2020-01-31 14:09:47 +0800 CST 2020-01-31 14:09:47 +0800 CST

Is the PDO MySQL extension for Php deprecated?

  • 772

I have been searching the internet and I know that MySQL for database connection as such is deprecated since Php 7.0.0 and MySQLi should be used as a replacement.

However, I have the big question: does this also cover the PDO part for MySQL?

I read on php.net about PDO MySQL and it doesn't mention that it is obsolete, but when dealing with the same connection to a database, the doubt remains.

If not obsolete, could it be discontinued in the near future? Is it advisable to continue using it or for new projects I use everything with MySQLi?

php

1 Answers

  1. Best Answer

    Short answer

    As much MySQLias PDOthey are totally valid for new projects.

    We can deduce it from what is stated here:

    Recommended API

    It is recommended to use the extensions mysqlior PDO_MySQL. Using the old mysql extension for new development is not recommended as it has been deprecated in PHP 5.5.0 and removed in PHP 7. A detailed feature comparison matrix is ​​provided below. The overall performance of all three extensions is considered to be approximately the same. Although the performance of the extension contributes only a fraction of the total execution time of a PHP web query. Often the impact is as low as 0.1%.

    Source: Choosing an API for Database Connection in the PHP Manual

    Feature Comparison

    The Manual offers the following comparison table, in which we can see that as much PDOas they mysqliare valid to use them in any current project. The comparison also includes extension mysql_*1 , which is deprecated and not recommended for future projects. This extension no longer comes in PHP 7 core.

    Comparison between PDO, mysqli and mysql in the PHP Manual Comparison between PDO, mysqli and mysql in the PHP Manual

    1 The current state of the extension mysql_*was covered in this question: Why shouldn't the mysql_* API be used in PHP/MySQL? . Its use still appears in many code examples on the net... and it also appears a lot in questions posed on SO, so it is important to always underline the obsolescence of this extension, which is also often confused with mysqli.

    • 6