dede数据库批量替换图片

<?php
// 数据库连接配置
$host = 'localhost';
$user = 'your_username';
$pass = 'your_password';
$dbname = 'your_database';

// 连接数据库
$conn = new mysqli($host, $user, $pass, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 替换的旧路径和新路径
$oldPath = 'old/path/to/images/';
$newPath = 'new/path/to/images/';

// 查询数据库中的图片路径
$sql = "SELECT id, imagefield FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $id = $row['id'];
        $imagefield = $row['imagefield'];

        // 替换图片路径
        $newImagefield = str_replace($oldPath, $newPath, $imagefield);

        // 更新数据库中的图片路径
        $updateSql = "UPDATE your_table SET imagefield = '$newImagefield' WHERE id = $id";
        if ($conn->query($updateSql) === TRUE) {
            echo "记录更新成功，ID: " . $id . "<br>";
        } else {
            echo "记录更新失败，ID: " . $id . " 错误: " . $conn->error . "<br>";
        }
    }
} else {
    echo "0 结果";
}

$conn->close();
?>