我使用的是PHP。我想知道如何动态导出数据到Excel文件(.xls)。在下面的查询中输入子句中的字段选择我想要在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= "
ID | Prenom | Nom | Choix 1 | Choix 2 |
你能解释我怎么做到这一点?
谢谢