The mysql extension is deprecated and will be removed in the future: use mysqli or pdo instead in

Question

Problem :

When I try to connect to the MySQL server from PHP, I see a below error:

“Deprecated: The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /path/to/filename.php on line 123”

The code on a referenced line is as below:

mysql_connect($server, $username, $password);

I am certain that my arguments are correct, and also exact code has been working for many years without a problem. So how can I fix my code?

Answer 1

As per your error message suggests, there are the two other MySQL extensions that you can consider: MySQLi and PDO_MySQL, either of which can be used by you instead of ext/mysql. Both have been in the PHP core since v5.0, so if you are using the version that is throwing above deprecation errors then you can very certainly just start using them right away means without any of the installation effort.

They differ slightly, but offer the number of advantages over your old extension including API support for the transactions, stored procedures and your prepared statements (thereby providing a best way to defeat the SQL injection attacks). It helped me and many other PHP developers like me.