Deprecated `mysql_connect()`: How Can I Migrate to a Modern MySQL Solution?

Deprecated: mysql_connect() - Solutions and Mitigation

PHP's "mysql" extension is now considered deprecated and will be removed in future versions. When using the "mysql_" functions, you may encounter the warning message "Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future."

Below are some methods to address this issue:

1. Transition to MySQLi or PDO

MySQLi and PDO are recommended replacements for the deprecated "mysql" extension. They provide a more modern and efficient way to interact with MySQL databases. Here's an example of using MySQLi:

$mysqli = new mysqli("localhost", "username", "password", "database_name");

2. Disable Deprecated Warnings

To temporarily disable all deprecated warnings, including those from "mysql_*" functions, use the following code:

error_reporting(E_ALL ^ E_DEPRECATED);

3. Edit Your Code

In your "connect.inc.php" file, replace the "mysql_" functions with their MySQLi or PDO equivalents. For example:

// Old way
$connect = mysql_connect('localhost','root','');
// New way (MySQLi)
$mysqli = new mysqli("localhost", "root", "", "dbname");

4. Update Specific Warning Offsetting

If you'd like to disable the warning for a specific file and line, add the following code to the appropriate file:

error_reporting(E_All);

Once this is added, replace it with:

error_reporting(E_ALL ^ E_DEPRECATED);

The above is the detailed content of Deprecated `mysql_connect()`: How Can I Migrate to a Modern MySQL Solution?. For more information, please follow other related articles on the PHP Chinese website!