PHP -如何动态导出数据到excel文件(.xls) - PHP - How can I dynamically export data to excel file (.xls)?

PHP - How can I dynamically export data to excel file (.xls)?

我使用php。我想知道如何动态地将数据导出到excel文件(.xls)。在下面的查询中，在子句Select中输入字段，我想在excel文件中看到。

$query = "SELECT f.attendee_id as id1, f.answer as Prenom, l.answer as Nom, c1.answer as choix
         FROM wp_events_answer f
         JOIN wp_events_answer l ON f.attendee_id = l.attendee_id
         JOIN wp_events_answer c1 ON f.attendee_id = c1.attendee_id
         WHERE (f.question_id = 1) AND (l.question_id = 2) AND (c1.question_id = 28);";

我还输入了这些字段的标签:

$tbl= " <table border='1'>
<tr height='50px'><td WIDTH='50px' align='center'>ID</td><td WIDTH='50px'   align='center'>Prenom</td><td WIDTH='50px'align='center'>Nom</td><td WIDTH='50px' align='center'>Choix 1</td><td WIDTH='50px' align='center'>Choix 2</td></tr>";.;

但是我希望所有这些都是动态的，因为用户可以创建和修改表单。因此，如果用户添加或修改了一个字段，则只有当该字段在代码中也被修改(Select子句)时，导出才会起作用。

你能告诉我怎么做吗?

谢谢

MYSQL代码

SELECT f.attendee_id as id1, f.answer as Prenom, l.answer as Nom, c1.answer as choix
    INTO OUTFILE '/path/to/file.csv'
    FIELDS
            TERMINATED BY ';'
            OPTIONALLY ENCLOSED BY '"'
    FROM wp_events_answer f
     JOIN wp_events_answer l ON f.attendee_id = l.attendee_id
     JOIN wp_events_answer c1 ON f.attendee_id = c1.attendee_id
     WHERE (f.question_id = 1) AND (l.question_id = 2) AND (c1.question_id = 28);

只需将您的数据以CSV(逗号分隔)格式写入响应缓冲区或磁盘文件(稍后您可能允许用户下载或强制下载)