如何通过删除“wc_”前缀来操作WooCommerce订单键？

<?php
// 连接到数据库
$host = 'localhost';
$dbname = 'woocommerce_db';
$user = 'db_user';
$pass = 'db_password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}

// 查询所有订单键
$query = "SELECT order_id, order_key FROM wp_posts WHERE post_type = 'shop_order'";
$stmt = $pdo->query($query);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $order_id = $row['order_id'];
    $order_key = $row['order_key'];

    // 检查并删除前缀
    if (strpos($order_key, 'wc_') === 0) {
        $new_order_key = substr($order_key, 3);

        // 更新订单键
        $update_query = "UPDATE wp_posts SET post_name = :new_order_key WHERE ID = :order_id";
        $update_stmt = $pdo->prepare($update_query);
        $update_stmt->bindParam(':new_order_key', $new_order_key);
        $update_stmt->bindParam(':order_id', $order_id);
        $update_stmt->execute();
    }
}

echo "操作完成！";
?>