How Can I Effectively Migrate My PHP MySQL Code to MySQLi?

Converting from MySQL to MySQLi

Introduction

The MySQLi extension is a newer, improved version of the MySQL extension for PHP. It provides a more object-oriented approach to interacting with MySQL databases, and it offers several advantages over the older MySQL extension, including improved performance, security, and features.

Converting Code to MySQLi

Converting code from MySQL to MySQLi is relatively straightforward. For most functions, the syntax is very similar. Here are a few things to keep in mind:

• Replace all references to mysql_ functions with mysqli_ functions.
• If you are using the procedural interface, you will need to change your mysql_connect() call to mysqli_connect().
• If you are using the object-oriented interface, you will need to create a new mysqli object and then use methods like connect(), query(), and fetch_array() to interact with the database.

Example

Here is an example of how you can convert a simple MySQL script to MySQLi:

// MySQL

$link = mysql_connect($DB['host'], $DB['user'], $DB['pass']) or die("<center>An Internal Error has Occured. Please report following error to the webmaster.<br><br>".mysql_error()."'</center>");
mysql_select_db($DB['dbName']);

$sql='SELECT auto_id FROM friend_reg_user WHERE auto_id=' .$info['auto_id'];
$result_member=executequery($sql);
if($line_member=mysql_fetch_array($result_member)){
    extract($line_member);
} else {
    header("location: index.php");
    exit;
}

// MySQLi

$link = mysqli_connect($DB['host'], $DB['user'], $DB['pass'], $DB['dbName']) or die("<center>An Internal Error has Occured. Please report following error to the webmaster.<br><br>".mysql_error()."'</center>");

$sql='SELECT auto_id FROM friend_reg_user WHERE auto_id=' .$info['auto_id'];
$result_member=mysqli_query($link, $sql);
if($line_member=mysqli_fetch_array($result_member)){
    extract($line_member);
} else {
    header("location: index.php");
    exit;
}

Additional Notes

Note that the MySQL extension is deprecated and will be removed in a future version of PHP. It is recommended that you switch to MySQLi as soon as possible.

For more information on MySQLi, please refer to the following resources:

• [MySQLi Extension Function Summary](https://www.php.net/manual/en/mysqli.func.summary.php)
• [MySQLi Object Interface](https://www.php.net/manual/en/mysqli-object.php)
• [PHP MySQL Tutorial](https://www.w3schools.com/php/php_mysql_intro.asp)

The above is the detailed content of How Can I Effectively Migrate My PHP MySQL Code to MySQLi?. For more information, please follow other related articles on the PHP Chinese website!