How Can I Fix the 'Deprecated: mysql_connect()' Warning in My PHP Code?

Deprecated: mysql_connect() Warning in PHP

You may encounter the "Deprecated: mysql_connect()" warning while using MySQL functions in your PHP code. This warning indicates that the mysql_* extensions are deprecated and will be removed in future PHP versions.

Cause:

This warning is triggered because your code is using deprecated MySQL functions like mysql_connect(), which have been replaced with more modern and secure alternatives.

Solution:

There are two main approaches to resolving this warning:

1. Upgrade to MySQLi or PDO:

   • Migrate your code to use the MySQLi or PDO extensions, which are the preferred and recommended methods for accessing MySQL in PHP.
   • For example, replace mysql_connect() with mysqli_connect() or PDO::connect().

2. Suppress Deprecated Warnings:

   • Use the error_reporting() function to suppress deprecated warnings specifically for the mysql_* functions. For instance, add the following line at the top of your script:

     error_reporting(E_ALL ^ E_DEPRECATED);

   • This will prevent the "Deprecated: mysql_connect()" warning from being displayed.

Example with MySQLi:

<?php
$connection = mysqli_connect('localhost', 'username', 'password', 'database');
?>

Additional Notes:

• If you are using XAMPP, you can edit the error_reporting setting in the php.ini file located in XAMPPphp folder.
• It's strongly recommended to use the MySQLi or PDO extensions instead of the deprecated mysql_* functions for improved performance, security, and compatibility.

The above is the detailed content of How Can I Fix the 'Deprecated: mysql_connect()' Warning in My PHP Code?. For more information, please follow other related articles on the PHP Chinese website!