phpcms 表单数据导出

<?php
// 假设表单数据存储在数据库中
$host = 'localhost';
$dbname = 'phpcms';
$user = 'root';
$pass = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 查询表单数据
    $stmt = $pdo->query("SELECT * FROM form_data");
    $data = $stmt->fetchAll(PDO::FETCH_ASSOC);

    // 设置文件头
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment; filename="form_data.csv"');

    // 打开文件句柄
    $file = fopen('php://output', 'w');

    // 写入 CSV 头
    fputcsv($file, array_keys($data[0]));

    // 写入数据行
    foreach ($data as $row) {
        fputcsv($file, $row);
    }

    // 关闭文件句柄
    fclose($file);
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>