How to change the name of the database using php

In the process of using PHP for development, we often need to deal with the database. Sometimes, we need to modify the name of the database to better manage and organize the data. This article will introduce how to use PHP to modify the name of the database.

1. Connect to the database

To use PHP to operate the database, you first need to connect to the database. Usually, we use mysqli extension to connect to MySQL database. The specific code is as follows:

$servername = "localhost"; //数据库主机名
$username = "username"; //数据库用户名
$password = "password"; //数据库密码
$dbname = "old_database"; //原数据库名称

//创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);

//检测连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

In the code, we use the mysqli_connect function to create a connection object $conn to connect to the MySQL database.

2. Modify the database name

After connecting to the database, we can use SQL statements to modify the database name. The specific steps are as follows:

2.1. Create a new database

First, we need to create a new database in order to transfer the data in the original database to the new database. For example, we want to change the name of the original database old_database to new_database. Then, we need to first create a database named new_database.

//创建新的数据库
$sql = "CREATE DATABASE new_database";
if (mysqli_query($conn, $sql)) {
    echo "新的数据库创建成功";
} else {
    echo "Error creating database: " . mysqli_error($conn);
}

In the SQL statement, we use the CREATE DATABASE statement to create a database named new_database. If the creation is successful, "New database created successfully" will be output; otherwise, an error message will be output.

2.2. Transfer the data in the original database to the new database

After creating the new database, we need to transfer the data in the original database to the new database. Here, we can use the SQL statement RENAME TABLE to rename the table in the original database and transfer it to the new database.

//将原数据库中的表转移到新的数据库中
$sql = "RENAME TABLE old_database.table1 TO new_database.table1, old_database.table2 TO new_database.table2";
if (mysqli_query($conn, $sql)) {
    echo "原数据库中的表转移成功";
} else {
    echo "Error renaming table: " . mysqli_error($conn);
}

In the SQL statement, we use the RENAME TABLE statement to rename the two tables table1 and table2 in the original database and transfer them to the new database new_database. If the transfer is successful, "The table in the original database was transferred successfully" will be output; otherwise, an error message will be output.

2.3. Delete the original database

Finally, we need to delete the original database to avoid conflicts. The method of deleting the original database is also very simple, just use the SQL statement DROP DATABASE.

//删除原数据库
$sql = "DROP DATABASE old_database";
if (mysqli_query($conn, $sql)) {
    echo "原数据库删除成功";
} else {
    echo "Error deleting database: " . mysqli_error($conn);
}

In the SQL statement, we use the DROP DATABASE statement to delete the original database old_database. If the deletion is successful, "Original database deleted successfully" will be output; otherwise, an error message will be output.

3. Complete code

The following is the complete PHP code, which can be copied and used directly:

$servername = "localhost"; //数据库主机名
$username = "username"; //数据库用户名
$password = "password"; //数据库密码
$dbname = "old_database"; //原数据库名称

//创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);

//检测连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

//创建新的数据库
$sql = "CREATE DATABASE new_database";
if (mysqli_query($conn, $sql)) {
    echo "新的数据库创建成功";
} else {
    echo "Error creating database: " . mysqli_error($conn);
}

//将原数据库中的表转移到新的数据库中
$sql = "RENAME TABLE old_database.table1 TO new_database.table1, old_database.table2 TO new_database.table2";
if (mysqli_query($conn, $sql)) {
    echo "原数据库中的表转移成功";
} else {
    echo "Error renaming table: " . mysqli_error($conn);
}

//删除原数据库
$sql = "DROP DATABASE old_database";
if (mysqli_query($conn, $sql)) {
    echo "原数据库删除成功";
} else {
    echo "Error deleting database: " . mysqli_error($conn);
}

//关闭连接
mysqli_close($conn);

4. Summary

This article introduces how to use PHP to modify the name of the database. Specific steps include connecting to the database, creating a new database, transferring data in the original database to the new database, and deleting the original database. By reading this article, you can quickly master the method of using PHP to modify the database name, which will help your database operations.

The above is the detailed content of How to change the name of the database using php. For more information, please follow other related articles on the PHP Chinese website!