wordpress多域名更改

<?php
define('DB_NAME', 'your_database_name');
define('DB_USER', 'your_username');
define('DB_PASSWORD', 'your_password');
define('DB_HOST', 'localhost');

$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$old_domain = 'old-domain.com';
$new_domain = 'new-domain.com';

$sql = "UPDATE wp_options SET option_value = REPLACE(option_value, ?, ?) WHERE option_name = 'home' OR option_name = 'siteurl';";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ss', $old_domain, $new_domain);
$stmt->execute();

$sql = "UPDATE wp_posts SET guid = REPLACE(guid, ?, ?);";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ss', $old_domain, $new_domain);
$stmt->execute();

$sql = "UPDATE wp_posts SET post_content = REPLACE(post_content, ?, ?);";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ss', $old_domain, $new_domain);
$stmt->execute();

$sql = "UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, ?, ?);";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('ss', $old_domain, $new_domain);
$stmt->execute();

$stmt->close();
$mysqli->close();
?>