dede数据库批量去除图片超连接

<?php
// 数据库连接信息
$host = 'localhost';
$user = 'your_username';
$pass = 'your_password';
$dbname = 'dedecms';

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

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

// 查询所有文章记录
$sql = "SELECT id, body FROM dede_addonarticle";
$result = $conn->query($sql);

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

        // 去除图片超链接
        $bodyWithoutLink = preg_replace('/<a[^>]*>.*?<img[^>]*>.*?<\/a>/i', '<img src="$1" alt="$2">', $body);

        // 更新数据库
        $updateSql = "UPDATE dede_addonarticle SET body = '$bodyWithoutLink' WHERE id = $id";
        if ($conn->query($updateSql) === TRUE) {
            echo "记录更新成功: " . $id . "<br>";
        } else {
            echo "记录更新失败: " . $id . " 错误: " . $conn->error . "<br>";
        }
    }
} else {
    echo "0 结果";
}

$conn->close();
?>