独角数发卡的已完成订单
生成CSV...
这是chatgpt帮我写的一代php代码..
测试运行成功

<?php
// 数据库连接信息
$servername = "localhost";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "密码库名";

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询已完成的订单数据
$sql = "SELECT * FROM orders WHERE status = 4"; // 假设已完成的订单状态码为 4，请根据实际情况调整
$result = $conn->query($sql);

// 检查查询结果
if ($result->num_rows > 0) {
    // 打开文件准备写入数据
    $file = fopen("exported_orders.csv", "w");

    // 写入 CSV 列名
    $column_names = array("ID", "OrderSN", "GoodsID", "CouponID", "Title", "Type", "GoodsPrice", "BuyAmount", "CouponDiscountPrice", "WholesaleDiscountPrice", "TotalPrice", "ActualPrice", "SearchPwd", "Email", "Info", "PayID", "BuyIP", "TradeNo", "Status", "CouponRetBack", "CreatedAt", "UpdatedAt", "DeletedAt");
    fputcsv($file, $column_names);

    // 循环输出数据到 CSV 文件
    while($row = $result->fetch_assoc()) {
        $csv_data = array_values($row);
        fputcsv($file, $csv_data);
    }

    // 关闭文件
    fclose($file);

    echo "已完成的订单数据成功导出到 exported_orders.csv 文件。";

} else {
    echo "没有找到已完成的订单数据。";
}

// 关闭数据库连接
$conn->close();
?>