Supports MySQLusing aPHP extension. Thousands or millions projects havebeen written worldwide using PHP andMySQL. PHP team announced plans todeprecate in. Old MySQL extension since PHP 5.5.0 in late 2012 and it will be removed inthe future. Thealternatives since PHP 5 and later are ('i' stands from'improved') and (PHP Data Objects).Everyone can understand that is not so easy to immediately migrate oldprojects. However, the old extension must notbe usedanymore in new development.Old extension didn't support Prepared Statements.
Mysqli Extension Is Missing
Both MySQLi and PDO areobject oriented anddo support Prepared Statements (also support Transactions, Stored Proceduresand more). Prepared Statements are very important forwebapplication security, as they protect from SQL injection. Using PreparedStatements you donot have to escape strings before insert them in Database. Moreover, PDOoffers support for many databases (not only MySQL).So, the question is 'Which Should I Use?
MySQLi or PDO?' A shortanswer would be 'whatever you like'.
Personally, I prefer MySQLi.I could select PDO if 'multiple database support' was included inproject requirements (however, in this case couldalso be an alternative).Below I describe the common use of MySQLi in php development withdatabase (it canbe also used with, an enhanced, drop-inreplacement for MySQL).