column names not getting exported into csv but data does

Asked Mar 27 '20 at 14:52

Active Mar 27 '20 at 14:52

Viewed 145 times

everything seems to work in the following code as in it does download data from the table but the column names are not showing in the csv what is wrong?

$stmt = $db->prepare("select * from interviews");
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

$filename = "export.csv";

$f = fopen('php://output', 'w'); 

header('Content-Type: text/csv');

header('Content-Disposition: attachement; filename="export.csv"');

header("Pragma: no-cache");

header("Expires: 0");

foreach ($rows as $line) { 
    fputcsv($f, $line); 
}

fclose($f);

Thanks

asked Mar 27 '20 at 14:52

stella goldsmith

' what is wrong' - nothing- thats what it does , union headers – P.Salmon Mar 27 '20 at 15:00
how do i get the column names also? – stella goldsmith Mar 27 '20 at 15:01
1

Does this answer your question? [Include headers when using SELECT INTO OUTFILE?](https://stackoverflow.com/questions/5941809/include-headers-when-using-select-into-outfile) – P.Salmon Mar 27 '20 at 15:01
it is fetching all the user submitted data just that the column names are not getting printed is what i am saying – stella goldsmith Mar 27 '20 at 15:08
its just showing the data without any header names – stella goldsmith Mar 27 '20 at 15:09
I get that what don't you get about using select data..union select headers ? – P.Salmon Mar 27 '20 at 15:10
nevermind got it sorted – stella goldsmith Mar 27 '20 at 15:13

column names not getting exported into csv but data does

0 Answers0