Php从数据库表中查找和替换文本中的单词

<?php
// 连接数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 查询数据
$sql = "SELECT id, content FROM your_table WHERE content LIKE '%目标单词%'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 替换文本
    while ($row = $result->fetch_assoc()) {
        $newContent = str_replace("目标单词", "替换后的单词", $row["content"]);

        // 更新数据库
        $updateSql = "UPDATE your_table SET content = '$newContent' WHERE id = " . $row["id"];
        if ($conn->query($updateSql) === true) {
            echo "记录 " . $row["id"] . " 更新成功！";
        } else {
            echo "记录 " . $row["id"] . " 更新失败: " . $conn->error;
        }
    }
} else {
    echo "未找到包含目标单词的记录。";
}

$conn->close();
?>